SpreadJS Features

• The Industry Leader in Spreadsheets - 25+ years of experience creating award-winning spreadsheets for professional developers
• Deliver True Excel-like Spreadsheet Experiences, Fast - Import, modify and export your most complex Excel .xlsx spreadsheets. SpreadJS offers a complete Excel-like experience, including tables, charts, shapes, sparklines, conditional formatting, filtering, and an extensive library with no Excel dependencies to create the most advanced data visualizations.
• Powerful Calculation Engine Includes 500+ Built-in Functions in 19 Languages - SpreadJS offers a complete function library that includes statistical and financial functions, dynamic arrays, and custom user-defined functions optimized for big data, complex calculations, and advanced Excel models.
• Total Document Control - Optimized to work in the browser for large and complex spreadsheet models, you can secure, manage, control and help eliminate risk while keeping the same spreadsheet functionality and ease of use your users love online.
• A Complete Toolbox in One Spreadsheet Control - Leverage the extensive JS spreadsheet library API and powerful calculation engine to create analysis, budgeting, dashboard, data collection and management, scientific, healthcare, education, financial applications, and more.
• Easiest and Most Effective Way to Analyze Data - Pivot Tables - SpreadJS includes full support for Pivot Tables, including the import and export of Excel pivot tables. This optional deployment add-on is a powerful data analysis tool used to group, calculate, summarize, and present large amounts of data. Fully customize your application’s needs with SpreadJS’s optional deployment add-on components for Pivot Tables UI, and an Excel-like Designer ribbon, allowing your users to perform complex interactive analysis and data visualization.
• Create Dynamic Snapshot for Great Looking Dashboards - Camera shape works like a standard shape, including Excel import/export, grouping/ungrouping, copying/pasting, and cross-sheet support. Helpful in observing changes in a spreadsheet, even when those changes aren't currently displayed, like showing a dashboard or report with data in other sheets.
• Import/Export Excel Files in JavaScript Spreadsheet - No JavaScript spreadsheet is complete without full Excel import/export support. Import your most advanced Excel spreadsheets and export your SpreadJS spreadsheet to XLSX, all with zero dependencies on Excel.
• Visualize Data with Charts and Sparklines - Offer insight into your data with interactive charts and sparklines. With most Excel charts, interactions, and animations, your dashboards and analytical spreadsheets come to life. Now includes Image, HIstogram, and Gauge KPI sparklines.
• Better Excel Experiences - Take advantage of tables, filtering, conditional formatting, and shapes to offer an expanded Excel-like experience.
• Code-Free Extensibility and Customization with the SpreadJS Designer - Quickly design a complex spreadsheet layout using a familiar UI with the desktop designer app - no learning curve required. You can also load your existing Excel .xlsx template files and start being productive immediately for desktop and the web
• Optimize Your Web App Size and Speed in any Browser - SpreadJS is modular, so you only need to add what you use to your JavaScript spreadsheet apps, and this client-side component works in Windows, Linux, Mac, Android, iOS, and is tested for all modern browsers.
• Built-In Globalization - Select from the available cultures, create your own custom culture or use the CalcEngine Language pack to localize your applications. Adjust date masks, languages, number separators, currencies, enter functions using the local language, and more.
• Pure JavaScript with TypeScript, Angular, Vue, and React Support - With no external libraries or frameworks like jQuery, your JavaScript spreadsheets are light, customizable, and easy to use in VSCode - and include support for Angular, React, and Vue.
• Embed an Excel-like Ribbon in Web Applications - In addition to the spreadsheet component, SpreadJS offers an optional deployment add-on Designer Component that allows developers to provide users a fast and flexible way to customize a spreadsheet easily in a few clicks.
• High-performance DataTable with a Spreadsheet Calculation Engine - SpreadJS's TableSheet component, a powerful DataTable with a built-in spreadsheet calculation engine for high-performance data binding. This component also includes a robust SpreadJS Data Manager for sorting, filtering, and other data management functions.