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.
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
12 chart types supported
Cells 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
Import data from dataset and export data to dataset
Reads Excel files into dataset: how to read data from XLS Excel document into dataset)
Convert spreadsheets from command line or .bat command files using Spreadsheet SDK Console version. Click here for details.
Excel is not required (the library uses its own custom fast engine to read, write and calculate spreadsheets). Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services) (see Microsoft’s KB #257757 for more information)
Clean and simple API to read and write Excel files
Managed .NET code compatible with different security modes