
Export to XLSX
The JSS render is a premium extension to export the data from a JSS spreadsheet to an XLSX file.Settings
Property | Description |
---|---|
filename: string | File name. Default: jspreadsheet.xlsx |
onbeforerender: function(spreadsheetConfig) => spreadsheetConfig | Intercept the render to overwrite and spreadsheet configuration. |
onbeforesave: function(blob) => boolean | void | Intercept the file generation. |
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/render/dist/index.min.js"></script> <div id='spreadsheet'></div> <input type="button" value="Download" onclick="download()"/> <script> const download = function() { jspreadsheet.render(document.getElementById('spreadsheet'), { filename: 'file.xlsx', }); } // License for Formula Plugin jspreadsheet.setLicense('MzkyMmIyNTkyYjQyNjM4MDJiMmM0ZmZiZTFhNGI4NDlmMmJmNmQzZmE1ZDFmMTA0ZDkyNjJhNTY3OTM5ZDlhMmMxY2Q5YjExZjFkYTNhZTkyOWI4MjBiNjhiMGNkYzAzN2RmMzc4YjNkYjRmYTRkNWJhYzgyYmQ0ZDBhZjg3ZDksZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTRNRGs1T1RNNU9Dd2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0='); // Add-on for Jspreasheet jspreadsheet.setExtensions({ render }); // Create the spreadsheets jspreadsheet(document.getElementById('spreadsheet'), { worksheets: [ { minDimensions: [10, 10] }, { minDimensions: [10, 10] }, ], }); </script> </html>
// Working example: https://codesandbox.io/s/online-spreadsheet-with-react-and-jss-us1cm // Jspreadsheet Pro import jspreadsheet from 'jspreadsheet'; // Importer JSS Render import render from '@jspreadsheet/render'; // Add a valid license jspreadsheet.setLicense('MzkyMmIyNTkyYjQyNjM4MDJiMmM0ZmZiZTFhNGI4NDlmMmJmNmQzZmE1ZDFmMTA0ZDkyNjJhNTY3OTM5ZDlhMmMxY2Q5YjExZjFkYTNhZTkyOWI4MjBiNjhiMGNkYzAzN2RmMzc4YjNkYjRmYTRkNWJhYzgyYmQ0ZDBhZjg3ZDksZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTRNRGs1T1RNNU9Dd2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0='); // Start the JSS plugin jspreadsheet.setExtensions({ render }); // Create a spreadsheet jspreadsheet(document.getElementById('spreadsheet'), { worksheets: [ { minDimensions: [10, 10] }, { minDimensions: [10, 10] }, ] }); // Call this method to create a XLSX file let download = function() { // The method should receive the spreadsheet DOM element jspreadsheet.render(document.getElementById('spreadsheet'), { filename: 'file.xlsx', }); }