XLSX
You might experience differences from the original files due to known limitations, depending on the file format and non-implemented features. We are constantly improving based on our users' feedback, so feel free to submit any improvement requests
Click in the button below to create a local web-based spreadsheet from a XLSX file.
Requires the parser extension included on the Enterprise Plan
<html> <script src="https://jspreadsheet.com/v12/jspreadsheet.js"></script> <script src="https://jsuites.net/v6/jsuites.js"></script> <link rel="stylesheet" href="https://jspreadsheet.com/v12/jspreadsheet.css" type="text/css" /> <link rel="stylesheet" href="https://jsuites.net/v6/jsuites.css" type="text/css" /> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" /> <script src="https://cdn.jsdelivr.net/npm/jszip@3.6.0/dist/jszip.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/parser/dist/index.min.js"></script> <div id="table1"></div> <input type="file" name="file" id='file' style="display: none"> <input type='button' value='Load a XLSX file from my local computer' id="loadlocal"> <script> // Set license jspreadsheet.setLicense('ZGQ5MjZjZWVhY2FlOGEzOTViM2MwZThiMGYwNDM5MDVlZjg4ZTJlZDk5YjMyOWQ2NWQ3MWJlMmUyYjI1ODc3MjkzYmY0MjkxMjY5NDQxNjc0OTg2MTg2NTQyMDViMWE4ZDc4YjMzMTZlNjYyNjgzMDkyZGQ2MjExYWMzMDc0NTEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpjME1UYzNNalkxTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2liRzlqWVd4b2IzTjBJbDBzSW5Cc1lXNGlPaUl6TkNJc0luTmpiM0JsSWpwYkluWTNJaXdpZGpnaUxDSjJPU0lzSW5ZeE1DSXNJbll4TVNJc0luWXhNaUlzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElpd2ljR2wyYjNRaVhTd2laR1Z0YnlJNmRISjFaWDA9'); // Set extensions jspreadsheet.setExtensions({ parser }); // Create the spreadsheet from a local file let load = function(e) { // Parse XLSX file and create a new spreadsheet jspreadsheet.parser({ file: e.target.files[0], // It would be used to updated the formats only locale: 'en-GB', onload: function(config) { jspreadsheet(document.getElementById('table1'), config); }, onerror: function(error) { alert(error); } }); } document.getElementById("loadlocal").onclick = () => document.getElementById('file').click() document.getElementById("file").onchange = (event) => load(event) </script> </html> import React, { useRef } from "react"; import { jspreadsheet } from "@jspreadsheet/react"; import parser from "@jspreadsheet/parser"; import "jsuites/dist/jsuites.css"; import "jspreadsheet/dist/jspreadsheet.css"; // Set license jspreadsheet.setLicense('ZGQ5MjZjZWVhY2FlOGEzOTViM2MwZThiMGYwNDM5MDVlZjg4ZTJlZDk5YjMyOWQ2NWQ3MWJlMmUyYjI1ODc3MjkzYmY0MjkxMjY5NDQxNjc0OTg2MTg2NTQyMDViMWE4ZDc4YjMzMTZlNjYyNjgzMDkyZGQ2MjExYWMzMDc0NTEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpjME1UYzNNalkxTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2liRzlqWVd4b2IzTjBJbDBzSW5Cc1lXNGlPaUl6TkNJc0luTmpiM0JsSWpwYkluWTNJaXdpZGpnaUxDSjJPU0lzSW5ZeE1DSXNJbll4TVNJc0luWXhNaUlzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElpd2ljR2wyYjNRaVhTd2laR1Z0YnlJNmRISjFaWDA9'); // Set extensions jspreadsheet.setExtensions({ parser }); export default function App() { // Spreadsheet array of worksheets const spreadsheet = useRef(); // Create the spreadsheet from a local file const load = function(e) { // Parse XLSX file and create a new spreadsheet jspreadsheet.parser({ file: e.target.files[0], // It would be used to updated the formats only locale: 'en-GB', onload: function(config) { jspreadsheet(spreadsheet.current, config); }, onerror: function(error) { alert(error); } }); } // Render component return ( <> <div ref={spreadsheet}></div> <input type={"file"} name={"file"} id={"file"} onChange={load} style={{ display: 'none' }} /> <input type={"button"} value={"Load a XLSX file from my local computer"} onClick={() => document.getElementById("file").click()}/> </> ); } <template> <div ref="sheetEl"></div> <input ref="file" type="file" name="file" style="display: none" @change="load" /> <input type="button" value="Load a XLSX file from my local computer" @click="file.click()"/> </template> <script> import { ref, onMounted } from "vue"; import jspreadsheet from "jspreadsheet"; import parser from "@jspreadsheet/parser"; import "jspreadsheet/dist/jspreadsheet.css"; import "jsuites/dist/jsuites.css"; jspreadsheet.setLicense("ZGQ5MjZjZWVhY2FlOGEzOTViM2MwZThiMGYwNDM5MDVlZjg4ZTJlZDk5YjMyOWQ2NWQ3MWJlMmUyYjI1ODc3MjkzYmY0MjkxMjY5NDQxNjc0OTg2MTg2NTQyMDViMWE4ZDc4YjMzMTZlNjYyNjgzMDkyZGQ2MjExYWMzMDc0NTEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpjME1UYzNNalkxTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2liRzlqWVd4b2IzTjBJbDBzSW5Cc1lXNGlPaUl6TkNJc0luTmpiM0JsSWpwYkluWTNJaXdpZGpnaUxDSjJPU0lzSW5ZeE1DSXNJbll4TVNJc0luWXhNaUlzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElpd2ljR2wyYjNRaVhTd2laR1Z0YnlJNmRISjFaWDA9"); jspreadsheet.setExtensions({ parser }); export default { name: "Jspreadsheet", setup() { const sheetEl = ref(null); const file = ref(null); const load = (e) => { jspreadsheet.parser({ file: e.target.files[0], locale: "en-GB", onload: function (config) { jspreadsheet(sheetEl.value, config); }, onerror: function (error) { alert(error); }, }); }; return { sheetEl, file, load, }; }, }; </script> import { Component, ViewChild, ElementRef } from "@angular/core"; import jspreadsheet from "jspreadsheet"; import parser from "@jspreadsheet/parser"; // You can use the following license for quick testing on localhost, StackBlitz, or CodeSandbox. // The license is valid for one day, after which the spreadsheet will become read-only. // For a longer trial period, you can create a free account and generate a demo license with an extended expiration date. jspreadsheet.setLicense('ZGQ5MjZjZWVhY2FlOGEzOTViM2MwZThiMGYwNDM5MDVlZjg4ZTJlZDk5YjMyOWQ2NWQ3MWJlMmUyYjI1ODc3MjkzYmY0MjkxMjY5NDQxNjc0OTg2MTg2NTQyMDViMWE4ZDc4YjMzMTZlNjYyNjgzMDkyZGQ2MjExYWMzMDc0NTEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpjME1UYzNNalkxTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2liRzlqWVd4b2IzTjBJbDBzSW5Cc1lXNGlPaUl6TkNJc0luTmpiM0JsSWpwYkluWTNJaXdpZGpnaUxDSjJPU0lzSW5ZeE1DSXNJbll4TVNJc0luWXhNaUlzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElpd2ljR2wyYjNRaVhTd2laR1Z0YnlJNmRISjFaWDA9'); // Set the extensions jspreadsheet.setExtensions({ parser }); @Component({ standalone: true, selector: "app-root", template: `<div #spreadsheet></div> <input #file type="file" name="file" style="display:none" /> <input type="button" value="Load a XLSX file from my local computer" (click)="openFile()"/>` }) export class AppComponent { @ViewChild("spreadsheet") spreadsheet: ElementRef; @ViewChild("file") file: ElementRef; ngAfterViewInit() { let spreadsheet = this.spreadsheet.nativeElement; // Add event to the file input this.file.nativeElement.onchange = function (e: any) { // Parse XLSX file and create a new spreadsheet jspreadsheet.parser!({ file: e.target.files[0], locale: "en-GB", onload: function (config) { jspreadsheet(spreadsheet, config); }, onerror: function (error) { alert(error); } }); }; } openFile() { this.file.nativeElement.click(); } }