References ▼
LEADTOOLS supports Microsoft Excel worksheets, XLS (97-2003) reading/writing and XLSX/XLSB reading.
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. |
Win32, x64.
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://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.
Win32, x64.
Help Collections
Raster .NET | C API | C++ Class Library | HTML5 JavaScript
Document .NET | C API | C++ Class Library | HTML5 JavaScript
Medical .NET | C API | C++ Class Library | HTML5 JavaScript
Medical Web Viewer .NET
Multimedia
Direct Show .NET | C API | Filters
Media Foundation .NET | C API | Transforms
Supported Platforms
.NET, Java, Android, and iOS/macOS Assemblies
Imaging, Medical, and Document
C API/C++ Class Libraries
Imaging, Medical, and Document
HTML5 JavaScript Libraries
Imaging, Medical, and Document