Create matrix-like spreadsheet reports, complete with calculations, figures, sparklines, tables, and color themes.

DsExcel .NET models its interface-based API on Excel's document object model. This means that users can import, calculate, query, generate, and export any spreadsheet scenario as and when required. Moreover, the imported or generated spreadsheets can contain references to one another, such as you can reference full reports, sort and filter tables, sort and filter pivot tables, add charts, sparklines, conditional formats, and dashboard reports etc.

DsExcel .NET provides users with the ability to display aggregated data in a spreadsheet using pivot tables - a data summarization tool that can perform complex analysis of information stored in cells for exploring, analyzing and manipulating bulk data in a worksheet.

DsExcel .NET provides you with the ability to summarize large amounts of information in groups so that complex spreadsheets are easier to navigate. The data in rows or columns can be grouped to organize information and create custom views in a spreadsheet.