Undeclared variable QUOTE

[sfmoreno]

Hi, there's an error in the line 21524 of the file xlsx.js. The variable QUOTE is not declared, and this generates an error when you build a project using this library.

var APOS = "'"; QUOTE = '"'

It looks like a typo, I just changed the ; for a , and it works perfectly.

Thanks.

[ShanaMaid]

welcome to pr!

[mephasor]

Did I miss something or is the typo still there?

[pascalgn]

@ShanaMaid I've created a PR for it: #10 🙏

[JJWins]

@ShanaMaid Please merge this, I am not able to use this library due to this type error.

Please take a look at the images below

[WiharlleyWill]

Use XLSX lib.

`import * as XLSX from 'xlsx';
...

exportToExcel() {
const fileName = 'test.xlsx';

	const ws: XLSX.WorkSheet = XLSX.utils.json_to_sheet(this.arr);
	const wb: XLSX.WorkBook = XLSX.utils.book_new();
	XLSX.utils.book_append_sheet(wb, ws, 'test');

	XLSX.writeFile(wb, fileName);

}
`

[SweydManaf]

has vulnerabilities

[sagarpatelpro]

I have a work around.
Just declare "QUOTE" as global variable.

In my case, I am writing a react application, so I just added it to the index.html file.

In index.html file, before including any other source code script.
<script type="text/javascript"> var QUOTE; </script>