Syncfusion.XlsIO.NET
19.4.0.55
Prefix Reserved
See the version list below for details.
dotnet add package Syncfusion.XlsIO.NET --version 19.4.0.55
NuGet\Install-Package Syncfusion.XlsIO.NET -Version 19.4.0.55
<PackageReference Include="Syncfusion.XlsIO.NET" Version="19.4.0.55" />
paket add Syncfusion.XlsIO.NET --version 19.4.0.55
#r "nuget: Syncfusion.XlsIO.NET, 19.4.0.55"
// Install Syncfusion.XlsIO.NET as a Cake Addin #addin nuget:?package=Syncfusion.XlsIO.NET&version=19.4.0.55 // Install Syncfusion.XlsIO.NET as a Cake Tool #tool nuget:?package=Syncfusion.XlsIO.NET&version=19.4.0.55
Syncfusion Essential XlsIO is a high-performance and feature-rich .NET Excel library to work with Microsoft Excel documents. This Excel library allows you to create, read, and edit Microsoft Excel files in any .NET application. It offers APIs to support Microsoft Excel equivalent features along with conversion APIs to easily convert Excel files to PDF, images, and more.
Key features
- Easily import and export data from/to common business objects.
- Performs quick evaluation with 400+ functions.
- Imports data into a customized format using Template Markers.
- Create and edit all chart types including Excel 2016 charts.
- Cell data validations can be applied with operators, alert messages, custom formulas, and drop-down lists.
- Highlights important cells by conditional formats.
- Performs various cell-level operations like resizing, hide or unhide, insert or delete, group and ungroup, and so on.
- Supports various formatting like number formats, text alignments, font settings, border settings, color settings, rich-text, and so on.
- Supports applying built-in styles and custom styles to cells.
- Sorts data based on cell value, cell color, and font color.
- Filters data based on cell value, cell color, icons, and so on.
- Create and edit the auto shapes, comments, text boxes, combo boxes, check boxes, and option buttons.
- Enables page settings like orientation, paper size, scaling, margins, print titles, header and footer, and so on.
Getting Started
Installation commands
- Simply run Install-Package Syncfusion.XlsIO.Net.Core from the Package Manager Console in Visual Studio to fetch the NuGet package.
- If you already have Syncfusion.XlsIO.Net.Core for .NET and want to upgrade the version, please run Update-Package Syncfusion.XlsIO.Net.Core to get the latest version.
- You can run the following snippets in your environment to see how Syncfusion.XlsIO.Net.Core works.
Create an Excel document using XlsIO
The following code snippet explains how to create an Excel document.
//Initialize ExcelEngine.
using (ExcelEngine excelEngine = new ExcelEngine())
{
//Initialize IApplication.
IApplication application = excelEngine.Excel;
//Set the default version as Xlsx.
application.DefaultVersion = ExcelVersion.Xlsx;
//Create a new workbook with one worksheet.
IWorkbook workbook = application.Workbooks.Create(1);
//Get the worksheet into IWorksheet.
IWorksheet worksheet = workbook.Worksheets[0];
//Set a value to Excel cell.
worksheet.Range["A1"].Value = "Hello World";
//Save the Excel document.
FileStream stream = new FileStream("Output.xlsx", FileMode.Create, FileAccess.ReadWrite);
workbook.SaveAs(stream);
stream.Dispose();
}
Read an Excel document using XlsIO
The following code snippet explains how to read an Excel document.
//Initialize ExcelEngine.
using (ExcelEngine excelEngine = new ExcelEngine())
{
//Initialize IApplication.
IApplication application = excelEngine.Excel;
//Set the default version as Xlsx.
application.DefaultVersion = ExcelVersion.Xlsx;
//Load an existing workbook into IWorkbook.
FileStream fileStream = new FileStream("Sample.xlsx", FileMode.Open, FileAccess.Read);
IWorkbook workbook = application.Workbooks.Open(fileStream);
//Save the Excel document.
FileStream stream = new FileStream("Output.xlsx", FileMode.Create, FileAccess.ReadWrite);
workbook.SaveAs(stream);
stream.Dispose();
}
File Formats supported by XlsIO
Syncfusion Essential XlsIO supports .xls, .xlsx, .xlsm, .xltm, .xltx, .xml, .csv, .txt and .ods file formats.
Compatible Microsoft Excel Versions
- Microsoft Excel 97-2003
- Microsoft Excel 2007
- Microsoft Excel 2010
- Microsoft Excel 2013
- Microsoft Excel 2016
- Microsoft Excel 2019
Resources
- Product page: Syncfusion Excel Framework
- Documentation: Syncfusion Excel library
- Online demo: Syncfusion Excel library - Online demos
- Blogs: Syncfusion Excel library - Blogs
- Knowledge Base: Syncfusion Excel library - Knowledge Base
- Ebooks: Syncfusion Excel library - Ebooks
- FAQ: Syncfusion Excel library - FAQ
Support and feedback
- For any other queries, reach our Syncfusion support team or post the queries through the community forums.
- Request new feature through Syncfusion feedback portal.
License
This is a commercial product and requires a paid license for possession or use. Syncfusion�s licensed software, including this component, is subject to the terms and conditions of Syncfusion's EULA. You can purchase a licnense here or start a free 30-day trial here.
About Syncfusion
Founded in 2001 and headquartered in Research Triangle Park, N.C., Syncfusion has more than 26,000+ customers and more than 1 million users, including large financial institutions, Fortune 500 companies, and global IT consultancies.
Today, we provide 1600+ components and frameworks for web (Blazor, ASP.NET Core, ASP.NET MVC, ASP.NET WebForms, JavaScript, Angular, React, Vue, and Flutter), mobile (Xamarin, Flutter, UWP, and JavaScript), and desktop development (WinForms, WPF, WinUI, Flutter and UWP). We provide ready-to-deploy enterprise software for dashboards, reports, data integration, and big data processing. Many customers have saved millions in licensing fees by deploying our software.
This is a commercial product and requires a paid license for possession or use. Syncfusion�s licensed software, including this component, is subject to the terms and conditions of Syncfusion's EULA. To acquire a license, you can purchase one here or start a free 30-day trial here.
sales@syncfusion.com | www.syncfusion.com | Toll Free: 1-888-9 DOTNET
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. 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 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | 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 was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- NETStandard.Library (>= 2.0.0)
- Syncfusion.Compression.NET (>= 19.4.0.55)
- Syncfusion.Licensing (>= 19.4.0.55)
NuGet packages (4)
Showing the top 4 NuGet packages that depend on Syncfusion.XlsIO.NET:
Package | Downloads |
---|---|
Syncfusion.XlsIORenderer.NET
The Syncfusion XlsIO renderer is a .NET Standard library that allows you to convert Excel documents to Images/PDFs in .NET applications without any Microsoft Office dependencies. |
|
Syncfusion.Maui.DataGridExport
Syncfusion DataGridExport is a .Net library for exporting the SfDataGrid to excel and pdf formats. |
|
Syncfusion.GridExport.WinUI
This package provides the functionality to utilize the features of Syncfusion WinUI GridExport control and more. |
|
DPMDEV.RFSLib
Library of functions relating to internal project |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
27.1.58 | 0 | 11/4/2024 |
27.1.57 | 367 | 10/28/2024 |
27.1.56 | 799 | 10/23/2024 |
27.1.55 | 489 | 10/21/2024 |
27.1.53 | 703 | 10/14/2024 |
27.1.52 | 577 | 10/7/2024 |
27.1.51 | 805 | 9/30/2024 |
27.1.50 | 766 | 9/24/2024 |
27.1.48 | 576 | 9/18/2024 |
26.2.14 | 1,422 | 9/9/2024 |
26.2.13 | 1,089 | 9/5/2024 |
26.2.12 | 726 | 9/2/2024 |
26.2.11 | 1,273 | 8/27/2024 |
26.2.10 | 833 | 8/19/2024 |
26.2.9 | 1,162 | 8/12/2024 |
26.2.8 | 3,207 | 8/5/2024 |
26.2.7 | 439 | 7/29/2024 |
26.2.5 | 1,245 | 7/26/2024 |
26.2.4 | 660 | 7/24/2024 |
26.1.42 | 973 | 7/15/2024 |
26.1.41 | 733 | 7/8/2024 |
26.1.40 | 13,665 | 7/1/2024 |
26.1.39 | 835 | 6/24/2024 |
26.1.38 | 830 | 6/18/2024 |
26.1.35 | 3,608 | 6/11/2024 |
25.2.7 | 580 | 6/3/2024 |
25.2.6 | 897 | 5/28/2024 |
25.2.5 | 776 | 5/21/2024 |
25.2.4 | 1,531 | 5/14/2024 |
25.2.3 | 1,368 | 5/8/2024 |
25.1.42 | 2,390 | 4/29/2024 |
25.1.41 | 1,030 | 4/23/2024 |
25.1.40 | 666 | 4/15/2024 |
25.1.39 | 714 | 4/8/2024 |
25.1.38 | 1,639 | 4/1/2024 |
25.1.37 | 721 | 3/26/2024 |
25.1.35 | 13,974 | 3/15/2024 |
24.2.9 | 1,678 | 3/4/2024 |
24.2.8 | 1,516 | 2/26/2024 |
24.2.7 | 2,175 | 2/19/2024 |
24.2.6 | 671 | 2/14/2024 |
24.2.5 | 842 | 2/12/2024 |
24.2.4 | 640 | 2/6/2024 |
24.2.3 | 6,255 | 1/31/2024 |
24.1.47 | 826 | 1/22/2024 |
24.1.46 | 3,105 | 1/16/2024 |
24.1.45 | 1,857 | 1/9/2024 |
24.1.44 | 927 | 1/3/2024 |
24.1.43 | 734 | 12/27/2023 |
24.1.41 | 3,888 | 12/18/2023 |
23.2.7 | 2,886 | 12/6/2023 |
23.2.6 | 943 | 11/28/2023 |
23.2.5 | 846 | 11/23/2023 |
23.2.4 | 3,397 | 11/20/2023 |
23.1.44 | 2,511 | 11/6/2023 |
23.1.43 | 1,236 | 10/30/2023 |
23.1.42 | 6,857 | 10/23/2023 |
23.1.41 | 985 | 10/16/2023 |
23.1.40 | 1,675 | 10/10/2023 |
23.1.39 | 943 | 10/4/2023 |
23.1.38 | 1,281 | 9/26/2023 |
23.1.36 | 10,873 | 9/15/2023 |
22.2.12 | 1,416 | 9/5/2023 |
22.2.11 | 3,072 | 8/28/2023 |
22.2.10 | 1,225 | 8/22/2023 |
22.2.9 | 1,214 | 8/14/2023 |
22.2.8 | 1,926 | 8/7/2023 |
22.2.7 | 4,843 | 8/2/2023 |
22.2.5 | 3,515 | 7/27/2023 |
22.1.39 | 1,772 | 7/18/2023 |
22.1.38 | 1,308 | 7/11/2023 |
22.1.37 | 1,426 | 7/3/2023 |
22.1.36 | 2,024 | 6/28/2023 |
22.1.34 | 3,436 | 6/21/2023 |
21.2.10 | 1,277 | 6/13/2023 |
21.2.9 | 1,115 | 6/6/2023 |
21.2.8 | 1,512 | 5/30/2023 |
21.2.6 | 2,672 | 5/22/2023 |
21.2.5 | 2,147 | 5/15/2023 |
21.2.4 | 1,358 | 5/9/2023 |
21.2.3 | 5,209 | 5/3/2023 |
21.1.41 | 1,435 | 4/19/2023 |
21.1.39 | 1,460 | 4/10/2023 |
21.1.38 | 1,411 | 4/3/2023 |
21.1.37 | 3,052 | 3/29/2023 |
21.1.35 | 1,797 | 3/23/2023 |
20.4.0.54 | 1,651 | 3/13/2023 |
20.4.0.53 | 1,319 | 3/7/2023 |
20.4.0.52 | 1,416 | 2/28/2023 |
20.4.0.51 | 1,696 | 2/21/2023 |
20.4.0.50 | 1,362 | 2/14/2023 |
20.4.0.49 | 1,295 | 2/7/2023 |
20.4.0.48 | 4,336 | 2/1/2023 |
20.4.0.44 | 1,864 | 1/18/2023 |
20.4.0.43 | 1,509 | 1/10/2023 |
20.4.0.42 | 1,521 | 1/4/2023 |
20.4.0.41 | 1,606 | 12/29/2022 |
20.4.0.40 | 1,391 | 12/28/2022 |
20.4.0.38 | 1,681 | 12/21/2022 |
20.3.0.61 | 1,936 | 12/13/2022 |
20.3.0.60 | 1,575 | 12/6/2022 |
20.3.0.59 | 1,705 | 11/29/2022 |
20.3.0.58 | 2,633 | 11/22/2022 |
20.3.0.57 | 1,698 | 11/15/2022 |
20.3.0.56 | 1,662 | 11/8/2022 |
20.3.0.52 | 1,636 | 10/27/2022 |
20.3.0.50 | 2,391 | 10/18/2022 |
20.3.0.49 | 1,440 | 10/11/2022 |
20.3.0.48 | 1,319 | 10/5/2022 |
20.3.0.47 | 4,900 | 9/29/2022 |
20.2.0.50 | 1,272 | 9/20/2022 |
20.2.0.49 | 1,185 | 9/13/2022 |
20.2.0.48 | 1,189 | 9/6/2022 |
20.2.0.46 | 1,116 | 8/30/2022 |
20.2.0.45 | 1,106 | 8/23/2022 |
20.2.0.44 | 1,127 | 8/16/2022 |
20.2.0.43 | 2,217 | 8/8/2022 |
20.2.0.40 | 1,260 | 7/26/2022 |
20.2.0.39 | 1,208 | 7/19/2022 |
20.2.0.38 | 2,235 | 7/12/2022 |
20.2.0.36 | 12,608 | 6/30/2022 |
20.1.0.61 | 1,190 | 6/21/2022 |
20.1.0.60 | 1,143 | 6/14/2022 |
20.1.0.59 | 2,785 | 6/7/2022 |
20.1.0.58 | 1,413 | 5/31/2022 |
20.1.0.57 | 1,122 | 5/24/2022 |
20.1.0.56 | 1,145 | 5/17/2022 |
20.1.0.55 | 1,733 | 5/12/2022 |
20.1.0.52 | 1,937 | 5/3/2022 |
20.1.0.51 | 1,135 | 4/26/2022 |
20.1.0.50 | 1,208 | 4/19/2022 |
20.1.0.48 | 1,120 | 4/12/2022 |
20.1.0.47 | 1,375 | 4/4/2022 |
19.4.0.56 | 1,358 | 3/15/2022 |
19.4.0.55 | 1,177 | 3/8/2022 |
19.4.0.54 | 1,136 | 3/1/2022 |
19.4.0.53 | 1,478 | 2/22/2022 |
19.4.0.52 | 1,262 | 2/15/2022 |
19.4.0.50 | 1,406 | 2/8/2022 |
19.4.0.48 | 1,192 | 1/31/2022 |
19.4.0.47 | 1,133 | 1/25/2022 |
19.4.0.43 | 1,454 | 1/18/2022 |
19.4.0.42 | 1,156 | 1/11/2022 |
19.4.0.41 | 935 | 1/4/2022 |
19.4.0.38 | 1,951 | 12/17/2021 |