Aspose.Cells 24.9.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 also provides various Grid solutions with GUI-based .NET controls; Aspose.Cells.GridDesktop, Aspose.Cells.GridWeb, and Aspose.Cells.GridJs.

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 800+ public classes that offer .NET developers to integrate exciting spreadsheet manipulation features into their applications, ranging from creating pivot charts, combining 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.

What's new in Aspose.Cells for .NET v.24.9.0

The Aspose.Cells for .NET 24.9 release brings significant new features and improvements for enhanced document processing. Here are the key updates:

New Features

• MathML Support (CELLSNET-56319):
  Added support for exporting equation content to MathML format, improving compatibility with mathematical standards.

• Equation Group Enhancements (CELLSNET-56300):
  Now supports reading, storing, and rendering of limit equations and equation groups, expanding equation handling capabilities.

• PivotTable Support (CELLSNET-43395):
  Added translation support for “Sum of” column in PivotTable reports for multilingual environments.

• Image Quality Customization (CELLSNET-1457):
  Ability to adjust the image quality for JPG files, offering flexibility in rendering document images.

Bug Fixes

• Improved Equation Rendering (CELLSNET-56549):
  Fixed an issue where limit equations did not render correctly when exporting to PDF.

• Excel to PDF Conversion Issues (CELLSNET-56596):
  Addressed chart distortion and scaling errors during Excel to PDF conversion.

For a complete list of all new features, enhancements, and bug fixes introduced in this release, visit the Aspose.Cells for .NET 24.9 Release Notes.

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.

Supported Read & Write Formats

Microsoft Excel®: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM, CSV, TSV, TabDelimited, SpreadsheetML
OpenOffice: ODS, SXC, FODS
Text: TXT
Web: HTML, MHTML
iWork®: Numbers
Other: SXC

Save Excel® Files As

Microsoft Word®: DOCX
Microsoft PowerPoint®: PPTX
Fixed Layout: PDF, XPS
Data Interchange: DIF
Vector Graphics: SVG
Image: TIFF,PNG, BMP, JPEG, GIF
Metafile: EMF
Markdown: MD

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.

Get Started

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.

Import JSON Data into Excel® Using C# with Aspose.Cells

The provided C# code snippet demonstrates how to import JSON data into an Excel® worksheet using Aspose.Cells API enables you to integrate JSON data into Excel for reporting, data analysis, or sharing with stakeholders. The snippet not only shows how to read JSON from a file and import it into a worksheet but also highlights how to apply custom styling to the imported data, making the data presentation more professional. By leveraging this code, you can automate data import processes, thus saving time and reducing errors associated with manual data entry.

Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
//Cutom style for the title
Style style = workbook.CreateStyle();
style.Font.IsBold = true;

string jsonInput = File.ReadAllText(dataDir + "Test.json");
JsonLayoutOptions options = new JsonLayoutOptions();
options.TitleStyle = style;

// Import JSON Data
JsonUtility.ImportData(jsonInput, worksheet.Cells, 0, 0, options);

Export Excel® Data to JSON Format with Aspose.Cells in C#

This concise C# snippet exports data from Excel® XLSX to JSON using Aspose.Cells API. It converts a range of cells into JSON, facilitating easy data sharing and integration with web apps, databases, or APIs. This enhances data flexibility and ensures smooth, efficient data transformations.

var workbook = new Aspose.Cells.Workbook(dir + "data.xlsx");
Cells cells = workbook.Worksheets[0].Cells;
JsonSaveOptions jsonSaveOptions = new JsonSaveOptions();
Range range = workbook.Worksheets[0].Cells.CreateRange(0, 0, cells.MaxDataRow + 1, cells.MaxDataColumn + 1);
string data = JsonUtility.ExportRangeToJson(range, jsonSaveOptions);

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[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");