Overview of SpreadJS a JavaScript Spreadsheet ComponentDeliver true spreadsheet experience, fast - with zero dependencies on Microsoft® Excel®. Create financial apps, dashboards, charts, pivot tables, performance benchmarks, science lab notebooks, and other similar JavaScript spreadsheet applications
Popular Features & HighlightsSpreadJS includes a comprehensive Calculation Engine that supports 500+ built-in functions, custom functions, array functions, dynamic arrays, formula textbox, localized language function names, most Excel functions, and more. SpreadJS offers the most complete support for importing and exporting your Excel files. Load your most complex Excel (XLSX) files in JavaScript, make changes, and export to an Excel file or save the data to a database. SpreadJS supports the current versions of Excel as well as multiple Excel file formats, including Excel (XLSX), comma-delimited (CSV), JSON, and text (TXT). TableSheet is a separate high-performance DataTable that incorporates the power of a spreadsheet calculation engine to handle your most demanding data binding needs. The SpreadJS Data Manager is a powerful new data engine API built for performance—making connecting and interacting with bound data more straightforward. NEW! PivotTables Add-OnImport and export Excel PivotTables in existing Excel files. Use this powerful data analysis tool to group, slice, calculate, summarize, and present large amounts of data. JavaScript developers can embed a ribbon bar and UI functionality into their applications, making it easy for customers to customize the spreadsheet. The Designer Component is fully customizable, allowing developers to add buttons, tabs, context menu items, and dialogue boxes or customize the existing ones. Visualize your data using the most popular spreadsheet charts. Supported charts include Column, Line, Pie, Area, Bar, XYScatter, Stock, Combo, Radar, Sunburst, and Treemap, with additional support for trendlines, error bars, and other customizations. The charts can also be imported or exported to Excel files. Tables make it easier to manage and analyze related spreadsheet data. Like Excel, SpreadJS supports tables with support for AutoExpand, conditional formatting, data validation, a built-in context menu, fixed scrolling headers, table resize and navigation, total summary row, and more. Provide a graphical representation of your data in a single cell using Sparklines. Embed these small charts into any cell to quickly show trends in your data, such as increases and decreases, minimum and maximum values, stock levels, costs, and more. Print and Export to PDF SupportSelect from a wide range of printing options to customize the printing of your spreadsheets. Spreadsheets also supports printing to PDF documents. You can even take ultimate control of the printing in your code using the owner print drawing support to easily create reports on your data. Take control of your data entry using SpreadJS's cell types and data validation. Users can create validators in order to validate the data input and restrict the invalid information. Cell types define the type of information in a cell, how that information is displayed, and how the user can interact with. Use the powerful desktop Designer to create templates and spreadsheets for your application, or use the SpreadJS Designer Component Add-on to provide that UI to your users. Create flowcharts, process diagrams, cell callouts, and more with over 180 shapes, lines, and arrows. Connect and combine into Group Shapes to design logos or custom dashboard controls that can be scripted to perform user actions. SpreadJS supports binding individual sheets, tables, and cells to a Data Source instance, object arrays of data, which allows you to quickly bring data from external data sources into the Spreadsheet and edit it. You can also use the SpreadJS Designer to create a binding relationship to the data with a template. SpreadJS allows developers to fully customize the UI elements and manage the behavior of the spread control by implementing Events types to intercept a change or click in the viewport. Additional ResourcesThe mission of MESCIUS is to provide customers with the premier studio of innovative UI controls, tools, and solutions including deep functionality reporting, analysis, and spreadsheet platforms. Also provides the best .NET reporting solution available, ActiveReports; the fastest spreadsheet solution, Spread; 300+ .NET UI control collection, ComponentOne; 80+ JavaScript UI controls in Wijmo; and Document Solutions for Word, PDF, Imaging, and Excel. us.sales@mescius.com | developer.mescius.com | 800.858.2739 | 412.681.4343 |