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 (it can be created, modified or removed with GemBox.Spreadsheet).
- Feature is not applicable for file format (file format is not designed to support this kind of feature).
- 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
File formats from which GemBox.Spreadsheet can read.
File formats to which GemBox.Spreadsheet can write.
Built-in & custom workbook properties.
Number formats, text alignment, font settings, borders, background fill, column width, row height.
In-line Text Formatting
Different font settings for parts of a textual cell value.
Conditional Formatting is loaded from and saved to XLSX file format only.
Conditional Formatting calculation is currently not supported.
Row/Column Outline & Group
Defined Names & Formulas
Workbook and worksheet scope defined names, formula reading/writing.
JPEG, PNG, GIF, BMP, TIF, EMF, WMF, EXIF, ICO.
Column, Bar, Line, Area, Pie.
Internal & external hyperlinks.
Text, author, visibility and size.
Pivot Tables are loaded from and saved to XLSX file format only.
Pivot Table data calculation is currently 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.
Validation criteria, input message, error alert.
Sheet Header & Footer
First page, even pages and default header/footer.
Sheet Horizontal & Vertical Page Breaks
Sheet Split/Freeze Panes
Set pane state and position.
Sheet Page Setup
Margins, orientation, size, etc.
Sheet View & Print Options
Gridlines, headings, etc.
Sheet Protection Options
Simple password sheet protection, restrict selection, insertion, removal, editing, etc.
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.
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.