Guys, I’m having a scenario where I want to group things in the following way on a designer worksheet so later I can generate a PDF.
Thanks for your posting and using Aspose.Cells.
If you are using Smart Markers to populate your data, then you can use the smart marker attribute group:normal.
will populate the data in a normal group and add 1 extra row after each grouping.
The output will look like as shown in the screenshot. Please see the following code, I have attached the source.xlsx file used in this code and output xlsx file generated by it for your reference.
Workbook workbook = new Workbook(“source.xlsx”);
Worksheet worksheet = workbook.Worksheets;
DataTable dataTable = worksheet.Cells.ExportDataTable(0, 0, 7, 2, true);
dataTable.TableName = “Data”;
WorkbookDesigner designer = new WorkbookDesigner(workbook);