See the version list below for details.
dotnet add package Aspose.Cells --version 22.9.0
NuGet\Install-Package Aspose.Cells -Version 22.9.0
<PackageReference Include="Aspose.Cells" Version="22.9.0" />
paket add Aspose.Cells --version 22.9.0
#r "nuget: Aspose.Cells, 22.9.0"
// Install Aspose.Cells as a Cake Addin #addin nuget:?package=Aspose.Cells&version=22.9.0 // Install Aspose.Cells as a Cake Tool #tool nuget:?package=Aspose.Cells&version=22.9.0
Add Multiple Tables in Apple Numbers .NET API
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.
What is Aspose.Cells for .NET?
Aspose.Cells for .NET enables your .NET, C#, ASP.NET, and VB.NET applications to create, format, render, print and convert Microsoft Excel® and OpenDocument spreadsheets (XLS, XLSX, ODS, etc.) to various supported formats, without the need to install Microsoft Excel or any 3rd party software. Its powerful formula calculation engine supports various standard and advanced MS Excel® formulas/functions.
Aspose.Cells for .NET is written in managed C# and can be used in any kind of .NET-based Windows Desktop Application or ASP.NET Web Application. Our library can also be used with classic ASP, and PHP.
It’s rich object model consists of 100+ public classes that offer .NET developers to integrate exciting spreadsheet manipulation features into their applications, ranging from creating pivot charts, combinings spreadsheets, parsing data, to encrypting and exporting spreadsheet files. Render spreadsheet pages to raster (TIFF, multipage TIFF, PNG, JPEG, BMP) or vector (EMF) images. Aspose.Cells for .NET also supports working with XLSB, XLT, XLTX, XLTM, XLSM, XML, HTML, CSV, TSV, HTML/MHTML, etc. It is capable of converting spreadsheets to PDF and XPS formats while maintaining the highest visual fidelity. You can add standard and customized charts and dynamically set data in order to refresh the charts. The charts can also be converted to high-quality PDF and raster image formats.
Spreadsheet 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.
What's new in v22.9.0
Add Multiple Table in Numbers®
Ability to insert multiple tables in Apple® Numbers® worksheet.
Export Empty Cells to JSON
This API release offers the enhancement to export empty cells as
Improved Excel to PDF Conversion
It was observed that while converting Excel To PDF, the resultant PDF did not show axis correctly. This issue has now been resolved.
Set table formula for
Ability of setting table formula for the
Read & Write
SHA512 Protected Range
Added the ability to read and write protected range of
For a complete list of features, enhancements, and bug fixes in this release please visit, Aspose.Cells for .NET 22.9 Release Notes.
Supported Read & Write Formats
Microsoft Excel®: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM, CSV, TSV, TabDelimited, SpreadsheetML
OpenOffice: ODS, SXC, FODS
Web: HTML, MHTML
Other: SXC, FODS
Save Excel® Files As
Microsoft Word®: DOCX
Microsoft PowerPoint®: PPTX
Microsoft Excel®: XLAM
Fixed Layout: PDF, XPS
Data Interchange: DIF
Vector Graphics: SVG
Image: TIFF,PNG, BMP, JPEG, GIF
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.
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# Code
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; // 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");
|Product||Versions Compatible and additional computed target framework versions.|
|.NET||net5.0 was computed. net5.0-windows was computed. net6.0 is compatible. 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-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.|
- No dependencies.
- No dependencies.
- No dependencies.
- No dependencies.
- No dependencies.
NuGet packages (74)
Showing the top 5 NuGet packages that depend on Aspose.Cells:
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.
Enables Excel automation using the Aspose.Cells library.
GitHub repositories (4)
Showing the top 4 popular GitHub repositories that depend on Aspose.Cells:
Aspose.Cells for .NET examples, plugins and showcases
Smocks is a library for mocking the normally unmockable. It can mock static and non-virtual methods and properties, amongst others.