Free Spire.XLS for .NET is a Community Edition of the Spire.XLS for .NET, which is a totally free Excel component for commercial and personal use. As a standalone C#/VB.NET component, Free Spire.XLS for .NET enables developers to create, manage and manipulate Excel files on any .NET applications.
Free Spire.XLS for .NET is a standalone Excel .NET library and does not depend on Microsoft Office Excel. It supports both for the old Excel 97-2003 format (.xls) and for the new Excel 2007 and Excel 2010 (.xlsx, .xlsm).
Free version is limited to 5 sheets per workbook and 150 rows per sheet. This limitation is enforced during reading or writing XLSX, XLS, or PDF files. When converting Excel files to PDF files, you can only get the first 3 pages of PDF file. Upgrade to Commercial Edition of Spire.XLS
Main FunctionsOnly Free Spire.XLS, No Microsoft Office AutomationFree Spire.XLS for .NET is a 100% standalone Excel .NET component without requiring Microsoft Excel or Microsoft Office to be installed on the system.Free Spire.XLS for .NET has powerful conversion ability and it enables converting Excel files to most common and popular formats.Free Spire.XLS for .NET enables developers to generate Excel workbook from scratch, or load a workbook from either folder or file stream. Developers can also save it to file, file stream or web response. Free Spire.XLS for .NET offers a wide range of security features including Excel encryption/decryption, cells hide/unhide, and worksheets lock/unlock.Free Spire.XLS for .NET enables developers to create, add, delete, rename, edit and move worksheet in either C#, VB.NET or ASP.NET. Developers can also copy, move, and consolidate across worksheets with full contents. This professional Excel .NET class library also embeds many flexible options for displaying worksheets, such as page breaks, zoom-setting, freeze panes, headers/footers, print paper size and print area etc.
- Free Spire.XLS for .NET supports merge/unmerge excel cells, add/delete excel cell, insert excel rows and interiors, hide/unhide excel rows and columns, freeze/unfreeze Excel Panes.
- Free Spire.XLS for .NET supports add, read and calculate Excel formulas.
- Free Spire.XLS for .NET provides a wide range of Charts: Pie Chart, Bar Chart, Column Chart, Line Chart, Radar Chart and etc.
- Free Spire.XLS for .NET component supports data transportation between database and Excel in C# VB.NET or ASP.NET.
- Free Spire.XLS for .NET supports hyperlinks, templates and comments.
- Free Spire.XLS for .NET supports creating, reading Excel Pivot Table.