Aspose.Cells
20.12.0
See the version list below for details.
dotnet add package Aspose.Cells --version 20.12.0
NuGet\Install-Package Aspose.Cells -Version 20.12.0
<PackageReference Include="Aspose.Cells" Version="20.12.0" />
paket add Aspose.Cells --version 20.12.0
#r "nuget: Aspose.Cells, 20.12.0"
// 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
.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
- 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 settingCell.HtmlString
. - Improved performance when converting complex
XLSM
toHTML
.
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 Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net20 is compatible. net35 is compatible. net40 is compatible. net40-client is compatible. net403 was computed. net45 was computed. net451 was computed. net452 was computed. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. monoandroid44 is compatible. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. xamarinios10 is compatible. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.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 (90)
Showing the top 5 NuGet packages that depend on Aspose.Cells:
Package | Downloads |
---|---|
fion.modelerp.core
ModelErp |
|
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. |
|
Aspose.Cells.GridJs
Aspose.Cells.GridJs is a lightweight, scalable, and customizable toolkit that provides cross-platform web applications, enables convenient development for editing or viewing Excel/Spreadsheet files, offers simple deployment, and provides easy-to-use APIs based on JSON format. |
|
Pj.Library.ThirdParty
Utilities to fasten the development -Library Extensions to the default .net system objects Helpers for serialization, transform, compression, network and file transfer, database operations, logging -Secure Provides encryption and decryption -Service Cloud service support with google drive access and onedrive storage access -ThirdParty Excel read and write, csv file operations |
|
BLT.Common
Package Description |
GitHub repositories (7)
Showing the top 5 popular GitHub repositories that depend on Aspose.Cells:
Repository | Stars |
---|---|
axzxs2001/Asp.NetCoreExperiment
原来所有项目都移动到**OleVersion**目录下进行保留。新的案例装以.net 5.0为主,一部分对以前案例进行升级,一部分将以前的工作经验总结出来,以供大家参考!
|
|
aspose-cells/Aspose.Cells-for-.NET
Aspose.Cells for .NET examples, plugins and showcases
|
|
loamen/Kalman.Studio
Kalman.Studio代码生成器是一款基于T4模板引擎的代码生成器和开发辅助工具。可以根据数据库元数据架构信息来生成代码,还可以解析PowerDesigner物理模型文件,根据PDM模型对象来生成代码等。
|
|
xlljc/DungeonShooting
《枪火地牢》,一款由Godot开发的地牢射击Rogue游戏
|
|
known/Known
Known是基于Blazor的企业级快速开发框架,低代码,跨平台,开箱即用,一处代码,多处运行。
|
Version | Downloads | Last updated |
---|---|---|
24.9.0 | 34,819 | 9/10/2024 |
24.8.0 | 90,546 | 8/8/2024 |
24.7.0 | 71,154 | 7/11/2024 |
24.6.0 | 85,504 | 6/14/2024 |
24.5.0 | 116,005 | 5/9/2024 |
24.4.0 | 153,165 | 4/9/2024 |
24.3.0 | 205,251 | 3/8/2024 |
24.2.0 | 157,793 | 2/5/2024 |
24.1.0 | 198,218 | 1/10/2024 |
23.12.0 | 153,480 | 12/12/2023 |
23.11.0 | 248,935 | 11/9/2023 |
23.10.0 | 288,890 | 10/12/2023 |
23.9.0 | 186,997 | 9/13/2023 |
23.8.0 | 308,993 | 8/9/2023 |
23.7.0 | 202,028 | 7/13/2023 |
23.6.0 | 216,685 | 6/8/2023 |
23.5.0 | 238,026 | 5/9/2023 |
23.4.0 | 333,211 | 4/11/2023 |
23.3.0 | 626,704 | 3/8/2023 |
23.2.0 | 257,368 | 2/8/2023 |
23.1.1 | 261,155 | 1/17/2023 |
23.1.0 | 84,860 | 1/10/2023 |
22.12.0 | 342,581 | 12/9/2022 |
22.11.0 | 370,433 | 11/10/2022 |
22.10.1 | 364,762 | 10/20/2022 |
22.10.0 | 83,186 | 10/11/2022 |
22.9.0 | 480,876 | 9/8/2022 |
22.8.0 | 226,506 | 8/4/2022 |
22.7.0 | 252,646 | 7/7/2022 |
22.6.1 | 485,243 | 6/13/2022 |
22.5.0 | 270,576 | 5/10/2022 |
22.4.0 | 292,227 | 4/12/2022 |
22.3.0 | 408,763 | 3/10/2022 |
22.2.0 | 279,552 | 2/11/2022 |
22.1.0 | 376,164 | 1/7/2022 |
21.12.0 | 221,571 | 12/8/2021 |
21.11.0 | 370,066 | 11/8/2021 |
21.10.0 | 217,392 | 10/14/2021 |
21.9.0 | 305,628 | 9/15/2021 |
21.8.0 | 229,724 | 8/12/2021 |
21.7.0 | 307,527 | 7/13/2021 |
21.6.0 | 375,337 | 6/16/2021 |
21.5.0 | 342,150 | 5/14/2021 |
21.4.0 | 231,374 | 4/14/2021 |
21.3.0 | 211,440 | 3/11/2021 |
21.2.0 | 416,613 | 2/5/2021 |
21.1.0 | 524,560 | 1/15/2021 |
20.12.0 | 260,658 | 12/17/2020 |
20.11.0 | 347,560 | 11/12/2020 |
20.10.0 | 238,110 | 10/16/2020 |
20.9.0 | 207,722 | 9/10/2020 |
20.8.0 | 277,838 | 8/13/2020 |
20.7.0 | 361,598 | 7/15/2020 |
20.6.0 | 393,057 | 6/12/2020 |
20.5.0 | 187,563 | 5/21/2020 |
20.4.0 | 338,954 | 4/16/2020 |
20.3.0 | 344,847 | 3/19/2020 |
20.2.0 | 166,544 | 2/20/2020 |
20.1.0 | 216,784 | 1/16/2020 |
19.12.0 | 231,128 | 12/17/2019 |
19.11.0 | 255,470 | 11/15/2019 |
19.10.0 | 194,650 | 10/18/2019 |
19.9.0 | 234,718 | 9/18/2019 |
19.8.0 | 221,026 | 8/20/2019 |
19.7.0 | 292,631 | 7/18/2019 |
19.6.0 | 124,526 | 6/20/2019 |
19.5.0 | 127,767 | 5/16/2019 |
19.4.0 | 352,688 | 4/17/2019 |
19.3.0 | 146,953 | 3/15/2019 |
19.2.0 | 171,691 | 2/18/2019 |
19.1.0 | 171,402 | 1/17/2019 |
18.12.0 | 415,137 | 12/19/2018 |
18.11.0 | 135,656 | 11/19/2018 |
18.10.0 | 157,225 | 10/18/2018 |
18.9.0 | 57,306 | 9/17/2018 |
18.8.0 | 128,449 | 8/15/2018 |
18.7.0 | 136,957 | 7/12/2018 |
18.6.0 | 202,010 | 6/19/2018 |
18.5.1 | 52,553 | 5/23/2018 |
18.5.0 | 81,621 | 5/17/2018 |
18.4.0 | 126,135 | 4/19/2018 |
18.3.0 | 148,213 | 3/16/2018 |
18.2.0 | 48,727 | 2/7/2018 |
18.1.0 | 154,436 | 1/18/2018 |
17.12.0 | 93,191 | 12/15/2017 |
17.11.1 | 33,806 | 11/20/2017 |
17.10.0 | 73,132 | 10/18/2017 |
17.9.0 | 46,117 | 9/19/2017 |
17.8.0 | 107,222 | 8/15/2017 |
17.7.0 | 104,717 | 7/18/2017 |
17.6.0 | 39,061 | 6/15/2017 |
17.5.0 | 37,360 | 5/16/2017 |
17.4.0 | 68,716 | 4/20/2017 |
17.3.0 | 52,337 | 3/16/2017 |
17.2.0 | 57,178 | 2/16/2017 |
17.1.0 | 51,115 | 1/12/2017 |
16.12.0 | 70,551 | 12/13/2016 |
16.11.0 | 66,134 | 11/11/2016 |
16.10.0 | 83,305 | 10/12/2016 |
9.0.0 | 91,110 | 9/13/2016 |
8.9.2 | 105,708 | 8/19/2016 |
8.9.1 | 6,098 | 8/12/2016 |
8.9.0 | 69,342 | 7/18/2016 |
8.8.3 | 44,168 | 6/28/2016 |
8.8.2 | 38,047 | 6/3/2016 |
8.8.1 | 8,720 | 5/23/2016 |
8.8.0 | 133,268 | 4/21/2016 |
8.7.2 | 55,551 | 3/25/2016 |
8.7.1 | 96,067 | 2/24/2016 |
8.7.0 | 27,644 | 1/26/2016 |
8.6.3 | 45,074 | 12/23/2015 |
8.6.2 | 50,859 | 11/20/2015 |
8.6.1 | 42,040 | 10/23/2015 |
8.6.0 | 41,406 | 9/21/2015 |
8.5.2 | 46,413 | 8/17/2015 |
8.5.1 | 54,778 | 7/16/2015 |
8.5.0 | 31,470 | 6/19/2015 |
8.4.2 | 57,098 | 5/19/2015 |
8.4.1 | 20,487 | 4/15/2015 |
8.4.0 | 47,917 | 3/12/2015 |
8.3.2.1 | 92,927 | 2/4/2015 |
8.3.2 | 17,902 | 1/23/2015 |
8.3.1 | 25,298 | 12/10/2014 |
8.3.0 | 13,501 | 11/14/2014 |
8.2.2 | 91,998 | 10/16/2014 |
8.2.1 | 69,726 | 9/17/2014 |
8.2.0 | 19,772 | 8/15/2014 |
8.1.2 | 12,299 | 7/23/2014 |
8.1.1 | 31,014 | 6/27/2014 |
8.1.0 | 24,070 | 6/6/2014 |
8.0.2 | 18,174 | 5/14/2014 |
8.0.1 | 13,887 | 4/21/2014 |
8.0.0 | 18,265 | 3/26/2014 |
7.7.2 | 291,940 | 2/17/2014 |
7.7.1 | 27,702 | 1/15/2014 |
7.7.0 | 24,148 | 12/16/2013 |
7.6.1 | 56,132 | 11/18/2013 |
7.6.0 | 45,848 | 10/17/2013 |
7.5.3 | 15,385 | 9/10/2013 |
7.5.2 | 16,241 | 8/14/2013 |
7.5.1 | 11,301 | 7/18/2013 |
7.5.0 | 33,376 | 6/10/2013 |
7.4.3 | 36,981 | 4/29/2013 |
7.4.2 | 13,873 | 4/1/2013 |
7.4.1 | 10,833 | 3/4/2013 |
7.4.0 | 21,135 | 1/28/2013 |
7.3.5 | 10,464 | 12/31/2012 |
7.3.4 | 19,069 | 11/30/2012 |
7.3.3 | 18,686 | 10/30/2012 |
7.3.2 | 64,351 | 9/28/2012 |
7.3.1 | 13,566 | 8/27/2012 |
7.3.0 | 13,186 | 7/17/2012 |
7.2.2 | 15,799 | 6/18/2012 |
7.2.1 | 11,182 | 5/21/2012 |
7.2.0 | 29,694 | 4/16/2012 |
7.1.2 | 7,777 | 3/19/2012 |
7.1.1.1 | 7,968 | 2/16/2012 |
7.1.1 | 6,581 | 2/14/2012 |
7.1.0 | 27,859 | 1/24/2012 |