Get all cells or rows of a spreadsheet workbook

[Henrik]

When no range is selected how do I then in javaScript get all rows for a spreadsheet ?

This does not work

var values = sheet._rows.values();
for (var row = 0; (row < values.length) ; row++) {

[Dimitar]

Hi,

You may use the range() method to get or set values for cells in that range. Here is a Dojo sample.

Regards,
Dimitar
Telerik by Progress

[Henrik]

Thanks for the answer Dimitar

I know the range method. But how to I get all values in a active spreadsheet without any range selected. I need to loop through all rows

 

[Dimitar]

Hi,

You may iterate over the rows count and columns count and pass the respective indexes to the range() method. Thus, you could avoid hardcoding the range. Still the range method should be used. Here is a Dojo sample. I hope it fits your case.

Regards,
Dimitar
Telerik by Progress