Spreadsheet - access excel column with letter such as A20

1 Answer 137 Views
Spreadsheet
Vivek
Top achievements
Rank 1
Vivek asked on 04 Jun 2023, 04:28 AM

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,

 

1 Answer, 1 is accepted

Sort by
0
Stoyan
Telerik team
answered on 07 Jun 2023, 02:14 PM

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

As of R2 2023, the default icon type will be SVG instead of Font. See this blogpost for more information.
Tags
Spreadsheet
Asked by
Vivek
Top achievements
Rank 1
Answers by
Stoyan
Telerik team
Share this question
or