In This Topic
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.
- 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.
- Theme
- Apply built-in or custom themes 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.
