Eric P Sheets
                                            Eric P Sheets
                                        
                                    npm inc froze the publishing accounts, so for all intents and purposes [`xlsx`](https://www.npmjs.com/package/xlsx), [`xlsx-cli`](https://www.npmjs.com/package/xlsx-cli), [`crc-32`](https://www.npmjs.com/package/crc-32), [`printj`](https://www.npmjs.com/package/printj), [`codepage`](https://www.npmjs.com/package/codepage), [`cfb`](https://www.npmjs.com/package/cfb), [`ssf`](https://www.npmjs.com/package/ssf), and the rest are stuck. Since `xlsx-cli` is a CLI tool...
https://docs.sheetjs.com/docs/demos/cli describes how to build a dedicated executable using `deno compile` or NodeJS based command-line tool builders.
Under the hood, Excel actually stores numbers. The number format is what makes values act like dates. If the origin of the worksheet is a file (you called `read` or...
The file formats do not have an option to recalculate width on read. You can use VBA for it by calling the sheet `.Range("A:Z").EntireColumn.AutoFit` OR you can set the `wch`...
Column widths are nontrivial: https://docs.sheetjs.com/#column-properties (read this first) As an auto-fit example, try setting A1 to "iiiiiiiiii" (10 lowercase letter i) and setting B1 to "wwwww" (5 lowercase letter w),...
@JonArnfred the big issue with `measureText` is that the system-wide Calibri font (present in the various TTFs that ship with Office) do not have the same metrics as the "Calibri...
File formats don't have a flag to recalculate widths on open, so any "automatic width" approach has to be calculated when generating the spreadsheet file. The naive method of looking...
That is probably an issue with Numbers XLSX import codec. To be sure, can you construct something Numbers would accept? To do this: 1) after reading the documentation, do something...
Samples: - [Types.numbers.zip](https://github.com/SheetJS/sheetjs/files/8884704/Types.numbers.zip) (rename to Types.numbers) - [Types.xls](https://github.com/SheetJS/sheetjs/files/8884700/Types.xls) - [Types.xlsx](https://github.com/SheetJS/sheetjs/files/8884701/Types.xlsx) To find the formats, run in NodeJS: ```js > require("xlsx").readFile("Types.xlsx", {cellNF: true, sheetStubs: true}).Sheets["Sheet 1"].A3.z 'm/d/yy h:mm AM/PM' > require("xlsx").readFile("Types.xlsx",...
https://docs.sheetjs.com/docs/installation/ 0.18.9 (which does not include the commit) was pushed on Jun 9. We are aiming for 0.19.0 with some much-needed date changes, but could release a 0.18.10 if Numbers...