[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Collapse]Spreadsheet Document API
   Product Structure
   Getting Started
  [Expand]Spreadsheet Document
   Supported Formats
  [Expand]Cell Basics
  [Expand]Spreadsheet Formulas
   Defined Names
   Data Binding
  [Expand]Pivot Tables
   Charting
   Shapes
  [Expand]Mail Merge
  [Expand]Examples
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Expand]API Reference
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Spreadsheet Document API

The Spreadsheet Document API is a non-visual .NET library that provides the complete spreadsheet functionality available via its API (the Workbook instance). It allows you to create, load, modify, save and print spreadsheet documents, so that you do not need Microsoft® Excel® to be installed on your computer.

The spreadsheet component also provides comprehensive data shaping and analysis tools, such as data mining, grouping, filtering, and charting. The built-in formula calculation engine allows you to create simple formulas to summarize worksheet information or construct complex formulas containing mathematical, statistical and other predefined functions for advanced data analysis.

Important

The Universal Subscription or an additional Office File API Subscription is required to use this component or library in production code. Refer to the DevExpress Subscription page for pricing information.

The major features of the Spreadsheet Document API are listed below.

Expanded Supported Formats

Create, load, convert and save workbooks to popular file formats.

  • Excel formats: XLS, XLSX, XLSM, XLTX, XLTM and XLT.

  • Text formats: TXT and CSV.

  • Other formats: PDF and HTML (export only).

Expanded Worksheet Basics

  • Manage worksheets: create, copy, rename, move, hide and delete worksheets.

  • Customize worksheet view options: change the zoom level and control the visibility of gridlines and headings.

  • Specify print settings: set paper size, margins and orientation for worksheet pages.

Expanded Cells and Cell Ranges

Expanded Rows and Columns

Expanded Data Management

  • Add different types of data to worksheet cells.

  • Import data to cells from different data sources (arrays, lists and data tables).

Expanded Data Binding

  • Use a cell range or a worksheet table as a data source for any data-aware control.

  • Establish two-way binding to various data sources so that you can further analyze or modify the data.

Expanded Formulas

  • Perform calculations using formulas with different types of cell references and a comprehensive set of built-in functions.

  • Create shared and array formulas.

  • Evaluate worksheet formulas using Formula Engine, which provides the capability to parse a formula into an expression tree, modify it and rebuild the string expression.

Expanded Protection

  • Protect workbook structure: prevent end-users from adding, deleting or renaming worksheets.

  • Protect worksheets: prevent end-users from editing certain cells, applying formatting options, or making structural changes to worksheets.

  • Protect individual cell ranges and unlock specific ranges in a protected worksheet for authenticated users.

Expanded Data Shaping Tools

  • Organize data in tables: insert, copy, modify and delete tables. Format tables using one of the built-in table styles or create your own custom styles.

  • Sort data in a range in ascending or descending order.

  • Filter data: use the filtering functionality to arrange large amounts of data by displaying only rows that meet filtering criteria.

  • Group data: split data into separate groups and calculate summaries for each group.

Expanded Charts and Graphics

  • Add shapes to a worksheet, connect and group shapes, change a shape’s fill and outline settings, add text to a shape, and remove shapes from a document.

  • Add pictures to a worksheet: insert, move, change, transform and delete pictures.

  • Use the Spreadsheet Chart API to create a basic chart in code and fully customize the appearance of any chart element.

  • Create sparkline groups of different types, and adjust their formatting and scaling options.

Expanded Pivot Tables

Expanded Printing and Exporting

  • Print a workbook or individual worksheets to a printer or file.

  • Specify various print options: add headers and footers to the printout, set a print area on a worksheet, repeat specific rows and columns on every page, and define other print-related settings (such as page orientation, paper size, page margins, etc.).

  • Export a workbook to a PDF file, or save it as a web-page (export to HTML).

Expanded Mail Merge

  • Automatically generates a set of documents based on a single template and include unique data values retrieved from a data source into each document.

Expanded See Also

Is this topic helpful?​​​​​​​