Aspose.Cells
21.2.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 21.2.0
dotnet add package Aspose.Cells --version 21.2.0
<PackageReference Include="Aspose.Cells" Version="21.2.0" />
paket add Aspose.Cells --version 21.2.0
#r "nuget: Aspose.Cells, 21.2.0"
.NET API for Excel File Formats
Home | Product Page | Docs | Demos | API Reference | Examples | Blog | 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.
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.
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 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");
Home | Product Page | Docs | Demos | API Reference | Examples | Blog | Free Support | Temporary License
.NET API for Excel File Formats
Home | Product Page | Docs | Demos | API Reference | Examples | Blog | 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.
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.
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 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");
Home | Product Page | Docs | Demos | API Reference | Examples | Blog | Free Support | Temporary License
Release Notes
https://docs.aspose.com/cells/net/aspose-cells-for-net-21-2-release-notes/
Dependencies
-
.NETFramework 2.0
- No dependencies.
-
.NETFramework 3.5
- No dependencies.
-
.NETFramework 4.0
- No dependencies.
-
.NETStandard 2.0
- System.Drawing.Common (>= 4.7.0)
- System.Text.Encoding.CodePages (>= 4.7.0)
-
MonoAndroid 4.4
- No dependencies.
-
net5.0
- System.Drawing.Common (>= 4.7.0)
- System.Text.Encoding.CodePages (>= 4.7.0)
-
Xamarin.iOS 1.0
- No dependencies.
Used By
NuGet packages (26)
Showing the top 5 NuGet packages that depend on Aspose.Cells:
Package | Downloads |
---|---|
Zny.Common.Document
文档操作库
|
|
OBeautifulCode.Excel.AsposeCells
Enables Excel automation using the Aspose.Cells library.
|
|
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.
|
|
Zny.ServiceClient.Common
微服务调用公共类
|
|
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
|
|
loamen/Kalman.Studio
Kalman.Studio代码生成器是一款基于T4模板引擎的代码生成器和开发辅助工具。可以根据数据库元数据架构信息来生成代码,还可以解析PowerDesigner物理模型文件,根据PDM模型对象来生成代码等。
|
|
aspose-cells/Aspose.Cells-for-.NET
Aspose.Cells for .NET examples, plugins and showcases
|
|
vanderkleij/Smocks
Smocks is a library for mocking the normally unmockable. It can mock static and non-virtual methods and properties, amongst others.
|
Version History
Version | Downloads | Last updated |
---|---|---|
21.2.0 | 4,876 | 2/5/2021 |
21.1.0 | 11,281 | 1/15/2021 |
20.12.0 | 20,078 | 12/17/2020 |
20.11.0 | 28,990 | 11/12/2020 |
20.10.0 | 32,445 | 10/16/2020 |
20.9.0 | 33,978 | 9/10/2020 |
20.8.0 | 39,203 | 8/13/2020 |
20.7.0 | 55,504 | 7/15/2020 |
20.6.0 | 137,350 | 6/12/2020 |
20.5.0 | 16,941 | 5/21/2020 |
20.4.0 | 77,842 | 4/16/2020 |
20.3.0 | 70,455 | 3/19/2020 |
20.2.0 | 43,442 | 2/20/2020 |
20.1.0 | 71,031 | 1/16/2020 |
19.12.0 | 63,051 | 12/17/2019 |
19.11.0 | 72,755 | 11/15/2019 |
19.10.0 | 76,933 | 10/18/2019 |
19.9.0 | 88,433 | 9/18/2019 |
19.8.0 | 69,292 | 8/20/2019 |
19.7.0 | 108,057 | 7/18/2019 |
19.6.0 | 46,988 | 6/20/2019 |
19.5.0 | 40,279 | 5/16/2019 |
19.4.0 | 98,034 | 4/17/2019 |
19.3.0 | 46,910 | 3/15/2019 |
19.2.0 | 88,557 | 2/18/2019 |
19.1.0 | 76,703 | 1/17/2019 |
18.12.0 | 72,763 | 12/19/2018 |
18.11.0 | 63,858 | 11/19/2018 |
18.10.0 | 77,376 | 10/18/2018 |
18.9.0 | 25,466 | 9/17/2018 |
18.8.0 | 58,998 | 8/15/2018 |
18.7.0 | 47,427 | 7/12/2018 |
18.6.0 | 100,345 | 6/19/2018 |
18.5.1 | 28,275 | 5/23/2018 |
18.5.0 | 7,020 | 5/17/2018 |
18.4.0 | 51,394 | 4/19/2018 |
18.3.0 | 38,589 | 3/16/2018 |
18.2.0 | 16,689 | 2/7/2018 |
18.1.0 | 47,605 | 1/18/2018 |
17.12.0 | 30,749 | 12/15/2017 |
17.11.1 | 11,743 | 11/20/2017 |
17.10.0 | 38,211 | 10/18/2017 |
17.9.0 | 24,583 | 9/19/2017 |
17.8.0 | 40,264 | 8/15/2017 |
17.7.0 | 35,458 | 7/18/2017 |
17.6.0 | 17,575 | 6/15/2017 |
17.5.0 | 15,084 | 5/16/2017 |
17.4.0 | 27,707 | 4/20/2017 |
17.3.0 | 22,640 | 3/16/2017 |
17.2.0 | 14,939 | 2/16/2017 |
17.1.0 | 29,995 | 1/12/2017 |
16.12.0 | 37,646 | 12/13/2016 |
16.11.0 | 33,361 | 11/11/2016 |
16.10.0 | 35,002 | 10/12/2016 |
9.0.0 | 20,695 | 9/13/2016 |
8.9.2 | 53,638 | 8/19/2016 |
8.9.1 | 1,754 | 8/12/2016 |
8.9.0 | 41,265 | 7/18/2016 |
8.8.3 | 12,992 | 6/28/2016 |
8.8.2 | 17,448 | 6/3/2016 |
8.8.1 | 3,730 | 5/23/2016 |
8.8.0 | 58,913 | 4/21/2016 |
8.7.2 | 33,149 | 3/25/2016 |
8.7.1 | 48,624 | 2/24/2016 |
8.7.0 | 14,107 | 1/26/2016 |
8.6.3 | 19,019 | 12/23/2015 |
8.6.2 | 27,449 | 11/20/2015 |
8.6.1 | 19,931 | 10/23/2015 |
8.6.0 | 27,472 | 9/21/2015 |
8.5.2 | 7,931 | 8/17/2015 |
8.5.1 | 23,957 | 7/16/2015 |
8.5.0 | 7,336 | 6/19/2015 |
8.4.2 | 18,313 | 5/19/2015 |
8.4.1 | 8,526 | 4/15/2015 |
8.4.0 | 23,548 | 3/12/2015 |
8.3.2.1 | 24,642 | 2/4/2015 |
8.3.2 | 7,101 | 1/23/2015 |
8.3.1 | 11,470 | 12/10/2014 |
8.3.0 | 4,002 | 11/14/2014 |
8.2.2 | 27,843 | 10/16/2014 |
8.2.1 | 36,629 | 9/17/2014 |
8.2.0 | 9,874 | 8/15/2014 |
8.1.2 | 5,348 | 7/23/2014 |
8.1.1 | 14,779 | 6/27/2014 |
8.1.0 | 7,857 | 6/6/2014 |
8.0.2 | 8,187 | 5/14/2014 |
8.0.1 | 6,105 | 4/21/2014 |
8.0.0 | 5,479 | 3/26/2014 |
7.7.2 | 51,528 | 2/17/2014 |
7.7.1 | 18,117 | 1/15/2014 |
7.7.0 | 8,048 | 12/16/2013 |
7.6.1 | 49,956 | 11/18/2013 |
7.6.0 | 13,876 | 10/17/2013 |
7.5.3 | 6,657 | 9/10/2013 |
7.5.2 | 4,089 | 8/14/2013 |
7.5.1 | 4,393 | 7/18/2013 |
7.5.0 | 8,703 | 6/10/2013 |
7.4.3 | 17,708 | 4/29/2013 |
7.4.2 | 5,022 | 4/1/2013 |
7.4.1 | 4,554 | 3/4/2013 |
7.4.0 | 5,275 | 1/28/2013 |
7.3.5 | 3,866 | 12/31/2012 |
7.3.4 | 6,084 | 11/30/2012 |
7.3.3 | 9,105 | 10/30/2012 |
7.3.2 | 22,299 | 9/28/2012 |
7.3.1 | 4,507 | 8/27/2012 |
7.3.0 | 4,472 | 7/17/2012 |
7.2.2 | 2,622 | 6/18/2012 |
7.2.1 | 2,232 | 5/21/2012 |
7.2.0 | 10,448 | 4/16/2012 |
7.1.2 | 2,859 | 3/19/2012 |
7.1.1.1 | 3,439 | 2/16/2012 |
7.1.1 | 1,988 | 2/14/2012 |
7.1.0 | 4,335 | 1/24/2012 |