Document Features
Open Plain or Encrypted Excel files from different sources.
Save Excel files in different formats (XLS, XLSX/XLSM, XLTX, XLTM, XLSB, CSV, SpreadsheetML, Tab Delimited/TSV, HTML etc.).
Convert Excel file to PDF, XPS & TIFF.
Read & write OpenDocument Spreadsheet (ODS ) format.
Modify document properties.
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 & vertical page breaks at a specified cell.
Rows & Columns Features
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
Add data to desired cells.
Import data from different data sources.
Retrieve data from cells as per data types.
Export cells data to array.
Find specific data.
Set formulae with built-in or add-in functions.
Set array & R1C1 reference style formula.
Add hyperlinks.
Create or access named ranges.
Apply data validation & auto-filtering.
Apply subtotals to worksheet tables.
Formatting Features
Apply number format settings.
Format cells as date.
Set text alignment.
Merge multiple cells.
Apply different kinds of font settings for the cells.
Apply different colors to cells, fonts, gridlines, graphic etc.
Advanced Features
Formula Calculation Engine.
Create, manipulate & change the source data of a pivot table.
Manipulate VBA code or Macros.