Excel format as table

Aspose.Cells Product Family
1

would like to check if aspose is able to format data exported from C# DataTable with some pre defined excel table style

is there any method to return the exported excel as a byte[]

ExcelMedium.png (2.3 KB)

2

@bczm8703,

Thanks for the screenshot.

I think you may try to use Smart Markers feature provided by Aspose.Cells APIs. But first you can add list object/table with your desired style/formatting and then place markers into different columns which would be processed and relevant cells would be filled with data (from datatable). The formatting of the table would be retained after markers are processed and data is filled into the relevant cells.