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

LEADTOOLS supports reading the following Microsoft Excel worksheet formats:

XLS (97-2003)

The XLS file extension is used for files saved as Microsoft Excel worksheets. Excel is a popular spreadsheet program used with data like numbers and 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 has an XLS filter that supports XLS (97-2003) and has the following features:

• Supports loading files with different DPI

• Supports loading files with different page width and height

• Supports loading Excel sheets with different rasterization options (Best Fit or Multi-page)

• Supports loading text box objects

File constants associated with this file format are:

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/2010)

The XLSX(2007/2010) file extension is associated with files saved as Microsoft Excel (2007/2010) files, one of the most popular and powerful tools you can use to create and format spreadsheets, graphs and much more. The .xlsx files are used in Microsoft Excel (2007/2010) for Workbooks, spreadsheet, and document files. They serve the same purpose as the corresponding .xls Microsoft Excel 97 to 2003 Workbook files, but use the new file extension. The file format is based on the Open XML data format. ZIP compression is used on .xlsx files, resulting in smaller file sizes. LEADTOOLS has an XLSX filter to support the loading of XLSX (2007/2010). For more information, refer to http://www.ecma-international.org/publications/standards/Ecma-376.htm.

The default extension used for 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.

LEAD supports loading text box objects.

File constants associated with this file format are:

Required DLL: LFXLX.DLL, .NET Framework 3.5, and the DocumentFormat.OpenXml.dll(ver. 2.0). 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.