Aspose.Cells 20.5.0

Aspose.Cells for .NET consists of API and GUI controls to create, process, manipulate and convert Microsoft Excel® spreadsheets without needing Office Automation.

Install-Package Aspose.Cells -Version 20.5.0
dotnet add package Aspose.Cells --version 20.5.0
<PackageReference Include="Aspose.Cells" Version="20.5.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Aspose.Cells --version 20.5.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

.NET API for Excel File Formats

Aspose.Cells for .NET is an Excel Spreadsheet Programming API to speed up spreadsheet management and processing tasks. Excel .NET API supports 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 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 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 in Version 20.5

  • Supports GridWeb on MVC.
  • Support for Aspose.Cells.GridWeb in ASP.NET Core.

Enhancements in Version 20.5

  • New Excel “Implicit Intersection Operators”@ symbol inserted.
  • Option to access active cell or selected cells from outside the GridWeb.

For the detailed notes, please visit Aspose.Cells for .NET 20.5 Release 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 passing 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 | Documentation | Demo | API Reference | Examples | Blog | Free Support | Temporary License

.NET API for Excel File Formats

Aspose.Cells for .NET is an Excel Spreadsheet Programming API to speed up spreadsheet management and processing tasks. Excel .NET API supports 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 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 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 in Version 20.5

  • Supports GridWeb on MVC.
  • Support for Aspose.Cells.GridWeb in ASP.NET Core.

Enhancements in Version 20.5

  • New Excel “Implicit Intersection Operators”@ symbol inserted.
  • Option to access active cell or selected cells from outside the GridWeb.

For the detailed notes, please visit Aspose.Cells for .NET 20.5 Release 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 passing 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 | Documentation | Demo | API Reference | Examples | Blog | Free Support | Temporary License

Release Notes

https://docs.aspose.com/display/cellsnet/Aspose.Cells+for+.NET+20.5+Release+Notes

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

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

Repository Stars
aspose-words/Aspose.Words-for-.NET
Aspose.Words for .NET examples, plugins and showcases

Read more about the GitHub Usage information on our documentation.

Version History

Version Downloads Last updated
20.5.0 459 5/21/2020
20.4.0 9,971 4/16/2020
20.3.0 18,233 3/19/2020
20.2.0 17,444 2/20/2020
20.1.0 29,920 1/16/2020
19.12.0 22,432 12/17/2019
19.11.0 49,347 11/15/2019
19.10.0 42,700 10/18/2019
19.9.0 50,049 9/18/2019
19.8.0 37,098 8/20/2019
19.7.0 74,495 7/18/2019
19.6.0 30,990 6/20/2019
19.5.0 30,148 5/16/2019
19.4.0 48,317 4/17/2019
19.3.0 31,165 3/15/2019
19.2.0 54,733 2/18/2019
19.1.0 52,820 1/17/2019
18.12.0 40,380 12/19/2018
18.11.0 29,687 11/19/2018
18.10.0 56,243 10/18/2018
18.9.0 20,967 9/17/2018
18.8.0 44,539 8/15/2018
18.7.0 34,914 7/12/2018
18.6.0 68,464 6/19/2018
18.5.1 22,506 5/23/2018
18.5.0 4,673 5/17/2018
18.4.0 35,268 4/19/2018
18.3.0 22,933 3/16/2018
18.2.0 13,380 2/7/2018
18.1.0 24,740 1/18/2018
17.12.0 26,251 12/15/2017
17.11.1 10,176 11/20/2017
17.10.0 30,290 10/18/2017
17.9.0 22,184 9/19/2017
17.8.0 27,240 8/15/2017
17.7.0 24,003 7/18/2017
17.6.0 14,850 6/15/2017
17.5.0 13,195 5/16/2017
17.4.0 20,217 4/20/2017
17.3.0 18,039 3/16/2017
17.2.0 11,746 2/16/2017
17.1.0 26,368 1/12/2017
16.12.0 26,472 12/13/2016
16.11.0 27,796 11/11/2016
16.10.0 29,213 10/12/2016
9.0.0 15,206 9/13/2016
8.9.2 38,283 8/19/2016
8.9.1 1,519 8/12/2016
8.9.0 34,293 7/18/2016
8.8.3 6,830 6/28/2016
8.8.2 16,125 6/3/2016
8.8.1 3,426 5/23/2016
8.8.0 49,997 4/21/2016
8.7.2 26,539 3/25/2016
8.7.1 35,838 2/24/2016
8.7.0 10,892 1/26/2016
8.6.3 16,621 12/23/2015
8.6.2 24,667 11/20/2015
8.6.1 16,999 10/23/2015
8.6.0 26,039 9/21/2015
8.5.2 6,857 8/17/2015
8.5.1 20,281 7/16/2015
8.5.0 6,589 6/19/2015
8.4.2 9,855 5/19/2015
8.4.1 6,063 4/15/2015
8.4.0 18,316 3/12/2015
8.3.2.1 16,386 2/4/2015
8.3.2 5,066 1/23/2015
8.3.1 9,794 12/10/2014
8.3.0 3,610 11/14/2014
8.2.2 15,245 10/16/2014
8.2.1 26,062 9/17/2014
8.2.0 9,406 8/15/2014
8.1.2 4,621 7/23/2014
8.1.1 9,640 6/27/2014
8.1.0 5,675 6/6/2014
8.0.2 7,446 5/14/2014
8.0.1 4,803 4/21/2014
8.0.0 4,571 3/26/2014
7.7.2 14,300 2/17/2014
7.7.1 17,648 1/15/2014
7.7.0 6,636 12/16/2013
7.6.1 37,570 11/18/2013
7.6.0 5,702 10/17/2013
7.5.3 4,879 9/10/2013
7.5.2 2,683 8/14/2013
7.5.1 3,734 7/18/2013
7.5.0 6,368 6/10/2013
7.4.3 14,740 4/29/2013
7.4.2 4,046 4/1/2013
7.4.1 4,075 3/4/2013
7.4.0 4,524 1/28/2013
7.3.5 2,282 12/31/2012
7.3.4 5,468 11/30/2012
7.3.3 2,325 10/30/2012
7.3.2 14,265 9/28/2012
7.3.1 3,818 8/27/2012
7.3.0 3,467 7/17/2012
7.2.2 1,912 6/18/2012
7.2.1 1,581 5/21/2012
7.2.0 6,471 4/16/2012
7.1.2 2,047 3/19/2012
7.1.1.1 3,223 2/16/2012
7.1.1 1,643 2/14/2012
7.1.0 3,548 1/24/2012