Read Excel docs, write to Excel files (XLS, XLSX, CSV) in .NET and ASP.NET applications with Bytescout Spreadsheet SDK. MS Excel is not required.Supports formula calculations, generates XLS with formatting, multiple worksheets, export and save to PDF. 100% managed C# code. Includes .NET, ActiveX and command line (console) interfaces so can be used from different environments. Works in .NET and also can be used in legacy Visual Basic 6 and ASP classic, Delphi. Comes with over 150 ready "copy and paste" source code samples for C#, VB.NET, ASP.NET, Visual Basic 6, ASP Classic. Technical 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; 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's new in this version:
- 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 with encoding selection;
- number formatting related issues fixes;
- minor bug-fixes.