Aspose.Cells 20.12.0

.NET Standard 2.0 .NET Framework 2.0
There is a newer version of this package available.
See the version list below for details.
Install-Package Aspose.Cells -Version 20.12.0
dotnet add package Aspose.Cells --version 20.12.0
<PackageReference Include="Aspose.Cells" Version="20.12.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Aspose.Cells --version 20.12.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Aspose.Cells, 20.12.0"
#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=20.12.0

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

.NET API for Excel File Formats

Version 20.12 Nuget

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.

Excel 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.

New Features & Enhancements Version 20.12

  • Supports Formula with the Sheet() function.
  • Reduced output size when converting to HTML.
  • Display additional columns when text is overlapping next cells.
  • Support for the h1 tag when setting Cell.HtmlString.
  • Improved performance when converting complex XLSM to HTML.

Please visit Aspose.Cells for .NET 20.12 Release Notes for the detailed notes.

Read & Write Spreadsheet Formats

Microsoft Excel: XLS, XLSX, XLSB, XLT, XLTX, XLTM, XLSM, XML OpenOffice: ODS Text: CSV, TSV Web: HTML, MHTML Numbers: Apple's iWork office suite Numbers app documents

Save Excel Files As

Fixed Layout: PDF, PDF/A, XPS Data Interchange: DIF Images: JPEG, PNG, BMP, SVG, TIFF, EMF, GIF

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.

Getting Started with Aspose.Cells for .NET

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#

You can execute 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");

Home | Product Page | Docs | Demos | API Reference | Examples | Blog | 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.
  • .NETFramework 2.0

    • No dependencies.
  • .NETFramework 3.5

    • No dependencies.
  • .NETFramework 4.0

    • No dependencies.
  • .NETStandard 2.0

  • MonoAndroid 4.4

    • No dependencies.
  • Xamarin.iOS 1.0

    • No dependencies.

NuGet packages (48)

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 (2)

Showing the top 2 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、前后端分离的开箱即用的企业级中后台权限管理系统
Version Downloads Last updated
22.8.0 2,125 8/4/2022
22.7.0 20,593 7/7/2022
22.6.1 33,866 6/13/2022
22.5.0 57,646 5/10/2022
22.4.0 79,929 4/12/2022
22.3.0 89,660 3/10/2022
22.2.0 85,603 2/11/2022
22.1.0 117,715 1/7/2022
21.12.0 57,108 12/8/2021
21.11.0 94,380 11/8/2021
21.10.0 61,106 10/14/2021
21.9.0 166,342 9/15/2021
21.8.0 98,310 8/12/2021
21.7.0 154,387 7/13/2021
21.6.0 111,062 6/16/2021
21.5.0 166,094 5/14/2021
21.4.0 121,083 4/14/2021
21.3.0 105,757 3/11/2021
21.2.0 213,467 2/5/2021
21.1.0 171,871 1/15/2021
20.12.0 98,430 12/17/2020
20.11.0 191,280 11/12/2020
20.10.0 120,070 10/16/2020
20.9.0 112,597 9/10/2020
20.8.0 133,955 8/13/2020
20.7.0 190,068 7/15/2020
20.6.0 292,360 6/12/2020
20.5.0 54,915 5/21/2020
20.4.0 200,585 4/16/2020
20.3.0 211,331 3/19/2020
20.2.0 95,394 2/20/2020
20.1.0 120,478 1/16/2020
19.12.0 149,304 12/17/2019
19.11.0 142,919 11/15/2019
19.10.0 136,513 10/18/2019
19.9.0 150,536 9/18/2019
19.8.0 150,600 8/20/2019
19.7.0 164,017 7/18/2019
19.6.0 73,302 6/20/2019
19.5.0 69,344 5/16/2019
19.4.0 179,799 4/17/2019
19.3.0 88,993 3/15/2019
19.2.0 111,245 2/18/2019
19.1.0 113,591 1/17/2019
18.12.0 203,454 12/19/2018
18.11.0 103,093 11/19/2018
18.10.0 106,700 10/18/2018
18.9.0 33,865 9/17/2018
18.8.0 82,858 8/15/2018
18.7.0 82,729 7/12/2018
18.6.0 131,367 6/19/2018
18.5.1 35,286 5/23/2018
18.5.0 12,990 5/17/2018
18.4.0 77,628 4/19/2018
18.3.0 75,668 3/16/2018
18.2.0 26,209 2/7/2018
18.1.0 114,753 1/18/2018
17.12.0 44,622 12/15/2017
17.11.1 15,311 11/20/2017
17.10.0 53,129 10/18/2017
17.9.0 30,773 9/19/2017
17.8.0 59,553 8/15/2017
17.7.0 70,460 7/18/2017
17.6.0 25,401 6/15/2017
17.5.0 23,195 5/16/2017
17.4.0 43,077 4/20/2017
17.3.0 36,088 3/16/2017
17.2.0 23,459 2/16/2017
17.1.0 36,035 1/12/2017
16.12.0 47,700 12/13/2016
16.11.0 44,942 11/11/2016
16.10.0 49,824 10/12/2016
9.0.0 43,795 9/13/2016
8.9.2 85,786 8/19/2016
8.9.1 2,177 8/12/2016
8.9.0 50,286 7/18/2016
8.8.3 26,232 6/28/2016
8.8.2 23,727 6/3/2016
8.8.1 4,240 5/23/2016
8.8.0 80,029 4/21/2016
8.7.2 40,797 3/25/2016
8.7.1 69,249 2/24/2016
8.7.0 18,550 1/26/2016
8.6.3 24,951 12/23/2015
8.6.2 34,485 11/20/2015
8.6.1 25,593 10/23/2015
8.6.0 30,697 9/21/2015
8.5.2 11,942 8/17/2015
8.5.1 33,267 7/16/2015
8.5.0 16,518 6/19/2015
8.4.2 31,515 5/19/2015
8.4.1 10,156 4/15/2015
8.4.0 32,017 3/12/2015
8.3.2.1 42,097 2/4/2015
8.3.2 11,681 1/23/2015
8.3.1 15,954 12/10/2014
8.3.0 5,109 11/14/2014
8.2.2 55,802 10/16/2014
8.2.1 48,267 9/17/2014
8.2.0 11,435 8/15/2014
8.1.2 6,712 7/23/2014
8.1.1 19,398 6/27/2014
8.1.0 13,123 6/6/2014
8.0.2 11,198 5/14/2014
8.0.1 8,424 4/21/2014
8.0.0 8,038 3/26/2014
7.7.2 119,873 2/17/2014
7.7.1 20,285 1/15/2014
7.7.0 12,018 12/16/2013
7.6.1 51,838 11/18/2013
7.6.0 27,758 10/17/2013
7.5.3 9,303 9/10/2013
7.5.2 8,395 8/14/2013
7.5.1 5,765 7/18/2013
7.5.0 16,044 6/10/2013
7.4.3 28,297 4/29/2013
7.4.2 7,348 4/1/2013
7.4.1 5,666 3/4/2013
7.4.0 7,717 1/28/2013
7.3.5 6,537 12/31/2012
7.3.4 9,236 11/30/2012
7.3.3 14,823 10/30/2012
7.3.2 36,731 9/28/2012
7.3.1 6,741 8/27/2012
7.3.0 6,822 7/17/2012
7.2.2 7,221 6/18/2012
7.2.1 4,588 5/21/2012
7.2.0 16,998 4/16/2012
7.1.2 4,138 3/19/2012
7.1.1.1 3,918 2/16/2012
7.1.1 2,813 2/14/2012
7.1.0 6,776 1/24/2012