faisalman / simple-excel-js Goto Github PK

Its not working on any version of Internet Explorer. IE is reading/returning empty cell values .

Hi faisalman

Is it possible to read the two csv files by creating one parser within another. I am not able to handle something like this:
var csvParser = new SimpleExcel.Parser.CSV();
var fileInput = document.getElementById('fileInput'); //taking file from user
var file = e.target.files[0];----->I couldnot understand what this does. Could you explain this
csvParser.loadFile(file, function () {
var csvParser2 = new SimpleExcel.Parser.CSV();
var rankInput = document.getElementById('rankInput'); //taking file from user
var file2 = e.target.files[0];
csvParser2.loadFile(file2,function(){
second_parser={r:csvParser2.getSheet()[i][1], g:csvParser2.getSheet()[i][0]};
console.log(csvParser2.getSheet());
});
});

When I read the output using console.log, the first file is read and not the second. Could you let me know if I am making a mistake?

Thanks and Regards
Bharat

As descbribe, I saw that the library could read XLS, XLSX, CVS,...
In sample test I downloaded, I could read .csv properly but .xls, xlsx. The content is incorrect displayed.
How can I modify to read .xls and .xlsx file?

Please help!
Thanks.

Your description states:
"Client-side script to easily parse / convert / write any Microsoft Excel XLSX / XML / CSV / TSV / HTML / JSON / etc formats. "

This package can only write csv and tsv files. You should correct your description so others don't waste an hour like I did trying to write an xls file with your package.

What are the advantages and disadvantages of this over https://github.com/SheetJS/js-xlsx?

Where is the Excel support? I mean, it's in the name for god's sake.

Hi

I am facing an issue where if a cell entry is a multi-line entry, it is not being read / parsed correctly.

Consider a CSV entry like this:

Client Name,Display Name,Phone Number,Email,Notes
ACBDE,-,111,[email protected],"Part 1
Part 2
Part 3
part 4"

The correct parsing is:

Row 1 -> Client Name,Display Name,Phone Number,Email,Notes
Row 2 -> ABCDE,-,111,[email protected],"{multi line entry: Part1\nPart 2\nPart 3\n Part 4}"

But right now it is being parsed as:

Row 1 -> Client Name,Display Name,Phone Number,Email,Notes
Row 2: ABCDE,-,111,[email protected], Part 1
Row 3: Part 2
Row 4: Part 3 
Row 5: Part 4

There's no actual support for writing to excel files, the example given contains references to nonexistent functions

Need example for angular 2. Any suggestion? Thanks.

• I download simple-excel.js to `src/vendor/ folder
• Add

"scripts": ["./vendor/simple-excel.js"],

in angular-cli.json. But I got SimpleExcel not defined error.

Hi,

I think documentation isn't synced with source code.

There isn't XLSX Writer

var Writer = {
        CSV : CSVWriter,
        TSV : TSVWriter
    };

However, documentation says:

var xlsxWriter = new SimpleExcel.Writer.XLSX();

Am I missing something?

How can I convert JSON to XLS. Is there any function exists or what modification I need to do in the plugin ? Please reply me.

This does not actually generate XLSX files. Move on.

If use example from main page get error:

TypeError: SimpleExcel.Writer.XLSX is not a constructor