This software allows for the reading and writing of XLS and XLSX documents without the need for Excel. It offers support for formula calculations, text formatting, and the management of rows, columns, and sheets. It can also be used with various programming languages.
Furthermore, the program offers an ActiveX wrapper with improved XLS and XLSX format support and boasts formula calculations, making it an excellent option for those using legacy Visual Basic 6 and ASP classic, as well as Delphi.
Technical details of the software include over 150 source code samples ready to copy and paste, support for writing XLS, HTML, TXT, CSV, and XML files, and the ability to export to PDF without requiring other libraries.
The program supports reading for CSV, XLS (Office 97-2010), XLSX (Office 2007-2010), and ODS (Open Office Calc) files, as well as formula calculation and standard functions, add-in formula like XIRR, and the ability to be used in Visual C#, Visual Basic.NET, and ASP.NET.
Other features of the program include cells, columns, rows, and worksheets support, Unicode support, 12 chart types supported, cell formatting (font, color, border style, alignment), and the ability to change existing Excel documents (change data and save the modified document, add or remove rows, columns).
Additionally, the program can export XLS files into CSV, TXT, HTML, and XML, PDF, read Excel files into datasets, and convert spreadsheets from the command line or .bat command files using Spreadsheet SDK Console version. Overall, this software is a powerful and versatile option for developers seeking an effective way to work with XLS and XLSX files.
Version 3.0.0.1699:
added support for SHA512-based encryption;
fixed caluclation of functions INDIRECT, COLUMN and ROW;
other minor improvements and bug fixes.
Version 2.9.5.1689:
added support for SHA512-based encryption;
fixed caluclation of functions INDIRECT, COLUMN and ROW;
other minor improvements and bug fixes.
Version 2.9.0.1687:
added support for SHA512-based encryption;
fixed caluclation of functions INDIRECT, COLUMN and ROW;
other minor improvements and bug fixes.
Version 2.9.0.1677:
added support for SHA512-based encryption;
fixed caluclation of functions INDIRECT, COLUMN and ROW;
other minor improvements and bug fixes.
Version 2.8.5.1638:
added support for SHA512-based encryption;
fixed caluclation of functions INDIRECT, COLUMN and ROW;
other minor improvements and bug fixes.
Version 2.80.1582a:
added support for SHA512-based encryption;
fixed caluclation of functions INDIRECT, COLUMN and ROW;
other minor improvements and bug fixes.
Version 2.8.1.1601:
added support for SHA512-based encryption;
fixed caluclation of functions INDIRECT, COLUMN and ROW;
other minor improvements and bug fixes.
Version 2.80.1582:
added support for SHA512-based encryption;
fixed caluclation of functions INDIRECT, COLUMN and ROW;
other minor improvements and bug fixes.
Version 2.70.1553:
added support for SHA512-based encryption;
fixed caluclation of functions INDIRECT, COLUMN and ROW;
other minor improvements and bug fixes.
Version 2.45.1473:
improved XLS and XLSX formats support,
improved formula calculations HLOOKUP and VLOOKUP
Support for Visual Studio 2015 added
XLSX with duplicating worksheets improved
CF.NET compatibility fixed
PDF output improved
Natural Language References support improved in formulas