Free Spire.XLS for .NET

Free .NET Excel API - Developing Excel in C#, VB.NET, ASP.NET

  • Overview
  • Features
  • Examples
  • Guideline
  • Support

Completely Free .NET Excel API

Over 1,000,000 Developers Are Already Using Our Libraries
To Create Their Amazing Applications.

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:
Free version is limited to 5 sheets per workbook and 200 rows per sheet. This limitation is enforced during reading or writing XLS or PDF files. From Free Spire.XLS v7.8, there is no any limitation when loading and saving .xlsx file format. When converting Excel files to other formats, such as PDF/XPS/Images, you can only get the first 3 pages of PDF/XPS/Images. Upgrade to Commercial Edition of Spire.XLS.We don't provide technical or any other support to the users of the free versions.

  • Convert

  • Export

  • Validate

  • Formula

  • Format

  • Chart

  • Pivot Table

  • Group

  • Merge

  • Highlight

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.

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.

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.

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.

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.

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.

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.

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.

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.

.NET

Standalone .NET API

100% independent .NET Excel class library
which doesn't require Microsoft Office to be installed on system.

VERSION

  • Excel 97-2003
  • Excel 2007
  • Excel 2010
  • Excel 2013
  • Excel 2016
  • Excel 2019
  • OpenOffice

OPERATION

Powerful Toolset, Multichannel Support

  • Import and Export data

  • Reports

  • Manage Comments

  • Work with Pivot table

  • Work with Excel Charts

  • Images and shapes

  • Find Replace Highlight

  • Manage Hyperlinks

  • Print

  • Header and Footer

  • Text and Image watermark

  • Conditional Formatting

  • Excel Formula

  • Set auto-filters & page breaks

  • Merge Split Cells and files

  • Protect, Encrypt, Decrypt

CONVERSION

Conversion File Documents with High Quality

  • TEXT

  • XPS

  • SVG

  • PDF

  • XML

  • Image

XLsx,XLSM,XLSB,ODS

  • CSV

  • HTML

  • PNG

  • BMP

  • JPEG

  • EMF

  • TIFF

  1. Chart

Excel

MAIN FUNCTION

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.

Powerful & High Quality Excel File Conversion

Free Spire.XLS for .NET has powerful conversion ability and it enables converting Excel files to most common and popular formats.

Create Excel Report from Comprehensive Workbook Designer

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.

Freely operate worksheet

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.

Easily Manipulate cells & Excel Calculation Engine at run time

  • 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.

Chart, Data and other Elements

Pro Edition $999

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.


Standard Edition $799

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.

GET STARTED

Free Trials for All Progress Solutions

Here is a brief summary of Free Spire.XLS for .NET features.

Platforms

Free Spire.XLS for .NET enables developers/programmers to build ASP.NET, Web Services, WinForms or any other type of application for any .NET Framework version from 2.0 to 4.5. Full support for 32-bit and 64-bit system.

File Format Supports

Free Spire.XLS for .NET supports lots of file formats.
  • Free Spire.XLS for .NET offers support 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, .xlsb, .xlsm), along with Open Office(.ods) format.
  • Load and save documents in the tab delimited file format.
  • Comprehensive support of the CSV format to interact with a variety of applications.
  • Easily extract text by saving in plain text format.

Conversion

Free Spire.XLS for .NET has powerful conversion ability and it enables converting Excel files to most common and popular formats.

Contents Features

Free Spire.XLS for .NET offers a wide range of features and the main features are listed as below:

Formatting Features

Free Spire.XLS for .NET provides detailed programmatic access to formatting properties of all spreadsheet elements.
  • Apply all characters formatting in the cells including fonts, colors, effects, Colors to Cells, Fonts, Gridlines, Graphic objects etc.
  • Apply different Rich Text formatting in a single cell.
  • Apply different Border Settings on cells.
  • Apply different Background Patterns on cells.
  • Apply gradient Background Patterns on cells.
  • Apply Format Settings on a Worksheet, Row, Column or a range of cells etc.

Page Setup Features

Free Spire.XLS for .NET enables developers/programmers to set PageSetup options.
  • Adjust your page orientation, scaling, paper size.
  • Specify your margins and page centering.
  • Create or edit your header and/or footer with image.
  • Set print area, print titles, or turn on gridlines etc
  • Managing Page Breaks

Feature Details

Support Excel97~2003 Excel2007 Excel2010 Excel2013 Excel2016
Operation Create New Workbook Edit Existing Workbook
Save to file Save to stream Save as web response
Workbook Properties Setup Worksheet Print Setup
Worksheet Copy Cells Data Copy Cells Styles Copy Cells Merge
Lock Worksheet Unlock Worksheet
Data Table Import Data Table Export
Freezepane Group
Filter Data Validation
Marker Designer Template Auto Populate Style Copy Variables
Format Cells Number Format Text Alignment Font
Cell Border Cell Fill Cell Protection Interior
Content Formula (all 531 entries supported) Chart (all 74 types supported)
Image Pivot Table RichText
Hyperlink Comments VBA
Convert XML Image CSV Text
Not supported in Standard Edition
Request free customized demo just for you.

High Quality Conversion

Convert Excel to PDFTutorials / Live Demo / Orginial Excel and PDF file

Convert Excel to PDF

Convert Excel to ImageTutorials / Orginial Excel and Image file

Convert Excel to Image

Excel Chart

Excel ChartTutorials / Live Demo / C# Code

Excel Chart

Marker Designer

Marker DesignerTutorials / Live Demo / C# Code

Marker Designer

Data Import/Export

Import Excel from DataTableTutorials / Live Demo / C# Code

Import Excel from DataTable

Export Excel to DataTableTutorials / Live Demo / C# Code

Export Excel to DataTable

Runtime Excel Calculation

Runtime Excel CalculationTutorials / Live Demo / C# Code

Runtime Excel Calculation

Create Excel Pivot Table

Create Excel Pivot TableTutorials / Live Demo / C# Code

Runtime Excel Calculation

Beginners Guide is the first step towards learning the basic information of Free Spire.XLS for .NET

Program Guide lists the detailed features of our Free Spire.XLS for .NET and you can search for the information you want.

The Videos give an operation guide by video. You can check the produce step by step.

Main Functions contain the main features of our Free Spire.XLS for .NET and you can have brief information of it.

Frequently asked question for Free Spire.XLS of technical and function issues.

We guarantee one business day Forum questions Reply.

We guarantee one business day E-mail response.

Free Customized service for OEM Users.

Skype name: iceblue.support

Apply for a Free Trial License File.

To help you get started quickly, we offer free customized demos to our customers. Please contact support@e-iceblue.com for the free demo. Make sure the demo you want meets the below requirements.
  • It relates to our components stored on E-iceblue online store.
  • It costs less than 2 hours for us to complete it. If it costs more than 2 hours, please contact our sales@e-iceblue.com

If you have tried out Spire.XLS and found it useful, please consider sharing your experience with others. By sharing your testimonial with us, you will not only help others to make the right decision but will also to earn rewards from us. Please send your testimonials to sales@e-iceblue.com.