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

LEADTOOLS supports Microsoft Excel worksheets, XLS (97-2003) reading/writing and XLSX 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 Multi-page).

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

• Lll preset shapes.

• Advanced features such as conditional formatting, charts, print scaling, cell clipping.

File constants associated with this file format are:

Required DLLs and Libraries

LEADTOOLS supports writing/saving using LEADTOOLS Document Writers. For additional support details, refer to the following:

• Files to be Included With Your Application:
  • LEADTOOLS SDK DLLs (Required in all cases, unless specified as optional)
  • LEADTOOLS SDK Filter DLLs (Filter specific)
  • (*) LEADTOOLS SDK Document Writers DLLs (File format specific)
• Creating Documents Having Different File Formats
• File Format Comparison Chart > Document Writers

Supported Platforms

Platforms

Win32, x64.

XLSX

The XLSX file extension is associated with files saved with 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 Multi-page).

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

File constants associated with this file format are:

Notes

XLSX documents can be converted to various document formats types such as PDF or DOCX using LEADTOOLS Document Writer DLLs.

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.

Supported Platforms

Platforms

Win32, x64.