Spreadsheet SDK - read, write and calculate Excel spreadsheets in your applications without Office

Add the functionality to read and write data from/to
Excel XLS, XLSX, CSV documents
to your desktop and web-applications


BarCode Generator SDK Main Features

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
100% C# code compatible with different security modes for ASP.NET web-servers
Comes with over 150 ready "copy and paste" source code samples for C#, VB.NET, ASP.NET, Visual Basic 6, ASP Classic
Includes .NET, ActiveX and command line (console) interfaces so it can be used from different environments
Royalty free licensing: no additional run-time licenses or run-time fees

More tech details

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
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.
New (version 2.40.1358): improved handling of incorrect formula values while calculating;
CSV to XLS samples updated
Improved XLS format handling
License updated

Screenshot Gallery (click to view):

Click to view full size screenshot Click to view full size screenshot Click to view full size screenshot

Filed in: Spreadsheet SDK