Spire.XLS
14.10.2
dotnet add package Spire.XLS --version 14.10.2
NuGet\Install-Package Spire.XLS -Version 14.10.2
<PackageReference Include="Spire.XLS" Version="14.10.2" />
paket add Spire.XLS --version 14.10.2
#r "nuget: Spire.XLS, 14.10.2"
// Install Spire.XLS as a Cake Addin #addin nuget:?package=Spire.XLS&version=14.10.2 // Install Spire.XLS as a Cake Tool #tool nuget:?package=Spire.XLS&version=14.10.2
.NET API for Processing Excel Documents
Product Page | Documentation | Examples | Forum | Temporary License | Customized Demo
Spire.XLS for .NET is a professional Excel .NET API that can be used to create, read, write, convert and print Excel files in any type of .NET ( C#, VB.NET, ASP.NET, .NET Core, .NET 5.0, MonoAndroid and Xamarin.iOS) application without installing Microsoft Office.
The API supports both the old Excel 97-2003 format (.xls) and the new Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019 (.xlsx, .xlsb, .xlsm), along with Open Office(.ods) format. It features fast and reliably compared with developing your own spreadsheet manipulation solution or using Microsoft Automation.
100% Standalone .NET API
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, 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/Excel to HTML/Excel to XML/Excel to CSV/Excel to Image/Excel to XPS/Excel to SVG
- Convert CSV to Excel/CSV toPDF/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
- Convert Excel to Markdown
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 | Temporary License | 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 is compatible. net481 was computed. |
-
.NETCoreApp 2.0
- System.Drawing.Common (>= 4.5.0)
- System.Security.Cryptography.Pkcs (>= 4.5.0)
- System.Security.Cryptography.Xml (>= 4.5.0)
- System.Security.Permissions (>= 4.5.0)
- System.Text.Encoding.CodePages (>= 4.5.0)
-
.NETFramework 4.0
- No dependencies.
-
.NETFramework 4.8
- No dependencies.
-
net6.0
- System.Drawing.Common (>= 6.0.0)
- System.Security.Cryptography.Pkcs (>= 6.0.0)
- System.Security.Cryptography.Xml (>= 6.0.0)
- System.Security.Permissions (>= 6.0.0)
- System.Text.Encoding.CodePages (>= 6.0.0)
NuGet packages (18)
Showing the top 5 NuGet packages that depend on Spire.XLS:
Package | Downloads |
---|---|
Spire.Office
Spire.Office for .NET is a combination of Enterprise-Level Office .NET components offered by E-iceblue. It includes Spire.Doc, Spire XLS, Spire.Presentation, Spire.PDF, Spire.DataExport, Spire.PDFViewer, Spire.DocViewer, Spire.Email and Spire.BarCode. Spire.Office contains the most up-to-date versions of the above .NET components. From Spire.Office 3.10.1, Spire.Office supports to work on .NET Core,.NET Standard, Xamarin. With Spire.Office for .NET, developers can create a wide range of applications. It enables developers to open, create, modify, convert, print, View MS Word, Excel, PowerPoint and PDF documents. Furthermore, it allows users to export data to popular files such as MS Word/Excel/RTF/Access, PowerPoint, PDF, XPS, HTML, XML, Text, CSV, DBF, Clipboard, SYLK, etc. As an independent Office .NET component, Spire.Office doesn't need Microsoft Office to be installed on neither the development nor target systems. In addition, it is a better alternative to MS Office Automation in terms of security, stability, scalability, speed, price and features. Spire.Office for .NET can be linked into any type of a 32-bit or 64-bit .NET application including ASP.NET, Web Services and WinForms for .NET Framework version 2.0 to 4.5, .NET Core, .NET standard 2.0 |
|
Spire.Officefor.NETStandard
It only contains the dlls for .NET standard 2.0 |
|
Spire.OfficeViewer
Spire.OfficeViewer for .NET is a powerful Office Viewer component for .NET. It enables developers to load Word, Excel, Presentation slides and PDF files and view them from code. As a standalone .NET class library, Spire.OfficeViewer mainly focus on how to display office documents and PDF files. It enables developers/programmers to directly view and print office files and PDFs for their .NET applications. It supports to view the DOC, DOCX, DOT, XLS, XLSX, XLSB, ODS, PPT, PPTX, PPS, PPSX and PDF file formats. Spire.OfficeViewer is a totally independent .NET library which doesn't need to install Microsoft Office and Adobe Reader or any other 3rd party software/library on system. Main Functions Load office documents and PDF from file and view; Switch to target page Fit page; Fit width; Fit height Page down/up; Zoom in/out; Hand tool; Print; |
|
KCore_bfagundes
My personal library to work SAP projects. |
|
HBInformationBase
Huabin science and technology basic information database |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
14.10.2 | 947 | 10/31/2024 |
14.9.5 | 7,261 | 9/27/2024 |
14.9.1 | 5,476 | 9/6/2024 |
14.8.2 | 8,507 | 8/15/2024 |
14.7.2 | 6,552 | 7/15/2024 |
14.6.6 | 10,125 | 6/25/2024 |
14.5.3 | 12,053 | 5/23/2024 |
14.4.7 | 9,480 | 4/25/2024 |
14.3.3 | 20,971 | 3/20/2024 |
14.2.1 | 24,295 | 2/5/2024 |
14.1.0 | 19,587 | 1/5/2024 |
13.12.0 | 8,355 | 12/12/2023 |
13.11.4 | 13,839 | 11/24/2023 |
13.10.1 | 17,715 | 10/17/2023 |
13.9.1 | 18,213 | 9/14/2023 |
13.8.9 | 12,732 | 8/25/2023 |
13.8.0 | 81,677 | 8/2/2023 |
13.7.0 | 45,416 | 7/4/2023 |
13.6.0 | 11,402 | 6/14/2023 |
13.5.6 | 26,983 | 6/1/2023 |
13.5.0 | 17,200 | 5/12/2023 |
13.4.0 | 18,217 | 4/10/2023 |
13.3.2 | 27,464 | 3/15/2023 |
13.2.4 | 43,627 | 2/16/2023 |
13.1.1 | 55,143 | 1/17/2023 |
12.12.3 | 46,388 | 12/23/2022 |
12.11.3 | 41,161 | 11/25/2022 |
12.10.1 | 41,948 | 10/20/2022 |
12.9.2 | 56,018 | 9/23/2022 |
12.8.1 | 59,907 | 8/17/2022 |
12.7.1 | 35,952 | 7/13/2022 |
12.6.1 | 40,535 | 6/13/2022 |
12.5.3 | 13,426 | 5/26/2022 |
12.5.1 | 13,004 | 5/13/2022 |
12.4.1 | 29,475 | 4/15/2022 |
12.3.8 | 90,064 | 3/23/2022 |
12.3.2 | 13,468 | 3/4/2022 |
12.1.0 | 26,234 | 1/24/2022 |
11.12.2 | 42,514 | 12/17/2021 |
11.11.2 | 37,378 | 11/25/2021 |
11.10.5 | 149,732 | 10/28/2021 |
11.10.4 | 23,955 | 10/25/2021 |
11.9.3 | 57,815 | 9/16/2021 |
11.9.2 | 24,817 | 9/14/2021 |
11.8.0 | 36,899 | 8/6/2021 |
11.7.0 | 24,355 | 7/8/2021 |
11.6.1 | 22,779 | 6/10/2021 |
11.4.6 | 28,699 | 4/30/2021 |
11.4.0 | 34,072 | 4/7/2021 |
11.3.4 | 18,802 | 3/12/2021 |
11.2.6 | 29,765 | 2/23/2021 |
11.2.3 | 7,821 | 2/8/2021 |
11.1.0 | 18,350 | 1/22/2021 |
10.12.0 | 45,206 | 12/3/2020 |
10.11.7 | 11,933 | 11/18/2020 |
10.11.2 | 6,450 | 11/6/2020 |
10.10.6 | 29,500 | 10/15/2020 |
10.9.16 | 8,251 | 9/28/2020 |
10.9.0 | 22,739 | 9/2/2020 |
10.8.3 | 14,080 | 8/11/2020 |
10.7.2 | 46,043 | 7/8/2020 |
10.5.7 | 53,659 | 5/21/2020 |
10.4.9 | 19,968 | 4/23/2020 |
10.3.8 | 15,184 | 3/26/2020 |
10.3.0 | 61,896 | 3/2/2020 |
10.2.8 | 8,751 | 2/20/2020 |
10.1.8 | 30,487 | 1/21/2020 |
10.1.1 | 15,503 | 1/8/2020 |
9.12.20 | 23,848 | 12/19/2019 |
9.11.14 | 18,376 | 11/26/2019 |
9.11.2 | 17,745 | 11/8/2019 |
9.10.12 | 19,043 | 10/25/2019 |
9.10.4 | 10,205 | 10/11/2019 |
9.9.13 | 11,307 | 9/26/2019 |
9.9.5 | 12,088 | 9/12/2019 |
9.9.0 | 10,521 | 9/2/2019 |
9.8.11 | 7,673 | 8/23/2019 |
9.8.5 | 7,478 | 8/15/2019 |
9.7.0 | 18,232 | 7/11/2019 |
9.6.12 | 6,675 | 7/1/2019 |
9.6.7 | 5,770 | 6/19/2019 |
9.6.1 | 5,920 | 6/6/2019 |
9.5.11 | 5,704 | 5/23/2019 |
9.5.6 | 4,156 | 5/16/2019 |
9.5.4 | 6,053 | 5/13/2019 |
9.5.0 | 7,993 | 5/1/2019 |
9.4.6 | 26,190 | 4/15/2019 |
9.4.0 | 21,292 | 4/2/2019 |
9.3.10 | 16,321 | 3/21/2019 |
9.3.4 | 4,254 | 3/13/2019 |
9.2.11 | 22,390 | 2/27/2019 |
9.2.8 | 4,605 | 2/21/2019 |
9.1.22 | 21,622 | 2/1/2019 |
9.1.14 | 5,077 | 1/24/2019 |
9.1.0 | 11,560 | 1/10/2019 |
8.12.11 | 10,570 | 12/28/2018 |
8.12.3 | 7,904 | 12/11/2018 |
8.11.6 | 14,606 | 11/21/2018 |
8.11.2 | 4,815 | 11/13/2018 |
8.10.7 | 7,143 | 10/31/2018 |
8.10.2 | 9,507 | 10/12/2018 |
8.9.8 | 6,360 | 9/30/2018 |
8.9.3 | 5,433 | 9/18/2018 |
8.8.5 | 6,258 | 8/29/2018 |
8.8.1 | 38,917 | 8/8/2018 |
8.8.0 | 4,103 | 8/1/2018 |
8.7.2 | 4,991 | 7/12/2018 |
8.6.6 | 6,319 | 6/28/2018 |
8.6.1 | 10,270 | 6/21/2018 |
8.5.1 | 7,360 | 5/11/2018 |
8.0.0 | 7,576 | 2/8/2018 |
7.12.150 | 9,532 | 2/6/2018 |
7.12.144 | 18,080 | 1/12/2018 |
7.12.140 | 5,067 | 12/28/2017 |
7.12.130 | 4,268 | 12/14/2017 |
7.12.125 | 5,073 | 12/4/2017 |
7.12.109 | 4,840 | 11/7/2017 |
7.12.100 | 3,938 | 10/23/2017 |
7.12.90 | 7,266 | 9/28/2017 |
7.12.76 | 6,431 | 8/22/2017 |
7.12.69 | 4,683 | 8/11/2017 |
7.12.55 | 5,535 | 7/18/2017 |
7.12.43 | 3,258 | 7/3/2017 |
7.12.27 | 8,177 | 6/9/2017 |
7.12.19 | 5,640 | 5/26/2017 |
7.12.11 | 5,957 | 5/9/2017 |
7.12.7 | 3,700 | 5/4/2017 |
7.12.0 | 16,022 | 4/24/2017 |
7.11.59 | 13,449 | 2/28/2017 |
7.11.49 | 12,956 | 1/24/2017 |