Advanced Excel-Like Functionality With Angular Spreadsheet Components
Excel-Like Features in Angular
Unleash the power of Excel functionality in your Angular enterprise apps with these dependency-free Angular spreadsheet components. SpreadJS provides industry-leading support for delivering Excel-like experiences in your JavaScript applications with zero dependencies on Excel. Based on 20+ years of creating spreadsheets for enterprise developers, we know what features you need - at the top of the list is Excel compatibility. Create enterprise spreadsheets, grids, dashboards, and forms with the comprehensive API. Includes a powerful calculation engine with 450+ functions.
Import and Export Excel files
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.
Cell Formatting
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.
Advanced Calculations
With over 450+ 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.
Filters
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.
Slicers
Slicers offer an intuitive visual way to filter your data and indicate the currently filtered state. Multiple slicer types for charts, hierarchical information are available and can be used to recreate filtering options used on consumer websites.
Sparklines
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.
180+ Shapes
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.
DragFill
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.
Conditional Formatting
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.
Outline and Group Data
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.
Borders and Gridlines
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.
Tables
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.
What's New in SpreadJS v14
SpreadJS v14 is available. This release offers several great new features, some of which include:
- New v14 Designer
- Cell Interactions
- Incremental Loading
- Multi-Column Picker
- Comment Indicator Customization
- Copy Images from Excel
- HTML Export
- Pixel Scrolling with Scrollbar
- Fill Effects and Patterns
- Calculation Enhancements
- New Charts and Enhancements
SpreadJS Media and Content
Featured Blogs
Featured Videos
Featured Webinars