Eric P Sheets

CSV date parsing eventually passes through the Date constructor, and Chrome's parser is notoriously problematic. Can you run `new Date("5.6.2022")` in the browser console to determine which interpretation is used...

To force the string 121212121212121, Excel needs to see `="121212121212121"` (a formula whose result is the desired string). `=121212121212121` is interpreted as numeric, as is `"121212121212121"` Currently, this can be...

`:` is missing from the bad characters list, feel free to submit a PR ```diff --- a/bits/71_wbcommon.js +++ b/bits/71_wbcommon.js @@ -113,7 +113,7 @@ function safe1904(wb/*:Workbook*/)/*:string*/ { return parsexmlbool(wb.Workbook.WBProps.date1904) ? "true"...

The latter solution is preferable (modifying `check_ws_name`). It's preferable to throw the error message as that is consistent with Excel. If you try to rename a worksheet to contain a...

If you can share a file we can take a closer look, but it's likely the case that the cells are explicitly specified and explicitly have an empty string cell...

I am not happy with the performance at all (granted, our first goal was to be correct). There are quite a few slow/inefficient operations that can be improved. When I...

@irfanyounas just so we are on the same page, can you share the script you used?

@irfanyounas how did you create a JS object with 65000 rows? Do you have numbers / text / dates? Are there missing cells (in the example, C2 is missing) or...

@irfanyounas Here's an example writing numbers in a 3x100001 file: http://sheetjs.com/demos/100001.html Dates are printed at 3 times: - just before starting to build the workbook - after the write -...

@irfanyounas http://sheetjs.com/demos/write_num.html?n=1000000 is a more general demo (you can specify the number of rows via the `n` parameter). The runtime appears to be dominated by generating the source array-of-arrays (not...