Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Document Server
  Product Information
 [Expand]Redistribution and Deployment
 [Collapse]Spreadsheet Document Server
   Product Structure
   Getting Started
  [Expand]Spreadsheet Document
   Supported Formats
  [Expand]Cell Basics
  [Expand]Spreadsheet Formulas
   Defined Names
   Data Binding
  [Expand]Pivot Tables
  [Expand]Mail Merge
  [Expand]Examples
 [Expand]XL Export Library
 [Expand]Rich Edit Document Server
 [Expand]Snap Document Server
 [Expand]PDF Document Processor
 [Expand]Compression Library
 [Expand]Bar Code Library
 [Expand]Unit Conversion Library
 [Expand]API Reference
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Spreadsheet Document Server

The Spreadsheet Document Server 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 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 Document Server Subscription is required to use this component or library in production code. Please refer to the DevExpress Subscription page for pricing information.

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

Expanded Document Operations

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: export your document to a PDF file, or save it as a web-page (export to HTML).

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

Expanded Pivot Tables

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

How would you rate this topic?​​​​​​​