sheet.getRows() limit column

[quarkhadron]

Is it possible to limit the column when getting roles?

I've been checking the docs and could not find any way to limit the columns, only able to limit the rows

[theoephraim]

That's not currently an option, although it wouldn't be too hard to add an option to sheet.loadHeaderRow()

[quarkhadron]

Currently, the sheet I'm accessing is read-only and it has duplicated header rows so I wanted to limit the column it would read

[quarkhadron]

@theoephraim Sir?

[theoephraim]

My first suggestion would be to just update the sheet... Or ask whoever has access to edit the sheet to do so.
Otherwise, you could use the cell-based methods to read the cells, although it's not quite as easy.

Or you can fork the repo and add the functionality (and open a PR hopefully)

I'll certainly try to add it when I can, but I can't make any promises on when that would be. Given this is the first request for this functionality in over 10 years of this tool existing, I don't think it's a very common need.