[]
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.