You can set various styles for worksheet cells. A cell style consists in fill settings like solid fill, pattern fill or gradient fill, alignment, number format or border lines style.

You can add charts to a worksheet as embedded shapes. The chart series can be automatically created from the specified data source range or the series can be manually added to the chart.

You can set worksheet cells with various data types.

The product also offers an integrated formula calculation engine which allows you to calculate the formula results and set the result in the workbook.

You can import data from a .NET DataTable or DataView object to an Excel worksheet.