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

LEADTOOLS supports Microsoft Excel worksheets, XLS (97-2003) reading/writing and XLSX/XLSB reading.

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).

Additional features supported by LEADTOOLS:

File constants associated with this file format are:

Constant Read Support Write Support Description
FILE_XLS 24 BPP Yes [341] XLS, Excel spreadsheet file.

Required DLLs and Libraries

Platforms

Win32, x64.

XLSX / XLSB

The XLSX file extension is associated with files saved as Microsoft Excel (2007/2010), 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 https://www.ecma-international.org/publications-and-standards/standards/ecma-376/.

The default extension used for this format is: XLSX.

Additional features supported by LEADTOOLS:

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

File constants associated with this file format are:

Constant Read Support Write Support Description
FILE_XLSX 24 BPP See Note [351] Microsoft Excel Spreadsheet.
FILE_XLSB 24 BPP See Note [403] Microsoft Excel Binary file format (XLSX Binary).

Note

You can set various options before loading Excel (XLS or XLSX/XLSB) files using LFileSettings::SetExcelOptions.

Required DLLs and Libraries

Platforms

Win32, x64.

Help Version 22.0.2023.2.2
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2023 LEAD Technologies, Inc. All Rights Reserved.

LEADTOOLS Raster Imaging C++ Class Library Help
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2023 LEAD Technologies, Inc. All Rights Reserved.