Read specific set of rows
Openopened 7 years ago by ashwinpoosarla · 4 comments
No Branch/Tag Specified
good first issue
No Assignees1 Participants
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.
No due date set.
No dependencies set.
Reference in New Issue
There is no content yet.
Delete Branch '%!s(<nil>)'
Deleting a branch is permanent. It CANNOT be undone. Continue?
I have used 'sheetRows' properties to read 'n' rows of a sheet but is it possible to read 'n' rows from 'k'the row.
Eg. I want to read 100 rows starting from 500th row. Can this be possible?
@ashwinpoosarla It's not hard but you have to decide on the expectations.
do you write the sheet range as if the file started from A1? Or do you keep the original range from the worksheet?
what do you do with merge cells that start before the block but end in the block? Do you rewrite the merge range?
Note: You still have to scan from the beginning to cover cases like merge cells:
Any positive updates in this? Do we have sheetRowsOffset available?
There are a few concerns with
sheetRowsOffset. In addition to what was mentioned in https://github.com/SheetJS/sheetjs/issues/475#issuecomment-289193604 ,
Should a number of header rows be included with each page? If yes, how many (and should it be programmable)? If no, how would non-AoA processing work? (array of arrays "just work" but array of objects require some feedback on the header labels)
(this technically applies in the no-offset case as well) what does the export look like? For example, if the parser reads rows 501 to 1000, what should the writers generate? Supposing you shift the rows up (so that row 501 -> 1, 502 -> 2, ..., 1000 -> 500), the defined names and other metadata are now incorrect. Another option is to forcefully hide rows 1:500, which clearly modifies the row metadata. Leaving 500 rows blank is also an option, but it does not play nice with some of the API functions that expect data on the first row.
row 501 -> 2, 502 -> 3, ..., 1000 -> 501, with headers. If both metadata would be present in output would be great