|
Free Spire.XLS for .NET is a Community Edition of the Spire.XLS for .NET, which is a totally free Excel API for commercial and personal use. As a standalone .NET library, Free Spire.XLS for .NET enables developers to create, manage and manipulate Excel files on any .NET(C#, VB.NET, ASP.NET, .NET Core) 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, Excel 2010, Excel 2013, Excel 2016 and Excel 2019 (.xlsx, .xlsm). Friendly Reminder: |
 |
|||
|
Spire.XLS Pro Edition supports converting files from Excel to PDF, HTML, Excel to CSV, Excel to Text, Excel to Image and Excel to XML(the Excel can be either .XLS or .XLSX) and it is included in Spire.XLS Pack.  |
Spire.XLS for .NET Standard Edition only can be used for .NET and doesn't support print and conversion function. |
Free Edition $0
Free version is limited to 5 sheets per workbook and 200 rows per sheet. It doesn't support the print function. When converting Excel files to other formats, such as you can only get the first 3 pages of PDF/XPS, and you can only convert first 3 sheets to Images.  |
|
.NET
|
||||||||||||||||||||||
|
||||||||||||||||||||||
|
Excel
Version |
||||||||||
|
||||||||||
|
Operation
|
||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||
|
Conversion
|
|
|||||||||||||||||||||||||||||
|
Only Free Spire.XLS, No Microsoft Office Automation
Free Spire.XLS for .NET is a 100% standalone Excel .NET library 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. |
|
|
-
Convert Excel to PDF
Whenever you need to share an important Excel report with a partner, it's best to convert the file to PDF to ensure it looks the same as it does on your device.
-
Convert Excel to Image
When you want to display an Excel file in a video or send it to others in a ready-only format, you can convert it to image.
-
Convert Excel to XPS
XPS (XML Paper Specification) is a fixed-layout file format designed to preserve document fidelity and provide device-independent document appearance. If you just want to distribute, archive or print an Excel file, convert it to XPS would be an option.
-
Create a Chart
Chart is a fantastic tool to visually group and analyze data. It provides the reader with the structure of the data set and displays the data in a graphical representation, making it easier for most users to see the data.
-
Create a Pivot Table
Pivot table is a kind of interactive table that allow users to quickly categorize, calculate, summarize and analyze large amounts of data in a concise tabular format.
-
Export Data from Database to Excel
When data is exported from a database to Excel, it can be analyzed and visualized, as well as viewed and processed by users who are not database users.
-
Export Data from Excel to Word
If you want to reference Excel data in a Word report, you can export the specified cell ranges or entire worksheet as a Word table and preserve the original layout and formatting.
-
Apply Data Validation
Data validation in Excel controls what kind of data can be entered into a certain cell, which ensures that all data entries are accurate and consistent.
-
Apply Conditional Formatting
Conditional formatting is a helpful feature that allows applying special formats to cells meeting specific criteria. It is often used to emphasize or differentiate data stored in worksheets.
-
Find and Highlight
You can find all cells containing a specific value and highlight them with the same background color to make the value outstanding and more easily to be found out.
-
Group Rows or Columns
For worksheets with large amounts of data, grouping rows or columns that contain similar information can make the worksheet more compact and understandable.
-
Insert Formulas and Functions
Formula is an expression that calculates values in a cell or in a range of cells, while function is a predefined formula already available in Excel. Both formulas and functions are very useful when you need to calculate numbers or solve math problems in Excel.
-
Merge Excel Files
Merging Excel files with associated content can help us work with worksheet data more easily and also make it easier to share and read the contents of our workbooks.
