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.

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.

Styles

Set styles to format cell appearance.

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.

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 Settings

Configure print settings to manage printing options.

Defined Names

Name the tables or ranges within workbook or worksheet scope.