Supported Features by File Formats
4 Jun 2019 / 1 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 |
Was this page helpful?
Yes
No
Thank you for your feedback!
Thank you for your feedback and comments. We will rectify this as soon as possible!
An unknown error has occurred. Please try again.
Help us improve this page