Advanced Excel-Like Functionality With Angular Spreadsheet Components

Unlike other Angular spreadsheets, SpreadJS provides complete support for Excel files. Load complex Excel files, make changes, and export to a file or save the data to a database.

• Import and Export an Excel File (view docs)
• Import your Excel file using the Spread Designer

SpreadJS supports extensive formatting at the cell level. Format any cell properties, including the cell type, font, font size, border, colors, alignment, word wrap, indentation, cell padding and labels, orientation, validation, tags, comments, and more.

• Edit font, font size, font-weight, and font style
• Cell drop-downs
• Cell types

With over 500+ built-in functions, custom functions, dynamic arrays, indirect/aggregate/async functions, formula textboxes, and support for international function names, SpreadJS Is ready to support your most demanding calculations needs.

• Function Language Packages (view docs)
• Dynamic Arrays (view docs)

With the built-in filter dialog, users can automatically filter their data or create custom filters to show and hide the relevant data as per your application's needs.

• Create a basic filter
• Custom filter actions

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.

Slicers offer an intuitive visual way to filter your data and indicate the currently filtered state. Multiple slicer types for charts and hierarchical/tree information are available and can be used to recreate filtering options used on consumer websites.

• Item Slicer
• Aggregation Slicer
• Amazon-style Slicer
• Table Slicer

Visualize your data using the most popular 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.

• Combo Chart
• JS TreeMap Chart

Sparklines provide a way to visualize data, such as trends at the cell level. Sparklines include Cascade, BoxPlot, Bullet, HBar and VBar, Pareto, Pie, Area, Scatter, Spread, Stacked, Vari, Compatible, Month, Year, and custom sparklines.

• Settings Sparkline
• Barcode Sparkline

SpreadJS includes support for many of the Excel shapes and advanced functionality using data-driven shapes. Dynamically generate and create interactive shape properties using data from a database or other data source.

• Group shapes
• Dynamically driven shapes

SpreadJS makes it easy for your users to enter data by using AutoFill to automatically fill similar data or increment the values in adjacent values. You can also use custom fill to load the data at runtime programmatically.

• Basic drag-fill
• Custom drag-fill a range

Use conditional formatting to highlight important information automatically or easily spot trends in your data using the values you specify. SpreadJS supports the import and export of many of the Excels’ rules.

• Use conditional formatting
• Create conditional rules

Use an outline to group and summarize data. You can create an outline of rows or columns. Expand or collapse these groups to show and hide relevant data as needed.

• Group content into outlines
• Customize outlines

SpreadJS supports most of the borderline styles commonly found in Excel, such as dashDot, dashDotDot, dashed, dotted, double, empty, hair, medium, mediumDashDot, mediumDashed, SlantedDashDot, thick, and thin.

• Add borders and gridlines to worksheets

Tables make it easier to manage and analyze related data. Like Excel, SpreadJS supports tables features like auto-expand, conditional formatting, data validation, built-in context menu, and more.

• Add an Excel-like table
• Create a custom table