• North American Sales: 1-800-231-8588
  • Global Contacts
  • My Account
Infragistics logo Infragistics logo
Menu
  • North American Sales: 1-800-231-8588
  • My Account
    • Sign In/Register
  • Design & DevelopmentDesign & Develop
    • Best Value Bundles
      Infragistics Ultimate $2,355 The only complete UX/UI toolkit for building high performance, modern web, mobile and desktop applications.
      Infragistics Professional $1,575 The comprehensive UI components library for web, mobile and desktop developers.
      Ignite UI $1,355 A complete library of UI components for building modern, data-rich and responsive web apps.
    • Web
      App Builder (New) Ignite UI

      Angular | Grid Samples

      Blazor React Web Components | Grid Samples Ultimate UI for ASP.NET Core Ultimate UI for ASP.NET MVC Ultimate UI for jQuery Ultimate UI for ASP.NET Web Forms
    • Desktop
      Ultimate UI for Windows Forms Ultimate UI for WPF
      Cross Platform
      Ultimate UI for Uno Ultimate UI for UWP Ultimate UI for WinUI Ultimate UI for Xamarin
    • Design to Code
      Indigo.Design App Builder (New) Design System & UI Kits
      Automated Testing Tools
      Test automation for Micro Focus UFT: Windows Forms Test automation for Micro Focus UFT: WPF Test automation for IBM RFT: Windows Forms
  • UX
    • App Builder Cloud-based WYSIWYG Drag & Drop Tool, Endless Theming options and Standards-Based Code Output
    • Indigo.Design A Unified Platform for Visual Design, UX Prototyping, Code Generation, and App Development
  • Business Intelligence
    • Reveal Easily embed beautiful data visualizations into your apps
    • Slingshot Empower everyone in your organization to use data to make smarter business decisions
  • Team Productivity
    • Slingshot Connect everyone you work with to data, project management, content and chats for better results.
    • SharePlus Secure, instant access to content and data on the go – with or without connectivity.
  • Learn & SupportSupport
    • Help & Support Documents
    • Blogs
    • Forums
    • Product Ideas
    • Reference Applications
    • Customer Stories
    • Webinars
    • eBook & Whitepapers
    • Events
  • Free Trials
  • Pricing
    • Product Pricing / Buy Online
    • Contact Us
Ignite UI | Components
  • Download Now
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
OK
Your Privacy Matters
We use our own and third-party cookies to improve your experience on our website. They also allow us to analyze user behavior in order to constantly improve the website for you. Please review our Cookie Policy and cookie settings below.
Manage settings OK
Privacy Preferences
When you visit any website, it may store or retrieve information on your browser, mostly in the form ot cookies. This information might be about you, your preferences, or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but can give you a more personalized web experience. Because we respect your right to privacy. you can choose not to allow some types of cookies. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.
Accept All
Essential cookies for login data and good site performance.
Cookies that support website functionality and features.
Cookies, provided by our third-party advertising partners, collect information about your browsing habits.
Cookies used to make advertising messages more relevant to you and your interests.
Decline All Confirm My Choices
  • Grids & Lists
    • Data Grid
    • Hierarchical Grid
    • OLAP Pivot Data Selector
    • OLAP Pivot Grid
    • OLAP Pivot View
    • Spreadsheet
    • Tree Grid
    • Tree List
  • Charts
    • Category Chart
    • Data Chart
    • Doughnut Chart
    • Financial Chart
    • Funnel Chart
    • Pie Chart
    • Shape Chart
    • Sparkline
  • Gauges
    • Bullet Graph
    • Linear Gauge
    • Radial Gauge
  • Barcodes
    • Barcode
  • Data Visualization
    • Geographic Map
    • Zoombar
  • Data Entry and Display
    • Editors
    • Combo Box Editor
    • HTML Editor
    • Notifier
    • Rating
    • Validator
  • Interactions
    • Dialog Window
    • File Upload
    • Popover
    • Scrollbar
    • Split Button
    • Video Player
  • Menus
    • Radial Menu
  • Layouts
    • Layout Managers
    • Splitter
    • Tile Manager
  • Styling & Themes
    • Themes
  • Scheduling
    • Schedule
  • Frameworks
    • Data Source
    • Excel Exporter
    • Excel Library
    • Infragistics Documents
    • Infragistics Loader
    • Template Engine
    • Word Exporter
Spreadsheet Example

Ignite UI Spreadsheet

The Spreadsheet component provides users with a powerful yet familiar way to manage data. The Spreadsheet component is supported by the Infragistics JavaScript Excel library, enabling it to import and export data to and from Microsoft Excel files either locally or from a service. The Spreadsheet supports all basic spreadsheet features, including workbooks, worksheets, cells, formulas, and more.

View Sample

Spreadsheet Formula Bar Function

Formula Bar

The most powerful feature of any spreadsheet is the ability to create formulas based on the spreadsheets data. The Spreadsheet component includes a formula bar that allows users to see formula definitions. The Spreadsheet component supports custom formulas and provides dozens of built-in functions, including simple formulas such as SUM, MEAN, and MEDIAN, in addition to more complex formulas such as GEOMEAN and HARMEAN. The Formula Bar is also resizable, making it easier to see long or complex formulas.


Configurable View

The Spreadsheet component provides many options to manage how users work with and consume the data presented to them. You can programmatically hide the gridlines, headings, and the formula bar. The spreadsheet also supports zooming and text formatting (bold, italics, underline). These features work in real-time, so your users can change these settings on the fly. Users can also split the spreadsheet into scrollable panes and freeze the first column or row.

Spreadsheet Configurable View Function View Sample

Import and Save Data to Excel

The Spreadsheet component leverages the power of the Infragistics JavaScript Excel library to enable your users to import and export data to and from Microsoft Excel files. Users can import data from an Excel file, or you can programmatically generate a workbook data object and display it in the spreadsheet. Similarly, users can export data from your web-based app and either save it to a local file or stream it to a remote computer. The Spreadsheet component supports all Excel formulas, as well as Excel structural features, such as workbooks and worksheets. The excel engine supports more than 100 functions.

View Sample

Spreadsheet Excel Editing and Formatting

Excel Editing and Formatting

The igSpreadsheet is built on top of our existing Excel framework and provides an interactive control to our powerful Excel document capabilities. Editing and cell formatting features include conditional formatting, and sorting and filtering, all without requiring Excel to be installed.


Sort and filter worksheets by text, number, date, or color formatting

Worksheet Sorting and Filtering

Table and worksheet-level sorting and filtering capabilities let you define and sort or filter an area by text, number, date, or color formatting within a worksheet or outside a table. Choose from a list of filters or create specific filters to customize your view. With the Custom Sort Dialog, Top 10 Filter Dialog, and Format Cells Dialog, you can secondary sort, sort by the top ten (or bottom ten) records, and adjust the way a spreadsheet displays data in a cell. You can also choose from a list of filters or create customized ones.


Spreadsheet Import & Save Data to Excel Function

Table Creation and Management

Improved features let you copy and paste entire tables, expand and edit tables, navigate between rows, choose common formulas, and use the context menu to add rows, columns, and data to a table.


Conditional Formatting

Render all the conditional formatting features available in Microsoft Excel, including presets for data bars, color scales with two- or three-color gradients, and icons.

Spreadsheet Conditional Formatting

Ignite UI Formulas

Format Cells Dialog

Right-click on a cell to use the Format Cells dialog box to format cell data. Modify number display, alignment, font, shading and borders, and protection of your worksheet data.

  • Products
    • Design & Development
    • UX Pros
    • Embedded Analytics
    • Work Management
    • View All
    • Free Trials
  • Learn & Support
    • Help & API Docs
    • Blogs
    • Technical Support Chat
    • Forums
    • Product Ideas
    • Submit a Request
    • Service Health
  • My Account
    • Manage My Subscriptions
    • Support Requests
  • Compare
    • Angular Compare
    • Blazor Compare
  • Corporate
    • About Us
    • Careers
    • Legal
    • News & Events
    • Partners
The best blogs, whitepapers, and other development resources
Unfortunately, Google has considered you a bot. If you have an account, please sign in to validate your status and fill form out again. Alternatively, please feel free to contact sales@infragistics.com to obtain the asset you were looking for or choose to schedule a demo of our products.
Thank you for subscribing. Look for an email from team@Infragistics.com for the latest news for Developers, UX, and Business Teams.
  • Privacy Policy(updated)
  • Cookies
  • Terms of Use(updated)
I.S. Partners SOC2 SEAL GDPR SEALIS Partners LLC
© Copyright 2025 INFRAGISTICS. All Rights Reserved
Back to top of page