Supported Features by File Formats
19 Aug 20211 minute to read
The list of supported and non-supported Excel file format features in Essential XlsIO is given in the following table. XLS represents Excel 97 to 2003 format and XLSX represents Excel 2007 and above formats.
|
Feature |
XLS |
XLSX |
XLS to XLSX |
||||
|---|---|---|---|---|---|---|---|
|
Read |
Write |
Preserve |
Read |
Write |
Preserve |
||
|
Document Properties |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Font settings |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Alignments |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Number formatting |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Border settings |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Fill settings |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Cell styles |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Conditional formatting |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Cell size[Row/column height/width, autofit] |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Hide/Unhide rows/cols |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Hide/Unhide worksheet |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Copy/Move worksheet |
Yes |
Yes |
- |
Yes |
Yes |
- |
- |
|
Sheet protection |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Workbook protection |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Sheet format[sheet name, tab color] |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Image |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Charts |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Hyperlinks |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Header/Footer |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Pivot tables |
No |
No |
Yes |
Yes |
Yes |
- |
No |
|
Pivot Chart |
No |
No |
Yes |
Yes |
Yes |
- |
No |
|
AutoShapes |
No |
No |
Yes |
Yes |
Yes |
- |
No |
|
Text Box |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Check Box |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Combo Box |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Page setup |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
[Margin,origin,page size] |
|
|
|
|
|
|
|
|
Page breaks |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Background image |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Print settings[Print area,Print titles,page order] |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Formulas |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Calculation options |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Names |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Formula auditing [ Ignore error ] |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Filter |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Data validation |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Custom XML |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Collection Objects |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Template marker |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Outlines[group/ungroup, summary settings] |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Comments |
Partial |
Partial |
- |
partial |
partial |
- |
Yes |
|
Freeze pane, split pane |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
View[Zoom, show/hide gridlines, show/hide headings], horizontal/vertical scroll bars |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Macros |
No |
No |
Yes |
No |
No |
Yes |
No |
|
Encryption and Decryption |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Track changes |
No |
No |
No |
No |
No |
No |
No |
|
Themes |
- |
- |
- |
Yes partial |
No |
- |
- |
|
Cell gradient |
- |
- |
- |
Yes |
Yes |
- |
- |
|
Conditional Formatting |
Yes |
Yes |
- |
Yes |
Yes |
- |
Yes |
|
Advanced CF [Icon Set, Data bars, Color scales, Specific Date] |
- |
- |
- |
Yes |
Yes |
- |
- |
|
Tables |
No |
No |
No |
Yes |
Yes |
- |
No |
|
RGB colors |
Yes |
Yes |
Indexed color |
Yes |
Yes |
- |
Yes |
|
OLE Objects |
No |
No |
Yes (Full Trust Only) |
Yes (Full Trust Only) |
Yes (Full Trust Only) |
- |
No |