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