[]
        
(Showing Draft Content)

Features

Excel for .NET provides features for creating, loading, saving, and manipulating Excel workbooks, worksheets, and cell content.

The following topics describe these features:

Calculation Modes — Specifies the calculation mode for all formulas in the workbook, including automatic, automatic no-table, and manual modes.

Cells — Sets cell values, merges cells, applies word-wrap, adds comments, and inserts hyperlinks in worksheet cells.

Compatibility Modes — Specifies the Microsoft Excel version a workbook targets, controlling sheet size and style limits.

Conditional Formatting — Highlights cells with different styles based on specified conditions and variations in the data.

Copy Sheets — Copies and pastes Excel sheets by cloning rows from one sheet to another.

Data Validation — Controls the data that end-users can enter into cells using validation types such as whole number, decimal, date, time, list, text length, and custom formulas.

Groups and Subtotals — Groups data by common attributes into an expandable outline and displays subtotals.

Images — Adds images to cells or sheets and customizes their size, rotation, brightness, contrast, and borders.

Load and Save — Loads workbooks from and saves them to multiple formats, including XLS, XLSX, XML, CSV, and macro files.

Rows and Columns — Adds, sizes, hides, and outlines rows and columns in a worksheet.

View Layouts — Controls how worksheets appear on screen and in print using different view layout options.

Workbook — Creates and configures Excel workbooks, including setting author metadata and managing the worksheets they contain.

Worksheet — Adds and manages worksheets within a workbook, including content entry, formulas, gridlines, visibility, and scaling.