sheetjs/sheetjs.github.io

:goberserk: SheetJS Spreadsheet Parser/Writer tests and demos

sheetjs.github.io

Source for the website http://oss.sheetjs.com

Stress tests are available at http://oss.sheetjs.com/stress.html

sheetjs.github.io's Issues

DateTimes in CSV are changed

I mentioned an issue at SheetJS/sheetjs#1260 (comment), which from what I understand was only partially fixed. When I open the following CSV at http://oss.sheetjs.com, the times are removed from the DateTimes.

Input

"ID","TimeStamp"
1,"9/7/2018 10:52"

Output

| ID | TimeStamp |
|----|-----------|
| 1  | 9/7/2018  |

What is strange is that this only happens for CSV, not for XLSX files. If anything, I would expect the reverse. A CSV file to me is already as flat as data should get.

Admittedly, the main reason I mention this is because I ran into this on my own site. I attempted to work around it by specifying cellDates: true and raw: false, but those didn't work for me. Am I missing something? Is the above desired behavior?

Consider using SlickGrid

https://github.com/mleibman/SlickGrid

Excel 2003 Spreadsheet

Some files from Excel 2003 are not recognized as valid files ...

IE8 support

Very cool libraries! Do you plan on adding IE8 support?

implement merge cells

HOT 0.11 now supports merge cells

Synchronous tests for browser

... or a way to run one test at a time

Limit the data area

First of all, fantastic library! Good job!

The "issue" is not the case, it's more a suggestion.

1. The user browse/drops the excel file.
2. Modal window requests to specify:

2.1 Header row(optional) - e.g. A2:D2
2.2 Data area(required) - e.g A3:D400

1. Checkbox "Until the first blank row" (in case user has multiple tables on 1 page)

I am working with very big files and reading the entire file if the user requires only first 3(!) rows takes too much time. What I have done is I break the sequence before the cell parsing and return the sheets array so user could select a reading sheet as well. When all data is gathered, here is the tricky part, I start the reading again with limits set, where cell has to match chosen sheet and r:c limits. It's definitely not the best solution, but if you want I could share it by the time I am done. I still have to run some testing.

P.S. For some reasons I could never achieve "d" as a cell type. So trying to fix that by creating my own cell pattern to match.

P.S.S Very good job! Exquisite!

P.S.S.S English is not my native language

Export to XLSX

Very nice utility! Is there a way to export the file as XLSX?

how to use the sheetJS? for example, have a demo?

Performance issue in converting excel to json

var data = new Uint8Array(arraybuffer);
  var arr = new Array();
  for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);
  var bstr = arr.join("");

  /* Call XLSX */
  var workbook = XLSX.read(bstr, {type:"binary"});

I am working converting an excel sheet to json. this excel sheet contains 2000 rows and 6 columns I am using fileReader on ie11 and I followed the demo in the documentation and it is working fine for 100 columns but it gets stuck for this excel. Can we optimize it any how

CSV / DSV parser

DIF files

Excel and other spreadsheet apps support the Data Interchange File format (I think it dates back to VisiCalc )

Limit the data area

h/t @RomanShabanov

See SheetJS/sheetjs#63

How to format Date

Date.xlsx

Here i am attaching excel file which contains two date columns.
When i read this file i am passing dateNF format. But sheetjs is not converting to required format.

Stress test does not run in IE6

Very nice project! I tried IE6 but the stress test page fails to load. Any idea why?