In This Topic ▼

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:

Loading files as a raster image or SVG (Scalable vector graphics) document.
Loading files with different DPI.
Loading Excel sheets with different rasterization options (Best Fit or Multipage).
Loading sheets as multiple pages with different page width and height and with both horizontal and vertical page order (Down then over and Over then down).
All preset shapes.
Advanced features such as conditional formatting, charts, print scaling, cell clipping.

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

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.

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:

Loading 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 Excel sheets with different rasterization options (Best Fit or Multipage).
Loading sheets as multiple pages with different page width and height and with both horizontal and vertical page order (Down then over and Over then down).
All preset shapes.
Advanced features such as conditional formatting, charts, print scaling, and cell clipping options.
Works in all platforms.

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

LFXLX
.NET Framework 4.0
DocumentFormat.OpenXml.dll(ver. 2.5)
For a listing of the exact DLLs and libraries needed, based on the toolkit version, refer to Files To Be Included With Your Application.

Platforms

Win32, x64.

Download our FREE evaluation

Help Version 22.0.2023.2.2

LEADTOOLS Raster Imaging C++ Class Library Help

Introduction

Version History

Getting Started

LEADTOOLS Raster Imaging Features

Redistributables/Files To Be Included With Your Application

Quick Reference

Classes and Member Functions

Summary of Features