Features

This section comprises the features available in DsExcel.

Work with cells, range and basic worksheet operations.

Work with basic workbook operations.

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

Add, configure or delete hyperlinks.

Apply sorting and its various types.

Apply filtering and its several types.

Apply grouping over data in rows or columns.

Apply conditional formatting in a cell or range of cells.

Add, modify and delete data validations.

Bind data to sheet, cell or table columns.

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

Use formulas to carry complex calculations.

Create custom functions to implement custom arithmetic logic.

Work with shapes and pictures in a worksheet.

Set styles to format cell appearance.

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

Work with charts to display data graphically.

Use tables to organize large amount of data efficiently.

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

Use sparklines to insert graphical illustration of trends in data.

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

Configure print settings to manage printing options.

Name the tables or ranges within workbook or worksheet scope.