node-google-spreadsheet icon indicating copy to clipboard operation
node-google-spreadsheet copied to clipboard

loadCells then getRows?

Open Frankusky opened this issue 1 year ago • 0 comments

I have an issue, lets say I have a sheet with two tables of data, for example, something like this: image

I just want to get A2:B3 data, so what im making is sheet.loadCells("A2:B3"), but how can I loop over each row cell? I see the only way is to use getCell or getCellByA1 manually... there is no other method that can return like an array of arrays? for example, something like

[
  [123, 345],
  [asd, rgt]
]

Frankusky avatar Jul 30 '22 01:07 Frankusky