Angular Spreadsheet Library | Angular Excel Functions and Formulas

The Industry Leader in Spreadsheets

With over 25 years of experience in creating award-winning spreadsheets for professional developers, we already know what you want and need. No other spreadsheet vendor can match that. Put our spreadsheet experience to work for you today.
Powerful Calculation Engine Includes 450+ Functions

With more built-in functions than any other Angular spreadsheet, SpreadJS offers a complete function library that includes statistical and financial functions, dynamic arrays and custom user defined functions that are optimized for big data, complex calculations, and advanced Excel models.

A Complete Toolbox in One Spreadsheet Control

Leverage the extensive Angular spreadsheet library API and powerful calculation engine to create analysis, budgeting, dashboard, data collection and management, scientific, healthcare, education, financial applications and more.
Code-Free with the SpreadJS Designer

Leverage the power of the included WYSIWYG SpreadJS Designer to quickly design a complex spreadsheet layout using a familiar UI with our desktop designer app—no learning curve required. You can also load your existing Excel .xlsx template files and start being productive immediately.

Complete 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 they love online.
Deliver True Excel-Like Spreadsheet Experiences, Fast

Import, modify and export your most complex Excel .xlsx spreadsheets. SpreadJS offers the most 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.

Design Angular Spreadsheets

Instantly design Excel-like Angular spreadsheets with the Web Designer.

Try The Designer

Create Interactive Dashboards

Easily create dashboards that quickly provide a snapshot of your business data.

Try The Web Demo

Financial Reports and Statements

Create financial, budgeting/forecasting, scientific, engineering, healthcare, insurance, and many other similar business applications.

Try The Web Demo

Grid-Based Input Forms

Easily create complex data input and other similar structured forms that users can complete online.

Try The Web Demo

Sparklines

Visualize data with dozens of charts and elements.

Try The Web Demo

Custom Shapes App

Use custom and data driven shapes to create interactive applications, such as a car insurance claim.

View Demo

Business Dashboard

Create business dashboards for your Angular applications, such as presenting a retail metric summary.

View Demo

Business Report

Create business reports for your Angular applications, such as an account receivable report.

View Demo

Healthcare Medical Dashboard

Create dashboards for your Angular applications, such as a medical or healthcare summary.

View Demo

Angular Spreadsheet Top Features

Performance Benchmark

SpreadJS is optimized for fast performance. Launch the Performance Benchmark demo to load random values and set various properties. For example, populate 2 million cells in less than a second.

View Demo

Spread Designer

Take full control over the design of your spreadsheets with the SpreadJS Designer: Create workbooks from scratch or import your own Excel .xlsx files to edit in an Excel-like WYSIWYG interface.

View Demo

Import/Export Excel

The most complete support for importing and exporting your Excel files. Load your most complex Excel (.xlsx) files, make changes, and export back to an Excel file or save the data to a database.

View Demo

SpreadJS provides support for 11 chart groups, 30+ chart types, trendlines, and combo charts. Set chart layouts, customize elements, and combine chart types to evaluate financial information, perform stock analysis, present sales revenues, and much more.

View Demo

Sparklines

Sparklines provide a graphical representation of your data Embed. these small sparkline charts in any cell to quickly show trends in your data, such as increases/decreases, minimum/maximum values, stock levels, costs, and more.

View Demo

Conditional Formatting

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

View Demo

Angular Spreadsheet 450+ Built-In Functions and Formulas

Advanced Calculations

SpreadJS includes a comprehensive Calculation Engine that supports 450+ built-in functions, custom functions, array functions, dynamic arrays, formula textbox, localized languages function names, most Excel functions, and more.

View Demo

Dynamic Arrays

Return multiple results from a singular formula like FILTER, RANDARRAY, SEQUENCE, SORT, SORTBY, and UNIQUE. use the implicit intersection operator within formulas to get single values from a dynamic array formula.

View Demo

Tables

Tables make it easier to manage and analyze related spreadsheet data. SpreadJS supports AutoExpand, conditional formatting, data validation, context menus, fixed headers, table resize and navigation, a total summary row and more.

View Demo

Filtering

Use the built-in Excel-like filter dialog to allow your users to automatically filter their data or take advantage of creating custom filters to show and hide the relevant data as per your applications needs.

View Demo

Slicers

Similar to filters, Excel-like slicers offer an intuitive visual way to filter your spreadsheet data. Available slicers include table, item, chart, aggregation, and custom slicers such as those used on consumer websites.

View Demo

Shapes

SpreadJS includes support for many of the Excel shapes and provides more advanced functionality using data-driven shapes to dynamically generate the shape to create interactive shapes such as a manufacturing plant floor.

View Demo

Cell Types

SpreadJS includes many different cell types you can apply to any cell. Define the type of information that can be entered and displayed in any cell or use predefined dropdowns to make it easier for your users to select and enter valid data.

View Demo

Range Templates

The Range cell type allows custom rendering of cell data based on a cell range template. Data is bound to the template and rendered into the cell. Create custom rendering, such as card view, multi-row, and custom KPI blocks all without extra code.

View Demo

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.

View Demo

Data Validation

Data validation allows you define restrictions on what data can or cannot be entered within a cell. You can also provide visual indicators on the invalid data to help the user correct the data to fit restrictions of a database.

View Demo

Cell Drop-Downs

Quickly and easily select data using the cell dropdown features. Create input forms, advanced structured forms, and other interactive forms using dropdowns such as lists, date pickers, sliders, calculators, and color pickers.

View Demo

Cell States

Define custom cell styles to provide visual clues when the cell state has changed such as edit mode, hover, invalid, active, selected, read only, or changed. Create interactive input form controls, advanced structured forms and other interactive forms.

View Demo

Barcodes

SpreadJS supports eleven popular barcode sparklines including QR code, EAN-13, EAN-8, Codabar, Code39, Code93, Code128, GS1_128, Code49, PDF417, and DataMatrix that can be applied to any cell using formulas.

View Demo

Hyperlinks

SpreadJS supports Excel-like hyperlinks, allowing users to quickly open up links from inside worksheet cells. Navigate to sheet locations, open up URLs, a draft email, or create custom commands that work like buttons in the sheet.

View Demo

Sorting

SpreadJS can sort data in ascending or descending order and you can specify a column or row index to sort on as well as the sort criteria. Custom complex sorting can also be defined with compare functions

View Demo

Data Binding

Bind Angular objects and object arrays of data. Bind entire worksheets, tables, or individual cells to data sources. You can also use the SpreadJS Designer to create a binding relation to the data with a template.

View Demo

Auto Merging

SpreadJS supports AutoMerge for any cell range, column and the row and column headers. The neighboring cells in both the rows and columns can be visually merged automatically if the text is the same.

View Demo

Drag Filling

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. Use custom fill to load the data at runtime programmatically.

View Demo

Context Menu

SpreadJS includes an Excel-like context pop up menu for interacting with the sheet when the mouse is right-clicked on the control. Easily customize the context menu by adding and removing custom menu options.

View Demo

Printing

Print a single worksheet, specific data, or multiple worksheets with headers, borders, gridlines and other options. Set page breaks. display preview lines, get page information and print a background image as a watermark.

View Demo

Exporting to PDF

SpreadJS supports exporting to a PDF file. You can also import your Excel .xlsx files and export it to PDF. The Export operation uses the printInfo object for page setting and provides support for all the printing features that are available in SpreadJS.

View Demo

Search

SpreadJS makes it easy to find any data in the spreadsheet using the advanced built-in search function. You can also specify options such as the case, exact match, wild cards, cell range to search, and the order.

View Demo

Floating Objects

Add custom floating objects like pictures, logos, or custom HTML content that display on the top of the cells in a sheet. Customize objects using the included properties to control interaction.

View Demo

Globalization

SpreadJS includes built-in support for English, Chinese, and Japanese, and create custom resource files for other languages. The SpreadJS calculation engine also includes 18+ language packages and custom function localization.

View Demo

SpreadJS Desktop Designer

The SpreadJS Designer, included with the licensed product and trial, is a very powerful WYSIWYG stand-alone desktop application that helps Angular developers quickly design spreadsheets using a familiar interface.

Create and design new spreadsheets
Import your existing Excel files and make any needed changes
Create templates that populate data at run-time
Export your finished spreadsheet to .ssjson or .xlsx to load into your SpreadJS application

Learn More

Online Spread Designer Demo

This demo uses the developer SpreadJS Designer and brings it to the web so you can experience the Designer right in your browser. Source code is available for purchase.

Experience the potential of a full SpreadJS app
WYSIWYG interface with a familiar Excel-like experience
Export your spreadsheet and load into your SpreadJS app
Contact sales to purchase the Web Designer source code separately and embed this functionality directly into your applications today. Complete with all the dialogs, you can choose to add all the Designer functionality, limit options depending on user credentials, add your menu options, or further refine per your application's needs.

Try It Now

What's New in SpreadJS v13.1

SpreadJS v13.1 is available. This release offers several great new features including:

Hyperlinks
Format String Enhancements
Dirty Cell States
Custom Sorting
Percentage Format Enhancement
Ellipsis and Tips for Cells
Inserting Copied/Cut Cells
Multi-Select ComboBox
Enable/Disable Table Auto Expand
Chart Enhancements

SpreadJS Releases

SpreadJS Media and Content

Featured Blogs

View All Blogs

Featured Videos

SpreadJS Built in and Custom Shapes

SpreadJS Webinar - New Features of SpreadJS 13

How to License SpreadJS 11 for App Distribution

View All Videos

Featured Webinars

Explore New Features of SpreadJS v13.1

Spread.NET 13 New Features

SpreadJS 13 New Features

View All Webinars

The Industry Leader in Spreadsheets

Powerful Calculation Engine Includes 450+ Functions

A Complete Toolbox in One Spreadsheet Control

Code-Free with the SpreadJS Designer

Complete Document Control

Deliver True Excel-Like Spreadsheet Experiences, Fast

Angular Spreadsheet Top Features

SpreadJS Desktop Designer

Online Spread Designer Demo

SpreadJS Media and Content

Award-Winning Angular Spreadsheets

GrapeCity Spread is Trusted by the World’s Leading Companies

We have been using Spread in our desk and web products (PerpetualBudget) for over a decade. Not only are the Spread grids great controls but the support at GrapeCity is the best. When you need them, they're there!

I haven't come across such a feature-rich solid Spread before. Thanks for giving such a nice component.

Spread benefits my company because our clients can now see the immediate benefit the websites we create for them provide.

Thanks for providing the best [JavaScript] spreadsheet widget in the world, we're very happy customers. Your product has saved us a TON of time relative to other solutions we used in the past.

GrapeCity Spread is Trusted by the
World’s Leading Companies