This section comprises the features available in DsExcel.

Worksheet

Work with cells, range and basic worksheet operations.

Workbook

Work with basic workbook operations.

Comments

Add or delete comments, show or hide comments, set rich text, comment layout or author of a comment.

Hyperlinks

Add, configure or delete hyperlinks.

Sort

Apply sorting and its various types.

Filter

Apply filtering and its several types.

Group

Apply grouping over data in rows or columns.

Conditional Formatting

Apply conditional formatting in a cell or range of cells.

Data Validations

Add, modify and delete data validations.

Data Binding

Bind data to sheet, cell or table columns.

Import Data

Import data from an object collection or a table to a range.

Digital Signatures

Add, countersign, verify and delete digital signatures.

Formulas

Use formulas to carry complex calculations.

Custom Functions

Create custom functions to implement custom arithmetic logic.

Shapes and Pictures

Work with shapes and pictures in a worksheet.

Dynamic Array Formulas

Work with Dynamic Array Formulas.

Styles

Set styles to format cell appearance.

Document Properties

Learn how to set built-in or custom document properties.

Form Controls

Use form controls to make your worksheet interactive and to get inputs from the users.

Barcodes

Supports 11 types of barcodes in worksheet, their JSON I/O and export to PDF.

Themes and Colors

Apply built-in or custom themes and colors to change the workbook appearance.

Chart

Work with charts to display data graphically.

Table

Use tables to organize large amount of data efficiently.

Pivot Table

Use pivot table to perform analysis of complex information and summarize data.

Pivot Chart

Use pivot chart to display pivot table's data graphically.

Sparkline

Use sparklines to insert graphical illustration of trends in data.

Slicer

Use slicers to perform quick filtration of data in tables and pivot tables.

Print

Configure print and page settings to manage printing options.

Logging

Capture debug, error, information and warning logs to locate issues and finding out their root cause.

Defined Names

Name the tables or ranges within workbook or worksheet scope.