Spreadsheet - access excel column with letter such as A20

[Vivek]

Hi There, 

I'm working on a web app and need to access the Excel column with letters instead of an index. I have gone through the documentation but didn't find how we can access the Excel column with alphabets such as A20

Could you please let me know if you have any functions or not?

 

Thanks,

 

[Stoyan]

Hi Vivek,

Yes, you can utilize the Sheet API's range method. There in the list of the available parameters the first one is reference to the address identical to the one used in Excel:

 var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
 var sheet = spreadsheet.activeSheet(); // Select the currently active sheet.
 var range = sheet.range("A2:A7"); // Select the range of cells from A2 through A7.

For more information on the topic please refer to the Reference Existing Spreadsheet Instances section in the related Getting Started article.

I hope the information above is useful.

Regards,
Stoyan
Progress Telerik