Aspose.Cells
20.10.0
See the version list below for details.
dotnet add package Aspose.Cells --version 20.10.0
NuGet\Install-Package Aspose.Cells -Version 20.10.0
<PackageReference Include="Aspose.Cells" Version="20.10.0" />
paket add Aspose.Cells --version 20.10.0
#r "nuget: Aspose.Cells, 20.10.0"
// Install Aspose.Cells as a Cake Addin
#addin nuget:?package=Aspose.Cells&version=20.10.0
// Install Aspose.Cells as a Cake Tool
#tool nuget:?package=Aspose.Cells&version=20.10.0
.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 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 
- Ability to verify the password for encrypted files.
- Render extra row and column in
HTML
without disturbing formulas/references to resemble the output with MS Excel.
Please visit Aspose.Cells for .NET 20.10 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 net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.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 net481 |
MonoAndroid | monoandroid monoandroid44 |
MonoMac | monomac |
MonoTouch | monotouch |
Tizen | tizen40 tizen60 |
Xamarin.iOS | xamarinios xamarinios10 |
Xamarin.Mac | xamarinmac |
Xamarin.TVOS | xamarintvos |
Xamarin.WatchOS | xamarinwatchos |
-
.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.
-
Xamarin.iOS 1.0
- No dependencies.
NuGet packages (51)
Showing the top 5 NuGet packages that depend on Aspose.Cells:
Package | Downloads |
---|---|
TrueSight
Package Description |
|
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. |
|
fion.modelerp.core
ModelErp |
|
OBeautifulCode.Excel.AsposeCells
Enables Excel automation using the Aspose.Cells library. |
|
MSFactory.ToolKits
Package Description |
GitHub repositories (6)
Showing the top 5 popular GitHub repositories that depend on Aspose.Cells:
Repository | Stars |
---|---|
xianhc/apevolo-api
.Net 6.0 、SqlSugar、Vue、RBAC、前后端分离的开箱即用的企业级中后台权限管理系统
|
|
aspose-words/Aspose.Words-for-.NET
Aspose.Words for .NET examples, plugins and showcases
|
|
axzxs2001/Asp.NetCoreExperiment
原来所有项目都移动到**OleVersion**目录下进行保留。新的案例装以.net 5.0为主,一部分对以前案例进行升级,一部分将以前的工作经验总结出来,以供大家参考!
|
|
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 |
---|---|---|
23.1.1 | 6,690 | 1/17/2023 |
23.1.0 | 4,303 | 1/10/2023 |
22.12.0 | 22,056 | 12/9/2022 |
22.11.0 | 45,451 | 11/10/2022 |
22.10.1 | 48,925 | 10/20/2022 |
22.10.0 | 15,951 | 10/11/2022 |
22.9.0 | 113,566 | 9/8/2022 |
22.8.0 | 79,958 | 8/4/2022 |
22.7.0 | 79,970 | 7/7/2022 |
22.6.1 | 98,668 | 6/13/2022 |
22.5.0 | 116,984 | 5/10/2022 |
22.4.0 | 141,079 | 4/12/2022 |
22.3.0 | 171,256 | 3/10/2022 |
22.2.0 | 131,983 | 2/11/2022 |
22.1.0 | 189,187 | 1/7/2022 |
21.12.0 | 83,298 | 12/8/2021 |
21.11.0 | 148,655 | 11/8/2021 |
21.10.0 | 93,352 | 10/14/2021 |
21.9.0 | 210,325 | 9/15/2021 |
21.8.0 | 125,934 | 8/12/2021 |
21.7.0 | 193,194 | 7/13/2021 |
21.6.0 | 210,505 | 6/16/2021 |
21.5.0 | 208,019 | 5/14/2021 |
21.4.0 | 148,992 | 4/14/2021 |
21.3.0 | 131,388 | 3/11/2021 |
21.2.0 | 280,392 | 2/5/2021 |
21.1.0 | 235,129 | 1/15/2021 |
20.12.0 | 126,310 | 12/17/2020 |
20.11.0 | 218,128 | 11/12/2020 |
20.10.0 | 147,933 | 10/16/2020 |
20.9.0 | 130,446 | 9/10/2020 |
20.8.0 | 172,384 | 8/13/2020 |
20.7.0 | 237,968 | 7/15/2020 |
20.6.0 | 316,841 | 6/12/2020 |
20.5.0 | 100,697 | 5/21/2020 |
20.4.0 | 233,595 | 4/16/2020 |
20.3.0 | 234,934 | 3/19/2020 |
20.2.0 | 113,462 | 2/20/2020 |
20.1.0 | 135,509 | 1/16/2020 |
19.12.0 | 159,736 | 12/17/2019 |
19.11.0 | 158,824 | 11/15/2019 |
19.10.0 | 147,846 | 10/18/2019 |
19.9.0 | 169,489 | 9/18/2019 |
19.8.0 | 170,338 | 8/20/2019 |
19.7.0 | 179,091 | 7/18/2019 |
19.6.0 | 81,344 | 6/20/2019 |
19.5.0 | 81,241 | 5/16/2019 |
19.4.0 | 210,550 | 4/17/2019 |
19.3.0 | 104,565 | 3/15/2019 |
19.2.0 | 123,183 | 2/18/2019 |
19.1.0 | 122,968 | 1/17/2019 |
18.12.0 | 247,945 | 12/19/2018 |
18.11.0 | 111,280 | 11/19/2018 |
18.10.0 | 113,596 | 10/18/2018 |
18.9.0 | 36,845 | 9/17/2018 |
18.8.0 | 91,931 | 8/15/2018 |
18.7.0 | 92,001 | 7/12/2018 |
18.6.0 | 138,347 | 6/19/2018 |
18.5.1 | 37,406 | 5/23/2018 |
18.5.0 | 18,348 | 5/17/2018 |
18.4.0 | 85,311 | 4/19/2018 |
18.3.0 | 88,017 | 3/16/2018 |
18.2.0 | 31,495 | 2/7/2018 |
18.1.0 | 124,837 | 1/18/2018 |
17.12.0 | 50,985 | 12/15/2017 |
17.11.1 | 16,408 | 11/20/2017 |
17.10.0 | 56,756 | 10/18/2017 |
17.9.0 | 32,894 | 9/19/2017 |
17.8.0 | 64,474 | 8/15/2017 |
17.7.0 | 78,276 | 7/18/2017 |
17.6.0 | 27,949 | 6/15/2017 |
17.5.0 | 25,400 | 5/16/2017 |
17.4.0 | 48,462 | 4/20/2017 |
17.3.0 | 40,038 | 3/16/2017 |
17.2.0 | 27,598 | 2/16/2017 |
17.1.0 | 38,290 | 1/12/2017 |
16.12.0 | 50,992 | 12/13/2016 |
16.11.0 | 48,389 | 11/11/2016 |
16.10.0 | 54,273 | 10/12/2016 |
9.0.0 | 54,594 | 9/13/2016 |
8.9.2 | 92,038 | 8/19/2016 |
8.9.1 | 2,323 | 8/12/2016 |
8.9.0 | 53,095 | 7/18/2016 |
8.8.3 | 30,241 | 6/28/2016 |
8.8.2 | 25,361 | 6/3/2016 |
8.8.1 | 4,516 | 5/23/2016 |
8.8.0 | 93,012 | 4/21/2016 |
8.7.2 | 42,476 | 3/25/2016 |
8.7.1 | 74,054 | 2/24/2016 |
8.7.0 | 19,592 | 1/26/2016 |
8.6.3 | 28,240 | 12/23/2015 |
8.6.2 | 37,154 | 11/20/2015 |
8.6.1 | 26,962 | 10/23/2015 |
8.6.0 | 31,854 | 9/21/2015 |
8.5.2 | 13,576 | 8/17/2015 |
8.5.1 | 37,108 | 7/16/2015 |
8.5.0 | 19,607 | 6/19/2015 |
8.4.2 | 36,091 | 5/19/2015 |
8.4.1 | 11,356 | 4/15/2015 |
8.4.0 | 36,428 | 3/12/2015 |
8.3.2.1 | 47,317 | 2/4/2015 |
8.3.2 | 12,525 | 1/23/2015 |
8.3.1 | 17,713 | 12/10/2014 |
8.3.0 | 5,473 | 11/14/2014 |
8.2.2 | 75,436 | 10/16/2014 |
8.2.1 | 52,162 | 9/17/2014 |
8.2.0 | 12,185 | 8/15/2014 |
8.1.2 | 7,121 | 7/23/2014 |
8.1.1 | 20,660 | 6/27/2014 |
8.1.0 | 15,095 | 6/6/2014 |
8.0.2 | 11,896 | 5/14/2014 |
8.0.1 | 9,015 | 4/21/2014 |
8.0.0 | 9,033 | 3/26/2014 |
7.7.2 | 169,577 | 2/17/2014 |
7.7.1 | 20,631 | 1/15/2014 |
7.7.0 | 13,351 | 12/16/2013 |
7.6.1 | 52,094 | 11/18/2013 |
7.6.0 | 31,172 | 10/17/2013 |
7.5.3 | 9,967 | 9/10/2013 |
7.5.2 | 9,427 | 8/14/2013 |
7.5.1 | 6,733 | 7/18/2013 |
7.5.0 | 19,734 | 6/10/2013 |
7.4.3 | 31,041 | 4/29/2013 |
7.4.2 | 8,040 | 4/1/2013 |
7.4.1 | 6,031 | 3/4/2013 |
7.4.0 | 12,634 | 1/28/2013 |
7.3.5 | 6,789 | 12/31/2012 |
7.3.4 | 10,688 | 11/30/2012 |
7.3.3 | 15,043 | 10/30/2012 |
7.3.2 | 43,714 | 9/28/2012 |
7.3.1 | 8,282 | 8/27/2012 |
7.3.0 | 7,762 | 7/17/2012 |
7.2.2 | 8,699 | 6/18/2012 |
7.2.1 | 5,715 | 5/21/2012 |
7.2.0 | 19,845 | 4/16/2012 |
7.1.2 | 4,317 | 3/19/2012 |
7.1.1.1 | 4,070 | 2/16/2012 |
7.1.1 | 3,006 | 2/14/2012 |
7.1.0 | 8,115 | 1/24/2012 |