Read and write XLS, XLSX from ASP.NET, .NET, VB, C#, PHP and other programming languages without Excel installed! Supports formula calculations, text formatting, rows, columns, sheets management and much more! Can be used from legacy Visual Basic 6 and ASP classic, Delphi through special ActiveX wrapper with improved XLS and XLSX formats support and formula calculations Technical details: # 150+ source code samples ready to copy and paste from! # Writing for XLS, HTML, TXT, CSV, XML support; # Exports to PDF without any other libraries required; # Reading for CSV, XLS (Office 97-2010), XLSX (Office 2007-2010) and ODS (Open Office Calc) support; # Formula calculations (standard functions, add-in formula like XIRR) support; # Can be used in Visual C#, Visual Basic.NET and ASP.NET; # Cells, columns, rows, worksheets support; # Unicode support; # 12 chart types supported; # Cell formatting (font, color, border style, alignment) is supported; # Capable of changing existing Excel documents (change data and save modified document, add or remove rows, columns); # Export XLS into CSV, TXT, HTML and XML, PDF; # Reads Excel files into dataset; # Convert spreadsheets from command line or .bat command files using Spreadsheet SDK Console version.
What is new in this release:
- Added support for SHA512-based encryption
- Fixed calculation of functions INDIRECT, COLUMN and ROW
What is new in version 2.60.1545:
What is new in version 2.50.1535:
Version 2.50.1535 Improved support of old versions of protected XLS documents. Improved parsing of formulas. Added Spreadsheet.ExportToJSON() and Spreadsheet.ImportFromJSON() methods. Added support of Open XML and OpenDocument files with wrong file extension.
What is new in version 2.46.1513:
Version 2.46.1513 may include unspecified updates, enhancements, or bug fixes.
What is new in version 2.40.1358:
- improved handling of incorrect formula values while calculating
- CSV to XLS samples updated
- improved XLS format handling
- license updated