What is a predefined set of colors fonts and effects that can be applied to an entire workbook?

The WinForms Spreadsheet control emulates Microsoft® Excel® capabilities and allows you to create, load, edit, save, and print spreadsheet documents.

If you are new to the SpreadsheetControl or consider it for an upcoming project, review the following topics first:

• Get Started with the WinForms Spreadsheet

• Spreadsheet Control API

• Visual Elements

• Task-Based Examples

Spreadsheet Document Elements

Review the list of supported document elements. You can manage these elements in code or from the Spreadsheet control’s user interface.

A workbook is a spreadsheet document. When you load the Spreadsheet control, it displays an empty workbook. You can create a new document, load an existing file, or retrieve data from different data sources (arrays, lists, data tables, and so on). The Spreadsheet control allows you to save modified data to a file or export your document to PDF and HTML.

Supported File Formats

All worksheet data is stored in cells. A cell reference defines the position of a cell or cell range in a worksheet.

Cells can contain different values: numbers, dates, text, logical values, and formulas. You can embed custom data editors within cells to facilitate and validate user input.

Formulas and Functions

You can create formulas and perform calculations of any complexity. The Spreadsheet control ships with the Formula Bar that allows users to view, enter, and edit formulas.

The Spreadsheet control supports over 400 built-in functions designed to address a broad range of usage scenarios. You can use basic mathematical functions to aggregate data within a spreadsheet or create complex formulas with statistical, engineering, and financial functions. In addition to the predefined functions, the Spreadsheet control also supports user-defined (custom) functions.

Document Appearance and Cell Formatting

The Spreadsheet control supports a rich set of formatting options that allow you to change the appearance of the entire document or individual cells.

Bind to Data

You can bind a cell range or a table to various data sources: ADO.NET data sets, SQL databases, XML files, and lists of custom objects. Two-way data binding is supported.

You can also use a cell range as a data source for any DevExpress or third-party data-aware UI control (Data Grid, Chart, and so on).

Organize and Shape Data

The WinForms Spreadsheet control supports the following features that help you manage and organize data more effectively:

• Sort data in a cell range or table in ascending or descending order.
• Filter data in a cell range or table to display only rows that meet specific criteria. Different types of filters are available: Text Filters, Number Filters, Date Filters, and Filter by Values.
• Group rows and columns and display summary information for each group. You can group data manually, create an automatic outline based on summary formulas, or calculate subtotals for related rows.

Protect and Encrypt Data

The WinForms Spreadsheet allows you to protect your documents to prevent unauthorized access. Security options include:

• Restrict changes to workbooks and worksheets. Protect the workbook structure and lock cells in a worksheet so that users can execute only specific actions.
• Grant user permissions. Unlock specific cell ranges in a protected worksheet for authorized users.
• Encrypt a document with a password. The Spreadsheet control uses 256-bit AES encryption for XLSX files and the custom RC4 CryptoAPI implementation for XLS files.
• Configure which actions are available to users. Unavailable operations are disabled or hidden in the ribbon UI and corresponding context menus.

Validate Cell Values

Restrict user input and utilize data validation to reduce data entry errors and ensure data integrity. You can create a drop-down list of valid values, limit the number of text characters in a cell, restrict data entry to values within a specific range, validate data based on spreadsheet formulas, and display input and error messages for validated cells.

Print Documents

You can print documents in code or use the built-in Print dialog. Invoke the Preview window to preview your document before printing.

The Page Setup dialog allows users to customize page settings, specify page margins, add headers and footers, set a print area, and define rows and columns to repeat on every page.

Mail Merge

The WinForms Spreadsheet control supports Mail Merge operations. Use Mail Merge to automatically generate personalized letters and business-centric reports of any complexity. Merged documents are generated based on a template that is bound to a data source. The Spreadsheet control’s Mail Merge tools allow you to visually design templates and preview mail merge results on-the-fly. You can save data-bound templates to XLSX and XLS files and reuse them later to quickly create new documents and reports.

DevExpress Spreadsheet Document API

The WinForms Spreadsheet control and the non-visual Spreadsheet Document API library share a common API used to manage spreadsheet documents in code. However, this library offers several unique features you may find useful for your Spreadsheet app:

• Load, save, and export (to PDF and HTML) documents asynchronously
• Import data from different data sources (such as arrays, lists, and data tables) and export a cell range to a DataTable
• Clone and merge workbooks
• Generate thumbnails for worksheets
• Save cell ranges as images
• Digitally sign Microsoft Excel documents

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use the Spreadsheet Document API library in production code. For pricing information, refer to the following page: DevExpress Subscription Plans.