Smart Makers : Is it possible to have a label subtotal by grouping?

Aspose.Cells Product Family
1

Hi !

I want to put a label for each subtotal line, like this (attachment)

On merge, the label “SubTotal” is present only on last row…
I read Smartly importing and placing data with Smart markers|Documentation but I do not know how to…

1/ Is it possible to put a label on a line in total?


2/ Is it possible to concatenate the value of a column with that Label ?
for example: “Sub Total of Order1”

thanks

2

Hi,


Yes, you may put custom labels in the smart markers while concatenating with the sub total rows in grouping data, see the template file attached for reference, here is the sample code and also find attached the output resultant file. You may adjust the markers accordingly after understanding the existing markers in the template file.

Sample code:
Workbook workbook = new Workbook(“e:\test2\CellsNet30672.xlsx”);
DataTable dt = workbook.Worksheets[0].Cells.ExportDataTable(0, 0, 11, 5, true);
WorkbookDesigner d = new WorkbookDesigner();
d.Workbook = workbook;
dt.TableName = “Report”;
d.SetDataSource(dt);
d.Process();
workbook.Save(“e:\test2\outCellsNet30672.xlsx”);

Also, please try out latest fix v7.1.1.5: Aspose.Cells for .NET v7.1.1.5

3
Thanks, it s a good news, but:
I am forced to use version 7.0.1.0, I think that this feature does not exist in this version?
4

Hi,


I am not sure if this feature is supported in your mentioned version but you may try if it works. If it does not work, I am afraid you have to use the latest versions e.g v7.1.1 of the product.

Thank you.