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
# 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.
added support for SHA512-based encryption;
fixed caluclation of functions INDIRECT, COLUMN and ROW;
other minor improvements and bug fixes.
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.
Added source code example for unamanaged C++
Added support for TRIM and LOOKUP functions
Fixed VLOOKUP function
Fixed calculation of formulas with logcal values
Fixed images location when exporting to PDF
read xls, write xls, read csv, read xlsx, write xlsx in .NET and ASP.NET
.NET 4.50 dlls added
Visual Studio 2013 support improved
XLSX and XLS writing improved
Index Out Of Range error fixed
Formula calculation improved
new Worksheet.SaveAsTXT, SaveAsCSV, SaveAsXML methods
Read XLS and write XLS in .NET better with the new version;
improved XLS and XLSX support;
minor issues fixed.
Write and read XLS in ASP.NET and .NET with new version;
improved support for shared formulas in XLSX format;
AutoFit fixes minor issues related to image sizes;
new property: Worksheet.AutoFitRows to enable auto fit for rows;
issue fixed related to unlocked ranges on protected worksheets.
Spreadsheet SDK range class improved, now provides .SpecialCells functionality;
exceptions handling improved;
adding image to spreadsheet document source code sample fixed;
fixing issues with some formulas in XLSX format.
Spreadsheet SDK now lets view spreadsheet in your application: now includes SpreadsheetControl for WinForms to view spreadsheets in WinForms applications;
improved support for sandboxed environments;
XLSX format reading and writing improved (better preserves layout while reading and saving XLSX).