Click or drag to resize

Supported File Formats

GemBox.Spreadsheet for Java supports multiple file formats with varying degree of support.

The following sections explain file formats support in more detail and present other, file format specific, valuable information:

GemBox.Spreadsheet for Java Feature Support

Following list describes each icon used in the subsequent table(s).

  • Feature is supported  - Feature is supported (it can be created, modified or removed with GemBox.Spreadsheet).

  • Feature is not applicable for file format  - Feature is not applicable for file format (file format is not designed to support this kind of feature).

  • Feature is not supported  - Feature is not supported (it cannot be created, modified or removed with GemBox.Spreadsheet, nor it will be preserved when loading and saving to the same file format).

GemBox.Spreadsheet Feature Support

Feature

XLSX

XLS

ODS

CSV

TXT

HTML

Reading

File formats from which GemBox.Spreadsheet can read.

Feature is supported
Feature is supported
Feature is supported
Feature is supported
Feature is supported
Feature is supported

Writing

File formats to which GemBox.Spreadsheet can write.

Feature is supported
Feature is supported
Feature is supported
Feature is supported
Feature is supported
Feature is supported

Document Properties

Built-in & custom workbook properties.

Feature is supported
Feature is supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is supported

Cell/Row/Column Formatting

Number formats, text alignment, font settings, borders, background fill, column width, row height.

Feature is supported
Feature is supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is supported

In-line Text Formatting

Different font settings for parts of a textual cell value.

Feature is supported
Feature is supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is supported

Conditional Formatting

Conditional Formatting is loaded from and saved to XLSX file format only.

Conditional Formatting calculation is currently not supported.

Feature is supported
Feature is supported
Feature is not supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not supported

Row/Column Outline & Group

Feature is supported
Feature is supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not supported

Defined Names & Formulas

Workbook and worksheet scope defined names, formula reading/writing.

Feature is supported
Feature is supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not applicable for file format

Pictures

JPEG, PNG, GIF, BMP, TIF, EMF, WMF, EXIF, ICO.

Feature is supported
Feature is supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is supported

Charts

Column, Bar, Line, Area, Pie.

Feature is supported
Feature is not supported
Feature is not supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is supported

Hyperlinks

Internal & external hyperlinks.

Feature is supported
Feature is supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is supported

Comments

Text, author, visibility and size.

Feature is supported
Feature is supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not applicable for file format

Pivot Tables

Pivot Tables are loaded from and saved to XLSX file format only.

Pivot Table data calculation is currently not supported.

Feature is supported
Feature is not supported
Feature is not supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not supported

AutoFilter & SortState

Filtering and sorting can be executed in spreadsheet read from any input file format.

Filtering and sorting settings are loaded from and saved to XLSX file format only.

Feature is supported
Feature is not supported
Feature is not supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not applicable for file format

Data Validation

Validation criteria, input message, error alert.

Feature is supported
Feature is supported
Feature is not supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not applicable for file format

Sheet Header & Footer

First page, even pages and default header/footer.

Feature is supported
Feature is supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not supported

Sheet Horizontal & Vertical Page Breaks

Feature is supported
Feature is supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not applicable for file format

Sheet Split/Freeze Panes

Set pane state and position.

Feature is supported
Feature is supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not applicable for file format

Sheet Page Setup

Margins, orientation, size, etc.

Feature is supported
Feature is supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not applicable for file format

Sheet View & Print Options

Gridlines, headings, etc.

Feature is supported
Feature is supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is supported

Workbook Encryption

Feature is supported
Feature is supported
Feature is not supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not applicable for file format

Sheet Protection Options

Simple password sheet protection, restrict selection, insertion, removal, editing, etc.

Feature is supported
Feature is not supported
Feature is supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not applicable for file format

Certain Charts, Drawing Shapes, Embedded Objects

  • - supported only through preservation,

  • - cannot be created, modified or removed with GemBox.Spreadsheet,

  • - can only be preserved when loading and saving to XLSX file format.

Feature is supported
Feature is not supported
Feature is not supported
Feature is not applicable for file format
Feature is not applicable for file format
Feature is not applicable for file format
Note Note

Open XML (.XLSX) and OpenDocument (.ODS) formats have become industry standards, because they are open, standardized and extensible.

You can read XLSX files in Microsoft Excel 2003 and older by using Microsoft compatibility pack.

ODS files are fully supported in Microsoft Excel 2007 SP2.