File Formats: Microsoft Excel Spreadsheet (XLSX/XLS/XLSB)

The XLSX, XLS, and XLSB file extensions are used for Microsoft Excel spreadsheets, part of the Microsoft Office Suite of software.

XLSX/XLS files are used to store and manage data such as numbers, formulas, text, and drawing shapes.

XLSX is part of Microsoft Office Open XML specification (also known as OOXML or OpenXML), and was introduced with Office 2007. XLSX is a zipped, XML-based file format. Microsoft Excel 2007 and later uses XLSX as the default file format when creating a new spreadsheet. Support for loading and saving legacy XLS files is also included.

XLS is the default format used with Office 97-2003. XLS is a Microsoft proprietary Binary Interchange File Format. Microsoft Excel 97-2003 uses XLS as the default file format when creating a new document.

XLSB is the Excel Binary File Format, a macro enabled spreadsheet.

Note: XLSX, XLS, and XSLB file formats are supported in the Document/Medical products.

Features

LEADTOOLS supports all flavors of the Microsoft Excel spreadsheet format, from Office 97 XLS up to XLSX.

LEADTOOLS uses the XLSX filter to load XLSX files.

LEADTOOLS uses the XLS filter to load XLS files.

Additional features supported by LEADTOOLS:

• Loading XLSX/XLS files as a raster image or SVG (Scalable vector graphics) document
• Loading files with different DPI
• Loading files with different page width and height
• Loading documents with different rasterization options
• Supporting advanced features such as conditional formatting, charts, print scaling, and cell clipping

The default extension used by this format is: XLSX or XLS.

The CodecsExcelOptions Class provides options for loading XLS/XLSX files.

File Constants

The file constants associated with this file format are:

Required DLL: Leadtools.Codecs.Xlx.dll or Leadtools.Codecs.Xls.dll. The XLSX file format requires .NET Framework 4.0 or later, as well as the DocumentFormat.OpenXml.dll (ver. 2.0). For a listing of the exact DLLs needed, based on the toolkit version, refer to XLS, XLSB Format Support and XLSX Format Support

Using Document Writers

LEADTOOLS supports writing the XLS file format using the LEADTOOLS Document Writers. For more information, refer to LEADTOOLS Document Writers SDK.

For additional support details, refer to the following topics:

• Files to be Included With Your Application:
  • Mandatory DLLs for all .NET, Android, iOS/macOS, HTML5 JavaScript, and Java applications
  • Raster Codecs File Format Support
  • LEADTOOLS DocumentWriters and VirtualPrinter SDKs File Format Support.
• Leadtools.Document.Writer Introduction
• Document Writers: Programming with the LEADTOOLS Document Writers
• File Format Comparison Chart > Document Writers