
Import from XLSX
The JSS parser is a premium extension to create a JSS spreadsheet from an XLSX file.Settings
Property | Description |
---|---|
url: string | Load the XSLX from a remote URL. Bear in mind any potential CORS restrictions using this property. |
locale: string | Define the decimal and thousand separator based on a locale. |
file: object | load from a local file. This property is used along input type='file' |
onload: function | When the file is loaded. |
onerror: function | Method to be called when something is wrong. |
Author
Jspreadsheet Pro Team.License
Available on the premium or enterprise plan.Installation
Please choose one of the following optionsUsing CDN
Using NPM
<html> <script src="https://jspreadsheet.com/v9/jspreadsheet.js"></script> <script src="https://jsuites.net/v4/jsuites.js"></script> <link rel="stylesheet" href="https://jspreadsheet.com/v9/jspreadsheet.css" type="text/css" /> <link rel="stylesheet" href="https://jsuites.net/v4/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="spreadsheet"></div> <input type="file" name="file" id='file' onchange="load(event)" style='display:none'> <input type='button' value='Load a XLSX file from my local computer' onclick="document.getElementById('file').click()"> <script> // Set license jspreadsheet.setLicense('YWU3ZmJlMGQ5ODlhNGI1MDVhZmQzZGEzZWY5ZDU2YjI4YzE2ZGYwYzhjM2JiYmZjNGJjMDY0MjhiN2M1MmI1YTI1MDY1NDk5ZmM0MjM2ZjkwODEzOGFiY2YwMTI0OTM0NTBkNGQ4ZjYyMGRhMjdjMzQyMzRiNjUxOThhZmUyZjEsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTNOakF3TWpFeE55d2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0='); // Set extensions jspreadsheet.setExtensions({ parser }); // Create the spreadsheet from a local file var 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: 'it-IT', onload: function(config) { jspreadsheet(document.getElementById('spreadsheet'), config); }, onerror: function(error) { alert(error); } }); } </script> </html>
// Jspreadsheet Pro import jspreadsheet from 'jspreadsheet'; // Importer JSS Parser import parser from '@jspreadsheet/parser'; // Add a valid license jspreadsheet.setLicense('YWU3ZmJlMGQ5ODlhNGI1MDVhZmQzZGEzZWY5ZDU2YjI4YzE2ZGYwYzhjM2JiYmZjNGJjMDY0MjhiN2M1MmI1YTI1MDY1NDk5ZmM0MjM2ZjkwODEzOGFiY2YwMTI0OTM0NTBkNGQ4ZjYyMGRhMjdjMzQyMzRiNjUxOThhZmUyZjEsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTNOakF3TWpFeE55d2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0='); // Set extensions jspreadsheet.setExtensions({ parser }); // Create the spreadsheet from a local file var 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: 'it-IT', onload: function(config) { jspreadsheet(document.getElementById('spreadsheet'), config); }, onerror: function(error) { alert(error); } }); }
Examples
Integration with React
Create a NextjS spreadsheet from an Excel XLSX file.Create an Angular spreadsheet from an Excel XLSX file.