rspreadsheet icon indicating copy to clipboard operation
rspreadsheet copied to clipboard

feature wish: method returning last "meaningful" row

Open gorn opened this issue 8 years ago • 2 comments

I guess the title says it all. It would be great to be able to get a range of rows (and perhaps columns) where there are meaningful data. At least something like get_last_row_with_data would do, but an iterator over nonempty rows would be even greater.

gorn avatar Apr 21 '17 14:04 gorn

Aargh, it has already there - see used_rows_range ... nevermind, the iterator would still be great.

gorn avatar Apr 21 '17 14:04 gorn

Ok, more on this. There is actually difference, between used_rows_range and what I need. used_rows_range gets the range which is "technically" used, but it is not the same as the nonempty rows. Typicall example is in an attachement.

used_rows_range.zip

gorn avatar Apr 21 '17 14:04 gorn