Aspose.Cells 22.6.1

.NET 5.0 .NET Standard 2.0 .NET Framework 2.0
Install-Package Aspose.Cells -Version 22.6.1
dotnet add package Aspose.Cells --version 22.6.1
<PackageReference Include="Aspose.Cells" Version="22.6.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Aspose.Cells --version 22.6.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Aspose.Cells, 22.6.1"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install Aspose.Cells as a Cake Addin
#addin nuget:?package=Aspose.Cells&version=22.6.1

// Install Aspose.Cells as a Cake Tool
#tool nuget:?package=Aspose.Cells&version=22.6.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

.NET API for Excel® File Formats

Version 22.6.1 Nuget

banner

Product Page | Docs | Demos | API Reference | Examples | Blog | Search | Free Support | Temporary License

Aspose.Cells for .NET is an Excel® Spreadsheet Programming API to speed up spreadsheet management and processing tasks. Excel® .NET API support to build cross-platform applications having the ability to generate, modify, convert, render, and print spreadsheets. It allows developers to manage worksheets, rows, columns & cells, create spreadsheet contents and styles from scratch, import data onto the worksheets from different data sources, add common and complex mathematical, financial, and text formulas, create & manipulate pivot tables, charts, hyperlinks, comments, drawing objects and much more.

Aspose.Cells for .NET provides a Grid solution with two GUI-based .NET controls. Aspose.Cells.GridDesktop supports desktop applications and Aspose.Cells.GridWeb is specifically designed for .NET based web applications. Both Gird controls allow you to import/export Excel® files, manipulate data & formatting, customize grid design and layout, manage multiple worksheets, create and calculate Excel® formulas, and numerous other Excel®-like operations.

What is Aspose.Cells for .NET?

Aspose.Cells for .NET enables your .NET, C#, ASP.NET, and VB.NET applications to create, format, render, print and convert Microsoft Excel® and OpenDocument spreadsheets (XLS, XLSX, ODS, etc.) to various supported formats, without the need to install Microsoft Excel or any 3rd party software. Its powerful formula calculation engine supports various standard and advanced MS Excel® formulas/functions.

Aspose.Cells for .NET is written in managed C# and can be used in any kind of .NET-based Windows Desktop Application or ASP.NET Web Application. Our library can also be used with classic ASP, and PHP.

It’s rich object model consists of 100+ public classes that offer .NET developers to integrate exciting spreadsheet manipulation features into their applications, ranging from creating pivot charts, combinings spreadsheets, parsing data, to encrypting and exporting spreadsheet files. Render spreadsheet pages to raster (TIFF, multipage TIFF, PNG, JPEG, BMP) or vector (EMF) images. Aspose.Cells for .NET also supports working with XLSB, XLT, XLTX, XLTM, XLSM, XML, HTML, CSV, TSV, HTML/MHTML, etc. It is capable of converting spreadsheets to PDF and XPS formats while maintaining the highest visual fidelity. You can add standard and customized charts and dynamically set data in order to refresh the charts. The charts can also be converted to high-quality PDF and raster image formats.

Spreadsheet File Processing Features

  • Spreadsheet generation & manipulation via API.
  • High-quality file format conversion & rendering.
  • Print Microsoft Excel® files to physical or virtual printers.
  • Combine, modify, protect, or parse Excel® sheets.
  • Apply worksheet formatting.
  • Configure and apply page setup for the worksheets.
  • Create & customize Excel® charts, Pivot Tables, conditional formatting rules, slicers, tables & spark-lines.
  • Convert Excel® charts to images & PDF.
  • Convert Excel® files to various other formats.
  • Formula calculation engine that supports all basic and advanced Excel functions.

Supported Read & Write Formats

Microsoft Excel®: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM, CSV, TSV, TabDelimited, SpreadsheetML
OpenOffice: ODS, SXC, FODS
Text: TXT
Web: HTML, MHTML
iWork®: Numbers
Other: SXC, FODS

Save Excel® Files As

Microsoft Word®: DOCX
Microsoft PowerPoint®: PPTX
Microsoft Excel®: XLAM
Fixed Layout: PDF, XPS
Data Interchange: DIF
Vector Graphics: SVG
Image: TIFF,PNG, BMP, JPEG, GIF
Metafile: EMF
Markdown: MD

Platform Independence

Aspose.Cells for .NET can be used to build ASP.NET, Web Services, WinForms, or other .NET applications for framework 2.0 or later on 32-bit and 64-bit operating systems. It also provides dedicated assemblies for Xamarin.Android (for native Android apps), Xamarin.iOS (for native iOS apps), COM (for pre-.NET technologies), Mono, and Windows Azure.

Get Started

Are you ready to give Aspose.Cells for .NET a try? Simply execute Install-Package Aspose.Cells from Package Manager Console in Visual Studio to fetch the NuGet package. If you already have Aspose.Cells for .NET and want to upgrade the version, please execute Update-Package Aspose.Cells to get the latest version.

Create XLSX Excel® File from Scratch via C# Code

You can execute the below code snippet to see how Aspose.Cells API performs in your environment or check the GitHub Repository for other common usage scenarios.

// initiate an instance of Workbook
var book = new Aspose.Cells.Workbook();
// access first (default) worksheet
var sheet = book.Worksheets[0];
// access CellsCollection of first worksheet
var cells = sheet.Cells;
// write HelloWorld to cells A1
cells["A1"].Value = "Hello World";
// save spreadsheet to disc
book.Save("output.xlsx", SaveFormat.Xlsx);

Convert Excel® Files to PDF, XPS & HTML

Aspose.Cells for .NET is capable of converting spreadsheets to numerous other popular formats including PDF, XPS & HTML formats while maintaining the highest visual fidelity. The conversion process is simple, configurable, and reliable.

// load file to be converted
var workbook = new Aspose.Cells.Workbook(dir + "template.xlsx");
// save in different formats
workbook.Save(dir + "output.pdf", Aspose.Cells.SaveFormat.Pdf);
workbook.Save(dir + "output.xps", Aspose.Cells.SaveFormat.XPS);
workbook.Save(dir + "output.html", Aspose.Cells.SaveFormat.Html);

Encrypt Excel® File with C# Code

var workbook = new Aspose.Cells.Workbook(dir + "template.xls");

// specify XOR encryption type
workbook.SetEncryptionOptions(EncryptionType.XOR, 40);

// specify strong encryption type (RC4,Microsoft Strong Cryptographic Provider)
workbook.SetEncryptionOptions(EncryptionType.StrongCryptographicProvider, 128);

// protect the file
workbook.Settings.Password = "1234";

// save the file
workbook.Save(dir + "output.xls");

Use C# to Create an Excel® Line Chart

var workbook = new Aspose.Cells.Workbook();

// add a new worksheet to the Excel® object
int sheetIndex = workbook.Worksheets.Add();

// obtain the reference of the newly added worksheet by providing its sheet index
Worksheet worksheet = workbook.Worksheets[sheetIndex];

// add sample values to cells
worksheet.Cells["A1"].PutValue(50);
worksheet.Cells["A2"].PutValue(100);
worksheet.Cells["A3"].PutValue(150);
worksheet.Cells["B1"].PutValue(4);
worksheet.Cells["B2"].PutValue(20);
worksheet.Cells["B3"].PutValue(50);

// add a chart to the worksheet
int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Line, 5, 0, 15, 5);

// access the instance of the newly added chart
var chart = worksheet.Charts[chartIndex];

// add chart data source from "A1" to "B3"
chart.NSeries.Add("A1:B3", true);

// save the Excel® file
workbook.Save(dir + "output.xls");

Product Page | Docs | Demos | API Reference | Examples | Blog | Search | Free Support | Temporary License

Product Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows
.NET Core netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard2.0 netstandard2.1
.NET Framework net20 net35 net40 net40-client net403 net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48
MonoAndroid monoandroid monoandroid44
MonoMac monomac
MonoTouch monotouch
Tizen tizen40 tizen60
Xamarin.iOS xamarinios xamarinios10
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (46)

Showing the top 5 NuGet packages that depend on Aspose.Cells:

Package Downloads
Aspose.Total

Aspose.Total for .NET is the most complete package of all .NET file format APIs offered by Aspose. It empowers developers to create, edit, render, print and convert between a wide range of popular document formats within any .NET, C#, ASP.NET and VB.NET applications.

OBeautifulCode.Excel.AsposeCells

Enables Excel automation using the Aspose.Cells library.

MSFactory.ToolKits

Package Description

EzFrameworkCore

It is based on NETCORE. This is the basic class library of the framework, which mainly provides the basic functional support needed for running. At the same time, it also provides rich tools for web development.

Ser.Engine

Package Description

GitHub repositories (4)

Showing the top 4 popular GitHub repositories that depend on Aspose.Cells:

Repository Stars
aspose-words/Aspose.Words-for-.NET
Aspose.Words for .NET examples, plugins and showcases
xianhc/apevolo-api
.Net 6.0 、SqlSugar、Vue、RBAC、前后端分离的开箱即用的企业级中后台权限管理系统
loamen/Kalman.Studio
Kalman.Studio代码生成器是一款基于T4模板引擎的代码生成器和开发辅助工具。可以根据数据库元数据架构信息来生成代码,还可以解析PowerDesigner物理模型文件,根据PDM模型对象来生成代码等。
aspose-cells/Aspose.Cells-for-.NET
Aspose.Cells for .NET examples, plugins and showcases
Version Downloads Last updated
22.6.1 5,945 6/13/2022
22.5.0 33,567 5/10/2022
22.4.0 53,507 4/12/2022
22.3.0 64,829 3/10/2022
22.2.0 67,253 2/11/2022
22.1.0 96,795 1/7/2022
21.12.0 48,860 12/8/2021
21.11.0 80,908 11/8/2021
21.10.0 52,767 10/14/2021
21.9.0 150,686 9/15/2021
21.8.0 88,102 8/12/2021
21.7.0 138,639 7/13/2021
21.6.0 89,054 6/16/2021
21.5.0 152,531 5/14/2021
21.4.0 111,683 4/14/2021
21.3.0 99,202 3/11/2021
21.2.0 195,990 2/5/2021
21.1.0 156,784 1/15/2021
20.12.0 91,720 12/17/2020
20.11.0 184,264 11/12/2020
20.10.0 112,266 10/16/2020
20.9.0 106,495 9/10/2020
20.8.0 124,682 8/13/2020
20.7.0 175,595 7/15/2020
20.6.0 283,554 6/12/2020
20.5.0 50,850 5/21/2020
20.4.0 188,447 4/16/2020
20.3.0 201,602 3/19/2020
20.2.0 89,073 2/20/2020
20.1.0 114,957 1/16/2020
19.12.0 145,404 12/17/2019
19.11.0 137,960 11/15/2019
19.10.0 132,935 10/18/2019
19.9.0 145,506 9/18/2019
19.8.0 142,782 8/20/2019
19.7.0 159,025 7/18/2019
19.6.0 70,899 6/20/2019
19.5.0 65,915 5/16/2019
19.4.0 170,396 4/17/2019
19.3.0 84,781 3/15/2019
19.2.0 107,984 2/18/2019
19.1.0 111,072 1/17/2019
18.12.0 191,387 12/19/2018
18.11.0 99,888 11/19/2018
18.10.0 103,880 10/18/2018
18.9.0 32,818 9/17/2018
18.8.0 80,552 8/15/2018
18.7.0 80,064 7/12/2018
18.6.0 129,342 6/19/2018
18.5.1 34,641 5/23/2018
18.5.0 12,060 5/17/2018
18.4.0 74,709 4/19/2018
18.3.0 72,428 3/16/2018
18.2.0 24,923 2/7/2018
18.1.0 112,286 1/18/2018
17.12.0 42,650 12/15/2017
17.11.1 15,080 11/20/2017
17.10.0 52,448 10/18/2017
17.9.0 30,182 9/19/2017
17.8.0 58,232 8/15/2017
17.7.0 67,468 7/18/2017
17.6.0 24,346 6/15/2017
17.5.0 22,612 5/16/2017
17.4.0 41,590 4/20/2017
17.3.0 35,027 3/16/2017
17.2.0 22,706 2/16/2017
17.1.0 35,365 1/12/2017
16.12.0 46,970 12/13/2016
16.11.0 43,921 11/11/2016
16.10.0 48,228 10/12/2016
9.0.0 41,667 9/13/2016
8.9.2 83,693 8/19/2016
8.9.1 2,142 8/12/2016
8.9.0 49,495 7/18/2016
8.8.3 25,190 6/28/2016
8.8.2 23,390 6/3/2016
8.8.1 4,186 5/23/2016
8.8.0 78,355 4/21/2016
8.7.2 40,213 3/25/2016
8.7.1 67,664 2/24/2016
8.7.0 18,102 1/26/2016
8.6.3 24,444 12/23/2015
8.6.2 33,765 11/20/2015
8.6.1 25,030 10/23/2015
8.6.0 30,358 9/21/2015
8.5.2 11,694 8/17/2015
8.5.1 32,135 7/16/2015
8.5.0 13,824 6/19/2015
8.4.2 30,044 5/19/2015
8.4.1 10,016 4/15/2015
8.4.0 31,517 3/12/2015
8.3.2.1 40,373 2/4/2015
8.3.2 11,368 1/23/2015
8.3.1 15,322 12/10/2014
8.3.0 5,020 11/14/2014
8.2.2 51,421 10/16/2014
8.2.1 47,212 9/17/2014
8.2.0 11,204 8/15/2014
8.1.2 6,586 7/23/2014
8.1.1 19,016 6/27/2014
8.1.0 12,697 6/6/2014
8.0.2 10,935 5/14/2014
8.0.1 8,183 4/21/2014
8.0.0 7,747 3/26/2014
7.7.2 105,550 2/17/2014
7.7.1 20,189 1/15/2014
7.7.0 11,618 12/16/2013
7.6.1 51,777 11/18/2013
7.6.0 26,686 10/17/2013
7.5.3 9,132 9/10/2013
7.5.2 8,072 8/14/2013
7.5.1 5,706 7/18/2013
7.5.0 15,067 6/10/2013
7.4.3 27,725 4/29/2013
7.4.2 7,235 4/1/2013
7.4.1 5,541 3/4/2013
7.4.0 6,800 1/28/2013
7.3.5 6,300 12/31/2012
7.3.4 8,894 11/30/2012
7.3.3 14,790 10/30/2012
7.3.2 35,571 9/28/2012
7.3.1 6,481 8/27/2012
7.3.0 6,549 7/17/2012
7.2.2 6,741 6/18/2012
7.2.1 4,494 5/21/2012
7.2.0 16,588 4/16/2012
7.1.2 4,071 3/19/2012
7.1.1.1 3,886 2/16/2012
7.1.1 2,792 2/14/2012
7.1.0 6,367 1/24/2012