Aspose.Cells 26.9.0

.NET API for Excel® File Formats

Aspose.Cells for .NET is a powerful spreadsheet management library that allows developers to create, format, and manipulate Excel files programmatically without the need for Microsoft Excel. It supports features like creating Pivot Tables, applying advanced conditional formatting, converting workbooks to multiple formats (PDF, HTML, JSON), working with charts, Smart Markers, OLE objects, dynamic array formulas, modern Excel 365 functions (LAMBDA, LET, MAP, and more), and filtering data, all using C#. With extensive support for rendering and automation, it offers a seamless and versatile solution for Excel automation in .NET applications.

Aspose.Cells for .NET also provides various Grid solutions with GUI-based .NET controls; Aspose.Cells.GridDesktop, Aspose.Cells.GridWeb, and Aspose.Cells.GridJs.

PivotTable Features

Create and Format Pivot Tables

Provides options to create, format, and remove Pivot Tables from a worksheet.

Support for Different Pivot Table Layouts

Offers predefined layouts (Compact, Outline, Tabular) for Pivot Tables.

Rendering and Conversion Features

Convert Workbook to Different Formats

Supports converting workbooks to formats like PDF, HTML, JSON, and more.

Track Document Conversion Progress

Enables tracking of conversion progress during rendering.

Set Image Resample Option for PDF Conversion

Allows resampling images during conversion to reduce PDF file size.

Cells Features

Access Cells of a Worksheet

Access and manipulate individual cells in the worksheet.

Add and Retrieve Data

Add data to specific cells and retrieve it as needed.

Insert and Delete Rows and Columns

Provides methods for inserting or deleting rows and columns.

Apply Styles and Formatting to Cells

Set different styles, alignment, and font properties to enhance cell formatting.

Chart Features

Create and Customize Charts

Supports creating and customizing different types of charts, such as Column, Line, Pie, Doughnut, Radar, and more.

Create Pivot Charts

Supports creating Pivot Charts along with Pivot Tables.

Workbook Views Features

Page Break Preview

Displays the worksheet as it will print, showing the page breaks.

Normal View Mode

Default view of a worksheet showing the content without page break indicators.

Zoom Factor

Allows setting the zoom factor to adjust the size of the worksheet contents.

Freeze and Split Panes

Keeps specific rows or columns visible while scrolling through the worksheet and splits the view for easier navigation and editing.

Defined Names Features

Create Named Ranges

Create and access named ranges to refer to specific cells or ranges for easier identification and calculations.

Filter Defined Names

Filter or remove defined names present inside the workbook using LoadDataFilterOptions.

Conditional Formatting Features

Conditional Formatting in Worksheets

Use Aspose.Cells to apply conditional formatting based on cell value or formula.

Advanced Conditional Formatting

Apply data bars, color scales, and icon sets for enhanced conditional formatting.

Copy Method for Conditional Formatting

Copy conditional formatting settings from one cell to another using the Range.Copy() method.

Runtime Conditional Formatting

Add and remove conditional formatting dynamically using Aspose.Cells API.

Comments Features

Adding, Modifying, and Removing Comments

Add comments to specific cells, retrieve, modify, and remove them as needed.

Threaded Comments

Add threaded comments, allowing for discussion-like conversations in cells, similar to Excel 365.

Themes Features

Excel Themes and Colors

Create, apply, and customize color schemes and themes in Excel worksheets.

Custom Color Themes

Use Aspose.Cells to create custom color themes, modifying only theme colors instead of individual cells.

SmartArt Features

Extract Text from SmartArt

Extract text from the Gear Type SmartArt Shape using Shape.GetResultOfSmartArt() and GroupShape.GetGroupedShapes().

Convert SmartArt to Group Shape

Convert SmartArt into group shapes for detailed manipulation.

Text Box Features

Add Text Box to Worksheet

Insert a text box into a worksheet and customize its properties.

Text Alignment in TextBox

Apply different text alignment settings within a text box for formatting.

Links Features

Hyperlinks

Create hyperlinks to link data within worksheets for easy navigation.

OleObject Features

Managing OLE Objects

Embed and manipulate OLE objects in worksheets using Aspose.Cells.

Page Setup Features

Set Margins

Allows setting top, left, right, and bottom margins for a worksheet.

Page Breaks

Allows inserting horizontal and vertical page breaks at specific cells.

Set Print Area and Print Titles

Provides options for setting the print area and print titles for a worksheet.

Custom Paper Size

Implement custom paper sizes for worksheet rendering and printing.

Insert Background Image

Add a background image to the worksheet using Aspose.Cells.

Filter Features

Auto-Filter and Custom Data Filter

Provides options for filtering data based on various conditions like text, numbers, and dates.

Fill Color Filter

Filter data based on the fill color of cells using the AddFillColorFilter function.

Date, Number, and Text Filters

Provides options for filtering rows based on dates, numbers, or text criteria.

Blanks and Non-Blanks Filters

Filters rows based on whether they contain blank or non-blank cells.

Outline Features

Group or Ungroup Rows and Columns

Allows grouping or ungrouping rows and columns in the worksheet for better data organization.

Controls Features

Workbook VBA Project

Allows managing VBA projects within the workbook, including adding and modifying VBA code.

Calculation Features

Tracing Precedents and Dependents

Provides tools for tracing precedent and dependent cells in complex worksheets to identify data relationships.

Dynamic Array Formulas (Excel 365 and Excel 2021)

Full support for modern dynamic array formulas including