FreeSpire.XLS
12.1.0
See the version list below for details.
dotnet add package FreeSpire.XLS --version 12.1.0
NuGet\Install-Package FreeSpire.XLS -Version 12.1.0
<PackageReference Include="FreeSpire.XLS" Version="12.1.0" />
paket add FreeSpire.XLS --version 12.1.0
#r "nuget: FreeSpire.XLS, 12.1.0"
// Install FreeSpire.XLS as a Cake Addin #addin nuget:?package=FreeSpire.XLS&version=12.1.0 // Install FreeSpire.XLS as a Cake Tool #tool nuget:?package=FreeSpire.XLS&version=12.1.0
Free .NET API for Processing Excel Documents
Product Page | Documentation | Examples | Forum | Customized Demo
Free Spire.XLS for .NET is a Community Edition of Spire.XLS for .NET, which is a totally free Excel API for commercial and personal use. As a standalone .NET library, it enables developers to create, manipulate and convert Excel files on any .NET(C#, VB.NET, ASP.NET, .NET Core) applications without depending on Microsoft Office.
Free Spire.XLS for .NET supports both the old Excel 97-2003 format (.xls) and 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 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.
100% Standalone .NET API
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.
Freely Operate Excel Files
- Create/Save/Merge/Split/Get Excel files.
- Encrypt/Decrypt Excel files, [add/delete digital signature](add/delete digital signature), tracking changes, lock/unlock worksheets.
- Create/Add/Rename/Edit/Delete/Move worksheets.
- Insert/Modify/Remove hyperlinks.
- Add/Remove/Change/Hide/Show comments in Excel.
- Merge/Unmerge Excel cells, freeze/unfreeze Excel panes, insert/delete Excel rows and columns.
- Add/Read/Calculate/Remove Excel formulas.
- Create/Refresh pivot table.
- Apply/Remove conditional format in Excel.
- Add/Set/Change Excel header and footer.
Powerful & High Quality Excel File Conversion
- Convert Excel to PDF/HTML/XML/CSV/Image/XPS/SVG
- Convert CSV to Excel/PDF/Datatable
- Convert selected range of cells to PDF
- Convert XLS to XLSM and maintain macro
- Convert Excel to OpenDocument Spreadsheet(.ods) format
- Save Excel chart sheet to SVG/Image
- Convert HTML to Excel
Examples
Create an Excel File in C#
using Spire.Xls;
using System.IO;
namespace CreateExcelFiles
{
class Program
{
static void Main(string[] args)
{
//A: Dynamically create Excel file and save it to stream
Workbook wbToStream = new Workbook();
Worksheet sheet = wbToStream.Worksheets[0];
sheet.Range["C10"].Text = "The sample demonstrates how to save an Excel workbook to stream.";
FileStream file_stream = new FileStream("To_stream.xls", FileMode.Create);
wbToStream.SaveToStream(file_stream);
file_stream.Close();
System.Diagnostics.Process.Start("To_stream.xls");
//B. Load Excel file from stream
Workbook wbFromStream = new Workbook();
FileStream fileStream = File.OpenRead("sample.xls");
fileStream.Seek(0, SeekOrigin.Begin);
wbFromStream.LoadFromStream(fileStream);
wbFromStream.SaveToFile("From_stream.xls", ExcelVersion.Version97to2003);
fileStream.Dispose();
System.Diagnostics.Process.Start("From_stream.xls");
}
}
}
Convert Excel to PDF in C#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Spire.Xls;
namespace ToPDF
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx", ExcelVersion.Version2010);
workbook.SaveToFile("result.pdf", Spire.Xls.FileFormat.PDF);
}
}
}
Convert Excel to Image in C#
using Spire.Xls;
namespace Xls2Image
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"..\..\test.xls");
Worksheet sheet = workbook.Worksheets[0];
sheet.SaveToImage("sample.jpg");
}
}
}
Product Page | Documentation | Examples | Forum | Customized Demo
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp2.0 is compatible. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Framework | net40 is compatible. net403 was computed. net45 was computed. net451 was computed. net452 was computed. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid is compatible. |
Xamarin.iOS | xamarinios is compatible. |
-
.NETCoreApp 2.0
- System.Drawing.Common (>= 4.5.0)
- System.Security.Cryptography.Xml (>= 4.5.0)
- System.Text.Encoding.CodePages (>= 4.5.0)
-
.NETFramework 2.0
- No dependencies.
-
.NETFramework 4.0
- No dependencies.
-
MonoAndroid 0.0
- SkiaSharp (>= 1.68.0)
- System.Security.Cryptography.Xml (>= 4.6.0)
- System.Text.Encoding.CodePages (>= 4.6.0)
-
net6.0
- System.Drawing.Common (>= 6.0.0)
- System.Security.Cryptography.Xml (>= 6.0.0)
- System.Text.Encoding.CodePages (>= 6.0.0)
-
Xamarin.iOS 0.0
- SkiaSharp (>= 1.68.0)
- System.Security.Cryptography.Xml (>= 4.6.0)
- System.Text.Encoding.CodePages (>= 4.6.0)
NuGet packages (17)
Showing the top 5 NuGet packages that depend on FreeSpire.XLS:
Package | Downloads |
---|---|
Chaos.BasicFrame.CQRS
Package Description |
|
XCodeless.Excel
Package Description |
|
Ai2.Excel
based on Spire.XLS excel import and export |
|
xlsConverter
This is simple C# console application which converts XLS and XLSX files to PDF, BMP, PNG, GIF, JPG, JPEG, TIFF. |
|
CatalogosValidacionExcel_JAMG96_Net_Framework
Paquete de creacion de libros de excel con validacion de celdas y libros con informacion precargada |
GitHub repositories
This package is not used by any popular GitHub repositories.
The most release version of Free Spire.XLS relased.