Eric P Sheets

Results 207 comments of Eric P Sheets

```js XLSX.write(workBook, {bookType: "csv", type: "string"}); // CSV as a JS string XLSX.utils.sheet_to_csv(workSheet); // CSV from a worksheet (JS string) ``` `binary` will encode as binary strings. When using `writeFile`,...

Does the same thing happen with CSV (using `sheet_to_csv` or `write({bookType: "csv", type: "string"})`? In either case, can you share a sample? `JSON.stringify(results)` should be sufficient to test. If you...

Please test the following: ```js results = XLSX.utils.sheet_to_txt(workSheet, {type: "string"}); ``` If this works, the issue can be resolved with a small patch to https://github.com/SheetJS/sheetjs/blob/master/bits/90_utils.js#L153 (feel free to submit a...

The result is a plain JS object, you can directly inspect it. To get a specific cell, you can index with an Excel address: ```js var A1 = workSheet["A1"]; ```...

NetSuite support was verified working in 0.16.1 and there was no change to the RequireJS logic since then. Is there some reported error?

Support for locale-aware value parsing is definitely a goal, but currently we don't have support for that. CSV parsing requires this type of value logic, and there's a very rough...

The format has 2 parts. Normally, without a conditional, the second part handles negative values. As an example, using the format `0;0`, -1 is actually rendered as `"1"` (no negative...

Same problem: ```python >>> ssf.format('[>=-1]0;0', -2) '-2' ``` According to Excel 2019 for Mac and Excel 2019 for Windows, using the format `[>=-1]0;0`, -2 is rendered as "2" (no negative...

Keep the reports coming :) These were generated from an older version of Excel (I want to say 2011/2013 but some might've been from older versions), we'll go back and...

What are your computer regional settings? On a mac set to New York, NY, USA, I generated the following file: [fmt14.xlsx](https://github.com/SheetJS/ssf/files/5321108/fmt14.xlsx) `A1=TODAY()` The format is using code 14: