Eric P Sheets

`xlsx.zahl` exports a default string while the `cpexcel` scripts export the same shape as the main codepage library https://github.com/SheetJS/js-codepage/blob/master/types/index.d.ts . For the purposes of this patch, just include the types...

[4dd092a](https://github.com/SheetJS/sheetjs/commit/4dd092a076e23c5ddc40ef1469af9d8578ed4e6a) cherry-picks the first two changes. Is there a simple project template to verify correctness?

Tested in a simple svelte+TS app and the types seem to work using the changes from 1491302.

If you know that in advance, you can copy one of the utility functions like `sheet_to_json` and flip the order of the loops. The underlying files are always stored in...

https://docs.sheetjs.com/docs/api/utilities#array-of-arrays-input needs to clarify the logic: - Strings are mapped to string cells ("abc" -> `{v: "abc", t: "s"}`) - Numbers are mapped to numeric cells (123 -> `{v: 123,...

Probably should have explained the choices with an example. Suppose we were talking about a cell like: ```js { t: "s", v: 123456, z: "#,##0" } ``` If this were...

Google Sheets does not currently import XLSB but does import XLS (so we'd need to check that behavior, but that can happen in a different issue/PR) External links seem to...

Testing today (2022-09-23): - External links to sites work without display - `mailto` links work without display - Local links are lost (irrespective of display setting) - Internal single-cell /...

Most likely the file actually stores an error in the cell and Excel recomputes the value when you open the file. Can you share a sample file?

So to be clear, this library reads whatever data is stored in the file. It doesn't attempt to perform Excel calculations (we actually have a paid component to handle calculating...