File Formats: MS-Excel format (XLS, XLSX)

LEADTOOLS supports reading the following Microsoft Excel worksheet formats:

XLS (97-2003)

The XLS file extension is used for Microsoft Excel worksheets. Excel is a popular spreadsheet program used with data like numbers, formulas, text, and drawing shapes. Excel is part of the Microsoft Office Suite of software. XLS files use a Binary Interchange File Format to store spreadsheet data and are proprietary to Microsoft..

LEADTOOLS supports loading XLS (97-2003) files through the XLS filter.

 

MS-Excel (XLS) file format has the following features:

 

File constants associated with this file format are:

Constant

Read Support

Write Support

Description

FILE_XLS

24 BPP

None

[341]  XLS, Excel spreadsheet file.

Required DLL: LFXLS. For a listing of the exact DLLs needed, based on the toolkit version, refer to Files To Be Included With Your Application.

Platforms

Win32, x64.

NOTE: LEADTOOLS also supports writing this file format using the LEADTOOLS Document Writers.  For more information on the LEADTOOLS Document Writers SDK, see Creating Documents Having Different File Formats.

XLSX (2007)

The XLSX file extension is associated with Microsoft Excel 2007, one of the most popular and powerful tool you can use to create format spreadsheets, graphs and much more. The .xlsx files are used in Microsoft Excel 2007 for Workbooks, spreadsheet document files. They serve the same purpose as the .xls Microsoft Excel 97 to 2003 Workbook files, but use the new file extensions and file formats for Excel Spreadsheets based on Open XML data format. The .xlsx files use ZIP compression for smaller file sizes. LEADTOOLS supports loading XLSX (2007) files through XLSX filter. For more information, refer to http://www.ecma-international.org/publications/standards/Ecma-376.htm. For sample images, refer to http://www.captivestats.com/downloads/samples/.

The default extension used by this format is: XLSX.

This file format does not support QFactor, progressive loading, stamps, Lossless JPEG compression or Sub-formats.

LEAD supports loading multi-page files in this format.

File constants associated with this file format are:

Constant

Read Support

Write Support

Description

FILE_XLSX

24 BPP

None

[351] Microsoft Office 2007 Spreadsheet.

Required DLL: LFXLX.DLL. For a listing of the exact DLLs needed, based on the toolkit version, refer to Files To Be Included With Your Application.

Platforms

Win32, x64.