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
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.