Aspose.Cells 20.1.0

Aspose.Cells for .NET is a spreadsheet programming library that allows software developers to manipulate and convert spreadsheet files from within their own applications. A combination of APIs and GUI controls, Aspose.Cells for .NET speeds up Microsoft Excel programming and conversion. Aspose.Cells for .NET supports the popular spreadsheet (XLS, XLSX, XLSM, XLSB, XLTX, XLTM, CSV, TSV, SpreadsheetML, ODS) file formats your business use every day. It also allows exporting Excel files to PDF, XPS, HTML, MHTML, Plain Text and popular image formats including TIFF, JPG, PNG, BMP and SVG.

Aspose.Cells for .NET is well documented to help you create your solutions on different platforms.

Advanced Excel Spreadsheet Features

Aspose.Cells for .NET not only supports spreadsheet generation and other basic file formatting features, it also supports a number of advanced features:
- File Formats and Conversions: High quality conversions to and from XLS, XLSX, SpreadsheetML, CSV, HTML, TXT, Tab delimited and OpenDocument Spreadsheet formats.
- Rendering and Printing: Convert whole workbook or pages in the worksheets to PDF, XPS. Also convert document pages to TIFF, PNG, JPEG, BMP or EMF images. All with high fidelity - exactly like Microsoft Excel®.
- Spreadsheet Features: A rich object model which allows you to programmatically generate, combine, modify, format, protect, parse or otherwise examine loaded spreadsheets.
- PageSetup Features: Implement PageSetup options for your worksheets with ease.
- Extended Excel Graphics Capabilities: Create and manipulate charts, add customized charts using the product API and dynamically set data for charts. It also supports to convert charts to images.

Platform Independence

You can use Aspose.Cells for .NET to build any type of a 32-bit or 64-bit .NET application including ASP.NET, WCF, WinForms, UWP, .NET Standard, .NET Core etc. It is possible to use Aspose.Cells for .NET via COM Interop from ASP, Perl, PHP and Python. You can also use Aspose.Cells for .NET to build applications with Mono.

Performance and Scalability

Aspose.Cells is a single .NET assembly that can be deployed with any .NET application by simply copying it. You do not have to worry about any other services or modules. You can generate thousands of spreadsheets in quick time that involves opening a workbook, modifying content and formatting or populating it with data and saving it.

Microsoft Office Automation – Not Needed

Aspose.Cells for .NET APIs are built using managed code that do never need Microsoft Office or Microsoft Excel to be installed on the machine to work with Excel document formats. It is a perfect Microsoft Office automation alternative in terms of supported features, security, stability, scalability, speed and price.

Aspose.Cells Grid Suite

Aspose.Cells for .NET also provides independent .NET GUI controls for desktop and web applications:
- Desktop Control for Windows Forms Applications
- Web Control for ASP.NET Web Forms Applications
(Apply formatting and formulae, import and export (DataTable, DataView), open, save and edit MS Excel files using the controls)

Free support for Aspose.Cells for .NET is provided on our support forum:
https://forum.aspose.com/
and on StackOverflow:
https://stackoverflow.com/questions/tagged/aspose

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

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

Some of the basic tasks developers can perform after integrating the API are management of worksheets, rows, columns & cells, creating spreadsheet contents and styles from scratch, importing data onto the worksheets from different data sources, adding common and complex mathematical, financial and text formulas, manipulation of charts, pictures, comments, drawing objects and much more.

Aspose.Cells for .NET provides a Grid solution with two GUI based .NET controls. One for the desktop applications and the other for .NET based web applications. You can 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 while using these controls.

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 & refresh charts, Pivot Tables, conditional formatting rules & spark-lines.
  • Convert spreadsheet charts to images & PDF.
  • Convert Excel files to various other formats.
  • Formula calculation engine that supports all basic and advanced Excel functions.

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 a New Excel File 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);

Product Page | Documentation | API Reference | Code Examples | Blog | Free Support | Temporary License

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

Some of the basic tasks developers can perform after integrating the API are management of worksheets, rows, columns & cells, creating spreadsheet contents and styles from scratch, importing data onto the worksheets from different data sources, adding common and complex mathematical, financial and text formulas, manipulation of charts, pictures, comments, drawing objects and much more.

Aspose.Cells for .NET provides a Grid solution with two GUI based .NET controls. One for the desktop applications and the other for .NET based web applications. You can 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 while using these controls.

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 & refresh charts, Pivot Tables, conditional formatting rules & spark-lines.
  • Convert spreadsheet charts to images & PDF.
  • Convert Excel files to various other formats.
  • Formula calculation engine that supports all basic and advanced Excel functions.

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 a New Excel File 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);

Product Page | Documentation | API Reference | Code Examples | Blog | Free Support | Temporary License

Release Notes

https://docs.aspose.com/display/cellsnet/Aspose.Cells+for+.NET+20.1+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 2 GitHub repositories that depend on Aspose.Cells:

Repository Stars
loamen/Kalman.Studio
Kalman.Studio代码生成器是一款基于T4模板引擎的代码生成器和开发辅助工具。可以根据数据库元数据架构信息来生成代码,还可以解析PowerDesigner物理模型文件,根据PDM模型对象来生成代码等。
aspose-cells/Aspose.Cells-for-.NET
Aspose.Cells for .NET examples, plugins and showcases

Read more about the GitHub Usage information on our documentation.

Version History

Version Downloads Last updated
20.1.0 5,943 1/16/2020
19.12.0 8,835 12/17/2019
19.11.0 26,014 11/15/2019
19.10.0 24,691 10/18/2019
19.9.0 32,748 9/18/2019
19.8.0 21,007 8/20/2019
19.7.0 52,657 7/18/2019
19.6.0 25,014 6/20/2019
19.5.0 26,360 5/16/2019
19.4.0 34,087 4/17/2019
19.3.0 25,227 3/15/2019
19.2.0 38,858 2/18/2019
19.1.0 43,697 1/17/2019
18.12.0 31,971 12/19/2018
18.11.0 23,033 11/19/2018
18.10.0 47,222 10/18/2018
18.9.0 18,292 9/17/2018
18.8.0 36,506 8/15/2018
18.7.0 31,445 7/12/2018
18.6.0 39,530 6/19/2018
18.5.1 18,403 5/23/2018
18.5.0 3,458 5/17/2018
18.4.0 31,289 4/19/2018
18.3.0 19,724 3/16/2018
18.2.0 12,951 2/7/2018
18.1.0 14,382 1/18/2018
17.12.0 24,400 12/15/2017
17.11.1 9,472 11/20/2017
17.10.0 28,039 10/18/2017
17.9.0 20,820 9/19/2017
17.8.0 24,950 8/15/2017
17.7.0 21,762 7/18/2017
17.6.0 13,966 6/15/2017
17.5.0 12,135 5/16/2017
17.4.0 17,354 4/20/2017
17.3.0 16,400 3/16/2017
17.2.0 10,613 2/16/2017
17.1.0 23,553 1/12/2017
16.12.0 21,934 12/13/2016
16.11.0 24,213 11/11/2016
16.10.0 26,430 10/12/2016
9.0.0 14,234 9/13/2016
8.9.2 33,965 8/19/2016
8.9.1 1,465 8/12/2016
8.9.0 31,896 7/18/2016
8.8.3 6,488 6/28/2016
8.8.2 15,445 6/3/2016
8.8.1 3,346 5/23/2016
8.8.0 44,680 4/21/2016
8.7.2 23,648 3/25/2016
8.7.1 32,607 2/24/2016
8.7.0 9,963 1/26/2016
8.6.3 15,639 12/23/2015
8.6.2 23,511 11/20/2015
8.6.1 16,042 10/23/2015
8.6.0 24,943 9/21/2015
8.5.2 6,524 8/17/2015
8.5.1 18,012 7/16/2015
8.5.0 6,281 6/19/2015
8.4.2 8,686 5/19/2015
8.4.1 3,861 4/15/2015
8.4.0 16,206 3/12/2015
8.3.2.1 13,151 2/4/2015
8.3.2 4,247 1/23/2015
8.3.1 9,263 12/10/2014
8.3.0 3,439 11/14/2014
8.2.2 17,575 10/16/2014
8.2.1 21,872 9/17/2014
8.2.0 9,270 8/15/2014
8.1.2 4,285 7/23/2014
8.1.1 7,031 6/27/2014
8.1.0 5,198 6/6/2014
8.0.2 7,028 5/14/2014
8.0.1 4,286 4/21/2014
8.0.0 8,739 3/26/2014
7.7.2 10,594 2/17/2014
7.7.1 17,509 1/15/2014
7.7.0 5,866 12/16/2013
7.6.1 33,759 11/18/2013
7.6.0 4,250 10/17/2013
7.5.3 4,436 9/10/2013
7.5.2 2,306 8/14/2013
7.5.1 3,234 7/18/2013
7.5.0 5,336 6/10/2013
7.4.3 13,888 4/29/2013
7.4.2 3,463 4/1/2013
7.4.1 3,973 3/4/2013
7.4.0 4,198 1/28/2013
7.3.5 1,972 12/31/2012
7.3.4 5,315 11/30/2012
7.3.3 2,180 10/30/2012
7.3.2 11,815 9/28/2012
7.3.1 3,619 8/27/2012
7.3.0 3,388 7/17/2012
7.2.2 1,797 6/18/2012
7.2.1 1,492 5/21/2012
7.2.0 5,354 4/16/2012
7.1.2 1,848 3/19/2012
7.1.1.1 3,163 2/16/2012
7.1.1 1,504 2/14/2012
7.1.0 3,232 1/24/2012