Microsoft Excel Spreadsheet Management Library

Aspose.Cells – Microsoft Excel Spreadsheet Management Library

Document Features

• Open plain or encrypted Microsoft Excel files (Excel 97 - Excel 2007/2010/2013) from different sources.
• Save Excel files (Excel 97 - Excel 2007/2010/2013) in different formats (XLS, XLSX/XLSM, XLTX, XLTM, XLSB, CSV, SpreadsheetML, Tab Delimited, TSV, HTML, etc.)
• Convert Excel file to PDF document.
• Convert Excel spreadsheet to XPS document.
• Convert to Tagged Image File Format (TIFF).
• Read and write OpenDocument Spreadsheet (ODS) format.
• Modify the document properties of Excel files.

Worksheet Features

Display Options

• Hide or show a worksheet.
• Display or hide tabs, scroll bars, gridlines, and row and column headers.
• Preview page breaks.
• Set zoom level for the worksheet.
• Make selected data remain visible while scrolling using freeze panes.

Worksheet Protection

• Protect contents, objects, and scenarios of a worksheet.

Page Setup Options

• Set page orientation, scaling, paper size, print quality, etc.
• Set page margins such as top, left, right, bottom, etc.
• Set headers and footers.
• Set print area, print title, etc.

Page Breaks

• Insert horizontal and vertical page breaks at a specified cell.

Rows & Columns Features

• Adjust row height.
• Adjust column width as required.
• Auto‑size the width and height of cells according to their contents.
• Insert or delete rows and columns.
• Hide or show rows and columns.
• Group or ungroup rows and columns.

Data Management Features

• Access any cell in the worksheet.
• Add data to desired cells at runtime.
• Import data into worksheets from different data sources.
• Retrieve data from cells according to their data types.
• Export cells data to a DataTable.
• Find or search for specific data in cells.
• Set formulas with built‑in or add‑in functions.
• Set array and R1C1 reference‑style formulas.
• Add different kinds of hyperlinks.
• Create or access named ranges.
• Apply data validation and auto‑filtering.

Formatting Features

• Apply different styles to cells.
• Apply number format settings to cells.
• Format a cell as a date.
• Set text alignment.
• Merge multiple cells.
• Apply different kinds of font settings on cells.
• Apply different colors to cells, fonts, gridlines, graphic objects, etc.
• Set rich text in a single cell.
• Apply different border settings on cells.
• Apply different background patterns on cells.
• Apply format settings on a worksheet, row, or column, etc.
• Apply conditional formatting on cells.

Charting & Graphics Features

• Supports all standard chart types like column, bar, line, pie, scatter, etc.
• Create different kinds of charts easily.
• Customize charts by setting their various properties.
• Set data for the charts dynamically.
• Add custom charts to worksheets using the API.
• Add pictures to worksheets at runtime.
• Create and add comments to cells.
• Convert chart to an image file.
• Convert worksheet to an image file.
• Print worksheets.

Advanced Features

• Create designer spreadsheets and work with Smart Markers.
• Formula calculations made fast by a robust Formula Calculation Engine.
• Access Aspose.Cells from COM clients.
• Change source data of a pivot table at runtime.
• Create and manipulate pivot tables.
• Manipulate VBA code or macros.

Supported Platforms

• Desktop Windows application
• Enterprise web application