#
Read specific set of rows
#475

Open

opened 7 years ago by ashwinpoosarla
·
4 comments
No Branch/Tag Specified

master

sankhavaramsaitulasiram/feat-fix-2752

maybeswapnil/issue2737

gh-pages

scottysseus/2560_2

ivan-trusov/fix-basedate

nandanv2702/issue_1300

protobi/master

ThomasChan/master

grantfayvor/master

tom-groves/bug-1105/rounding-error

mgreter/master

v0.87

v0.9.9

v0.9.8

v0.9.7

v0.9.6

v0.9.5

v0.9.4

v0.9.3

v0.9.2

v0.9.13

v0.9.12

v0.9.11

v0.9.10

v0.9.1

v0.9.0

v0.8.8

v0.8.7

v0.8.6

v0.8.5

v0.8.4

v0.8.3

v0.8.2

v0.8.1

v0.8.0

v0.7.9

v0.7.7

v0.7.6-i

v0.7.6-h

v0.7.6-a

v0.7.6

v0.7.5

v0.7.4

v0.7.3

v0.7.2

v0.7.11

v0.7.10

v0.7.1

v0.5.9

v0.5.8

v0.5.7

v0.5.10

v0.5.0

v0.4.3

v0.18.6

v0.18.5

v0.18.4+deno

v0.18.4

v0.18.3

v0.18.2

v0.18.1

v0.18.0+deno

v0.17.5

v0.17.0

v0.16.8

v0.16.7

v0.16.6

v0.16.5

v0.16.3

v0.16.2

v0.16.1

v0.16.0

v0.15.6

v0.15.5

v0.15.2

v0.14.0

v0.13.5

v0.13.4

v0.13.3

v0.13.1

v0.13.0

v0.12.9

v0.12.8

v0.12.7

v0.12.6

v0.12.5

v0.12.4

v0.12.3

v0.12.2

v0.12.13

v0.12.12

v0.12.11

v0.12.10

v0.12.1

v0.12.0

v0.11.9

v0.11.8

v0.11.7

v0.11.6

v0.11.5

v0.11.4

v0.11.3

v0.11.2

v0.11.19

v0.11.18

v0.11.17

v0.11.16

v0.11.15

v0.11.14

v0.11.13

v0.11.12

v0.11.11

v0.11.10

v0.11.1

v0.11.0

v0.10.9

v0.10.8

v0.10.7

v0.10.6

v0.10.5

v0.10.4

v0.10.3

v0.10.2

v0.10.1

v0.10.0

No Label

DBF

Dates

Defined Names

Features

Formula

HTML

Images

Infrastructure

Integration

International

ODS

Operations

Performance

PivotTables

Pro

Protection

Read Bug

SSF

SYLK

Style

Write Bug

good first issue

**Milestone**

Set milestone

Clear milestone

No items

No Milestone

**Projects**

Set Project

Clear projects

No project

**Assignees**

Assign users

Clear assignees

No Assignees

**1 Participants**

**Notifications**

**Due Date**

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

**Dependencies**

No dependencies set.

Reference: sheetjs/sheetjs#475

Reference in New Issue

There is no content yet.

Delete Branch '%!s(<nil>)'

Deleting a branch is permanent. It **CANNOT** be undone. Continue?

No

Yes

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.

For example:

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