Read the specified sheet from the file #704

New Issue

2017-06-21T06:14:05Z

xxScorpion commented

2017-06-21 06:14:05 +00:00

(Migrated from github.com)

I can read only the list of sheet names. How can I load data from this sheet only by not loading the entire file?

SheetJSDev commented

2017-06-21 06:32:46 +00:00

(Migrated from github.com)

Currently there is no such option (you have to read the entire book), but that would be a nice feature if you knew in advance what sheet you wanted.

Out of curiosity, what would happen if the workbook didn't have the specified sheet? Throw an error? Return an empty workbook?

Currently there is no such option (you have to read the entire book), but that would be a nice feature if you knew in advance what sheet you wanted. Out of curiosity, what would happen if the workbook didn't have the specified sheet? Throw an error? Return an empty workbook?

xxScorpion commented

2017-06-21 07:41:08 +00:00

(Migrated from github.com)

An empty book will also be arranged.
I planned two passes.
1.Get list of available worksheets
2.If there is a need, then download ...

An empty book will also be arranged. I planned two passes. 1.Get list of available worksheets 2.If there is a need, then download ...

reviewher commented

2022-02-13 00:08:33 +00:00

(Migrated from github.com)

sheets option can take one or more indices or names:

    /** If specified, only parse the specified sheets or sheet names */
    sheets?: number | string | Array<number | string>;

[`sheets` option](https://docs.sheetjs.com/) can take one or more indices or names: ```typescript /** If specified, only parse the specified sheets or sheet names */ sheets?: number | string | Array<number | string>; ```

Sign in to join this conversation.