| Feature | Description | Available for |
| Cell values | - Strings
- Numbers
- Dates
- Booleans
- Formulas
- Errors
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer, EasyXLS Express Excel Writer |
| Formulas | - All functions supported by Excel
- Arithmetic, logical and unary operators
- Formulas with numbers, dates and strings
- Formulas with cell references
- Formulas with cell ranges
- Formulas with named ranges
- Formulas with arrays
- Formulas in A1 or R1C1 reference style
- Formulas with references to external documents
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer, EasyXLS Express Excel Writer |
| Formula computation engine | - Formula computation engine is available
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Worksheets | - Title
- Worksheet can be selected
- Worksheet can be protected
- Worksheet can be hidden
- Zoom
- Tab color
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Chart sheets | - Title
- Chart sheet can be selected
- Chart sheet can be protected
- Chart sheet can be hidden
- Zoom
- Tab color
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Format cells | - Format a cell, a row, a column or a specified range
- Number format - all text, number and date formats supported by Excel are available
- Alignment vertical & horizontal alignment, wrap & shrink text
- Indent
- Text direction
- Text rotation
- Font font name, font size, color, bold, italic, underline, strikethrough, superscript & subscript
- Border style and color
- Background & foreground
- Pattern
- Gradient fill
- Protection locked & hidden
- Merged cells
- Rich text format
- Themes
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer, EasyXLS Express Excel Writer |
| Auto-formats | - Default Excel auto-formats
- Custom auto-formats
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer, EasyXLS Express Excel Writer |
| Conditional Formatting | - Conditional formatting for a range
- Font - color, bold, italic, underline, strikethrough
- Border - style and color
- Background & foreground
- Themes
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Hyperlinks | - URL's
- Files
- Cell references
- Named ranges
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Comments | - Font name, font size, bold, italic, underline
- Foreground
- Location
- Rich text format
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Images | - JPEG, GIF, PNG, WMF, EMF, BMP, TIFF images
- Image file path
- Location
- Extract image bytes from an Excel document
Note: xls file format supports only JPEG images | EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Names | | EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Data validation | - Data entered in a cell can be restricted to certain values
- Input message and error alert can be set
- Drop-down controls to select the allowable values for a cell are available
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Header & footer | - Position left, center and right side
- Font font name, font size, underline, strikethrough, superscript, subscript
- Predefined texts: page number, total number of pages, date and time, file name
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Page Setup | - Set page orientation (portrait, landscape), paper size
- Set scaling factor, fit to pages width/height
- Set paper margins
- Set print area
- Set rows to be repeated at top, columns to be repeated at left
- Print order
- Print gridlines, print black and white, print draft quality, print row and column headings, print comments
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Page breaks | - Horizontal and vertical page breaks
- Allows displaying the file in page break preview mode
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Row & column dimension | - Row height & column width can be set for the grid
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Group and outline levels | - Group the rows and the columns. Multiple and embedded outline levels are available.
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Split and freeze panes | - Split window views
- Freeze rows and columns
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Filter and AutoFilter | - Auto-filter
- Advanced filter
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Chart objects | - All chart types and chart formats supported by Excel are available
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Pivot tables | - Pivot table options: Layout&Format, Totals&Filters, Display, Printing, Data
- Fields and their settings
- Row labels
- Column labels
- Report filter
- Value fields and their settings
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Pivot tables | - Pivot charts can be created based on a pivot table. All the features presented for charts are available also for pivot charts.
|
| Encryption & password protection | - Password protection for the workbook
- Password to open and password to modify MS Excel documents
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer, EasyXLS Express Excel Writer |
| File properties | - Document summary properties
- Custom properties
| EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer |
| Read as SQL result set | - Read the sheet values of an XLS document (Office 97-2003)
- Read the active sheet values of an XLS document (Office 97-2003)
- Read the sheet values of an XLSX document (Office 2007)
- Read the active sheet values of an XLSX document (Office 2007)
- Read the sheet values of an XLSB document (Office 2007)
- Read the active sheet values of an XLSB document (Office 2007)
- Read the values from a TXT file
- Read the values from a CSV file
- Read the values from an XML file
| EasyXLS Professional Excel Library, EasyXLS Excel Reader |
| Save as | - XLS document (Office 97-2003)
- XLSX document (Office 2007)
- XLSB document (Office 2007)
- TXT file
- CVS file
- XML file
- HTML file
| EasyXLS Professional Excel Library, EasyXLS Excel Writer, EasyXLS Express Excel Writer |
| Load | - An XLS document (Office 97-2003)
- An XLSX document (Office 2007)
- An XLSB document (Office 2007)
- A TXT file
- A CSV file
- An XML file
- An HTML file
- Sheet names
| EasyXLS Professional Excel Library, EasyXLS Excel Reader |
| Import/Export | - SQL result sets
- XML files
- TXT files
- CSV files
- HTML files
- Custom lists
| EasyXLS Professional Excel Library, EasyXLS Excel Reader (only export), EasyXLS Excel Writer (only import), EasyXLS Express Excel Writer (only SQL and custom lists) |
| VB and macros | - Preserve the macros when load/edit/write XLS, XLSX and XLSB files
| EasyXLS Professional Excel Library |
