Kendo Spreadsheet

1 Answer 158 Views
ActionSheet Data Source Spreadsheet
brajesh
Top achievements
Rank 1
Iron
brajesh asked on 10 Jun 2022, 07:06 AM | edited on 10 Jun 2022, 07:11 AM

1.I want to set multiple sheet tab name every sheet tab name have a different columns and I want this when click on another tab than that data show 

2. how to set validation for model  from json file. Json file also contain sequence of column based on that file column should show is it possible?

3.I'm doing validation like this please check zip file

It's too lengthy code how to handle if dynamically any changes on column please help me to solve out this problem

I have Json file like this please check another zip file.I have a multiple json file i want when i click on sheet tab name than that json file columns and data show

1 Answer, 1 is accepted

Sort by
0
Martin
Telerik team
answered on 15 Jun 2022, 06:55 AM

Hello, Brajesh,

1. Through the insertSheet method, you can dynamically create a new sheet and specify the numbers of columns and rows.

2. Could you elaborate a bit more how and where exactly would you like to make the validation? 

Regards,
Martin
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

brajesh
Top achievements
Rank 1
Iron
commented on 15 Jun 2022, 07:22 AM

Have you seen zip file which i sent to you. I want validation from json file dyanamically and column name also come from json file dyanamically.
brajesh
Top achievements
Rank 1
Iron
commented on 15 Jun 2022, 07:24 AM

can a set validation loop through in kendo spreadsheet ?

 

brajesh
Top achievements
Rank 1
Iron
commented on 15 Jun 2022, 08:40 AM

I want to set validation based on columns but columns should come dynamically that columns also change based on some condition.

 

Martin
Telerik team
commented on 20 Jun 2022, 07:07 AM

You can use the Range value method to set the name of the columns dynamically. For the validation, you can use the Range validation method to set rules for each row under that column. Here is a small example for reference. Let me know if that would be helpful.
Tags
ActionSheet Data Source Spreadsheet
Asked by
brajesh
Top achievements
Rank 1
Iron
Answers by
Martin
Telerik team
Share this question
or