Free Spire.XLS for .NET

  • Overview
  • Features
  • Examples
  • Guideline
  • Support

Free Spire.XLS for .NET is the Community Edition of Spire.XLS for .NET, designed specifically for individual developers and small projects. This totally free Excel API allows you to create, read, edit, and manage Excel files in any .NET application, including C#, VB.NET, ASP.NET, and .NET Core—without relying on Microsoft Office.

As a standalone library, Free Spire.XLS for .NET is ideal for personal use to process data, apply data validation, create charts, and more without relying on Microsoft Office. 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:

The free version of Spire.XLS for .NET is limited to 5 sheets per workbook and 200 rows per sheet. This limitation is enforced during reading or writing XLS or PDF files. For Free Spire.XLS v7.8 and above, there is no limitation when loading and saving .xlsx file format. When converting Excel files to other formats like PDF, XPS, and Images, you can only get the first 3 pages of the target format. If you need technical support or want to unlock more functions, upgrade to the Commercial Edition of Spire.XLS for .NET now.

  • Convert

  • Export

  • Validate

  • Formula

  • Manage

  • Chart

  • Pivot Table

  • Group

  • Merge

  • Highlight

Convert Excel to Other Formats

Convert Excel to PDF to ensure your report looks the same on any device when sharing with partners. Moreover, you can convert it to more formats including XML, TEXT, or Image.

Export Data from Database to Excel

Data will be automatically analyzed and visualized when being exported to Excel. Even non-database users can get easy access and proceed with the data.

Apply Data Validation

Set your own Excel dropdown list of Excel to make sure all data entries are accurate and consistent. It saves much effort for post data processing as you have no need to check data manually.

Insert Formulas and Functions

Excel is convenient for its various formulas to calculate values in a cell or in a range of cells. Free Spire.XLS for .NET makes it possible that you can solve these math problems without the installation of Microsoft Excel.

Apply Conditional Formatting

Use conditional formatting in Excel to highlight or differentiate data based on specific criteria. You can apply special formats with Free Spire.XLS for .NET to make key information stand out in your worksheets.

Create Chart in Excel

Chart is a common tool in Excel for easier view and analysis of data. Users can use free Spire.XLS for .NET to set and display data in a graphical representation with their specific needs.

Create a Pivot Table

Users can create pivot tables according to the existence data, allowing users to quickly categorize, calculate, summarize and analyze large amounts of data with a concise tabular format.

Group Cells, Rows and Columns

When working with a large amount of data, grouping rows, columns, or specific cells that contain similar information makes the worksheet looks more compact, logical, and understandable to most users.

Merge Excel Files into One

You can use Free Spire.XLS for .NET to merge multiple Excel files into one by applying different worksheets. Merging Excel files with associated content enhances the work efficiency a lot as the data will be easier to share and read.

Highlight Key Data

You can highlight all cells containing a specific value with the same background color using code to make the value outstanding and more easily to be found out, helping users to grab the key data quickly.

.NET

Standalone .NET API

100% Independent .NET Excel Class Library
No Microsoft Office Required on System

  • .NET Framework
  • .NET CORE
  • Xamarin
  • Microsoft Azure

VERSION

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

Why Choose Free Spire.XLS for .NET to Work with Excel Files?

A free yet powerful Excel library for .NET — discover six reasons developers love it:

100% Standalone .NET Library

Works without Microsoft Excel or Office Automation. Just reference the DLL and start coding.

Totally Free to Use

Free edition with no time limits or watermarks — ideal for learning, evaluation, and small internal tools.

Comprehensive Excel Features

Create, edit, and read Excel files with complex formulas, charts, pivot tables, data validation, and more.

Strong Documentation & Sample Codes

Comprehensive demo projects and code samples for easier Excel feature integration.

Export to PDF, HTML, and Image

Convert Excel worksheets into high-quality PDFs, web pages, or images with accurate layout.

Supports .NET Framework and .NET Core

Compatible with .NET Framework, .NET Core, and .NET 9.0 — easy to integrate across platforms.

Excel Operations in .NET Made Easy

Perform advanced Excel tasks without Microsoft Office.

  • Load and Save Excel Files or Streams

  • Insert and Manage Images, Shapes, and Icons

  • Find, Replace, and Highlight Excel Content

  • Work with Pivot Tables for Data Analysis

  • Add or Remove Hyperlinks in Cells

  • Apply Conditional Formatting Rules

  • Customize Headers, Footers, and Page Settings

  • Merge, Split, or Combine Cells and Worksheets

  • Use and Evaluate Excel Formulas

  • Configure Printing and Page Breaks

  • Import and Export Data (CSV, XML formats)

  • Manage Cell Comments and Notes

  • Track Changes and Workbook

  • Add Text or Image Watermarks

  • Protect, Encrypt, and Decrypt Excel Files

Conversion File Documents with High Quality

TEXT XPS SVG XML
PDF UOS Postscript
Image
Arrow Down
PNG BMP JPEG EMF TIFF
Arrow to Excel
Excel Icon

XLSX, XLSM, XLSB, ODS

Arrow to Excel
Arrow to Excel
CSV HTML
Chart Excel

Pro Edition $999

  • No file format and size limitation
  • 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.
  • Able to print according to your needs
Buy Now

Standard Edition $799

  • No file format and size limitation
  • No Conversion function
  • No print function
Buy Now

Free Edition $0

  • Limited to 5 sheets per workbook and 200 rows per sheet
  • Provide trial conversion function, as you can only get the first 3 pages of PDF/XPS, and can only convert the first 3 sheets to image
  • Limited print function
Download

GET STARTED

Free Trials for All Advanced Solutions

The following content covers several unique features to help you choose Free Spire.XLS for .NET.

Platforms

Free Spire.XLS for .NET is a powerful Excel component that enables C# and .NET developers to create ASP.NET, Web Services, and WinForms applications targeting .NET Framework versions 2.0 to 4.5. It fully supports both 32-bit and 64-bit systems.

Supported File Formats

Free Spire.XLS for .NET supports multiple file formats including:
  • Old Excel 97-2003 format (.xls)
  • New Excel 2007, Excel 2010, Excel 2013, Excel 2016, and Excel 2019 (.xlsx, .xlsb, .xlsm)
  • Open Office format (.ods)
  • Load and save documents in the tab delimited file format
  • Comprehensive support of the CSV format to interact with a variety of applications and database
  • Save Excel files in plain text format to extract text with ease

Conversion

Free Spire.XLS for .NET enables converting Excel files to the most common and popular formats in the list below:

Contents Features

Free Spire.XLS for .NET offers most features that you can do in the Microsoft Office, including the following:

Formatting Features

Free Spire.XLS for .NET offers comprehensive programmatic control over Excel spreadsheet formatting, including all elements and styles as follows:
  • All character's formatting including fonts, colors, effects, fill, and shading
  • All number format settings supported in MS Excel can be applied
  • Set all types of text alignment settings
  • Different fonts, colors to cells, gridlines, graphic objects, etc.
  • Various border settings and background patterns on cells

Page Setup

Free Spire.XLS for .NET enables individual developers and programmers to customize Setup options:
  • Adjust page orientation, scaling, paper size, margins, and page centering
  • Create or edit the header and footer with image.
  • Set print area, titles, 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 [email protected] 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 [email protected]

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 [email protected].