Microsoft Excel Spreadsheet Management Library

Aspose.Cells – Microsoft Excel Spreadsheet Management Library

Document Features

  • Open plain or encrypted Microsft Excel files (Excel97 - Excel2007/2010/2013) from different sources.
  • Save Excel files (Excel 97 - Excel2007/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 & 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 like 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 DataTable.
  • Find or search for specific data in cells.
  • Set formulae with built-in or add-in functions.
  • Set array and R1C1 reference style formula.
  • 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 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 different properties.
  • Set data for the charts dynamically.
  • Add custom charts to worksheets using API.
  • Add pictures to worksheets at runtime.
  • Create and add comments to cells.
  • Convert chart to image file.
  • Convert worksheet to 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
Feature Overview File Formats and Conversions