Excel

Reads data from Excel files (.xlsx, .xls) by parsing worksheet cells into structured formats (JSON, CSV, arrays). Uses a cell-based access pattern with row/column indexing to extract ranges, individual cells, or entire sheets. Supports named ranges and handles mixed data types (strings, numbers, dates, booleans) with automatic type inference during deserialization.

Writes data to Excel files by updating individual cells, ranges, or appending rows to existing worksheets. Uses a cell-based write pattern with optional auto-formatting (column width adjustment, header styling). Supports creating new worksheets within existing workbooks and preserves existing data while performing targeted updates.

Creates, renames, duplicates, and deletes worksheets within Excel workbooks. Manages worksheet metadata (visibility, tab color, position in workbook). Uses workbook-level operations to manipulate sheet structure without affecting cell data. Supports setting active worksheet and reordering sheets.

Applies formatting to cells and ranges including font properties (bold, italic, color, size), background colors, borders, number formats (currency, percentage, date), text alignment, and cell merging. Uses Excel's native formatting model with direct mapping to OOXML style attributes. Supports conditional formatting rules and named styles.

Creates and configures charts (bar, line, pie, scatter, area) from worksheet data ranges. Specifies data series, categories, titles, legends, and axis properties. Uses Excel's chart object model to embed charts in worksheets with positioning and sizing. Supports chart type conversion and data range updates.

Creates pivot tables from data ranges with configurable row/column fields, value aggregations (sum, count, average, min, max), and filters. Uses Excel's pivot table engine to summarize and cross-tabulate data. Supports pivot table refresh when source data changes and field sorting/filtering.

Inserts Excel formulas into cells with support for built-in functions (SUM, AVERAGE, COUNT, IF, VLOOKUP, etc.) and cell references. Formulas are stored in cells and evaluated by Excel's calculation engine when the file is opened. Supports relative and absolute cell references, range operations, and nested functions.

Applies data validation rules to cells and ranges to restrict input types (whole numbers, decimals, dates, text length) and values (lists, ranges, custom formulas). Displays error messages when invalid data is entered. Uses Excel's native validation engine with support for in-cell dropdowns and range-based constraints.

Defines data validation rules on cell ranges to enforce constraints (e.g., numeric ranges, list selections, text length limits, date ranges). Implements validation rule configuration with error messages and input prompts, preventing invalid data entry in Excel. Rules are embedded in the workbook and enforced when users edit cells, improving data quality without code.