Sometimes, we want to parse Excel (XLS) files in JavaScript and HTML5.
In this article, we’ll look at how to parse Excel (XLS) files in JavaScript and HTML5.
How to parse Excel (XLS) files in JavaScript and HTML5?
To parse Excel (XLS) files in JavaScript and HTML5, we use the read-excel-file
package.
To install it, we run
npm i read-excel-file
Then we add an input with
<input type="file" id="input" />
Next we weite
import readXlsxFile from "read-excel-file";
const input = document.getElementById("input");
input.addEventListener("change", async () => {
const data = await readXlsxFile(input.files[0]);
console.log(data);
});
to get the file input with getElementById
.
Then we call addEventListener
to listen for the change event with an event listener.
In the event listener, we call readXlsxFile
with the selected file we get from input.files[0]
We get the read Excel file’s content from the promise returned with await
.
Conclusion
To parse Excel (XLS) files in JavaScript and HTML5, we use the read-excel-file
package.