Retain Empty Rows

[krausekai]

Empty rows are removed, returning only non-empty rows in the spreadsheet. Can non-empty rows be kept, but only up until the last non-empty row entry?

[chriszarate]

This is the behavior of the underlying API, unfortunately. You could try putting non-breaking spaces in the "empty" rows you want to preserve.

[krausekai]

That would be hard-coding which rows are to be empty, correct? As the returned object does not seem to return row names, which would be possible to find missing rows and mark them as empty.

[chriszarate]

Yes, hard-coding is the only solution I am aware of.

[krausekai]

Alright, thanks for the information.