Supported Features by File Formats

4 Sep 20231 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(Notes)

Partial

Partial

-

partial

partial

-

Yes

Threaded Comments

No

No

No

Yes

Yes

Yes

No

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

Slicers

No

No

No

Yes

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

What-If Analysis (Scenarios)

No

No

No

Yes

Yes

Yes

No