Ability to generate master dashboard and multiple, granular detail worksheets

Aspose.Cells Product Family
,
21

@sagaofsilence.dev
Please check the attached files：
Detail_Master.zip (62.2 KB)
Are they your excepted result?

We generated result with the following codes:

 var wbk1 = new Workbook(dir + "template.xlsx");
 WorkbookDesigner d = new WorkbookDesigner();
 d.Workbook = wbk1;
 d.SetJsonDataSource(null, File.ReadAllText(dir + "ShirtsStyleData.json"));
 d.Process();
 wbk1.Save(dir + "dest.xlsx");
22

@sagaofsilence.dev,

This is to notify that your issue (Ticket ID: “CELLSJAVA-46477”) has been resolved. The feature/enhancement will be included in the next release (Aspose.Cells v25.9), which is scheduled for the next week of September 2025. We will inform you once the new version is available.

23

The issues you have found earlier (filed as CELLSJAVA-46477) have been fixed in Aspose.Cells for Java 25.9.

24

Could you please provide me the official documentation for master details worksheet in excel template ?

25

@rupali14
Thank you for your feedback. Sorry, there is currently no official documentation for Master-Detail smart markers. We will add it as soon as possible. At present, you can refer to Simon’s response earlier to implement your own needs.

26

Could you please provide me with the possible values for the following parameters?

DetailSheet

DetailTable

DetailSheetNewName

Additionally, if there’s any acceptable for adding data to Excel, it would be very helpful if you could share that as soon as possible.

Thank you in advance for your support!

27

@rupali14,

Alright, we will soon provide you with the necessary resource files with details and other artifacts for your requirements.

28

@rupali14
Detail_Master.zip
In MasterDetail_template.xlsx:
DetailSheet: DETAIL_STYLES means the worksheet “DETAIL_STYLES” is detail worksheet which contains some smart markers about style. We will repeat “DETAIL_STYLES” according to master records.
DetailTable:Style, in the worksheet “DETAIL_STYLES” , the smart markers should start with “Style.”
DetailSheetNewName:{node.Styles3.StyleID}&“_”&{node.Styles3.StyleName} ,DetailSheetNewName:{node.Styles3.StyleName}, it could be a smart expression, the result of this expression will be processed as the name of new sheet( repeated “DETAIL_STYLES” worksheet)

in Detail_template.xlsx
DetailSheet, If no value for this DetailSheet smart marker, it means that current worksheet is a detail sheet, this sheet will be repeated when processing.

29

We are focused on understanding the three new parameters—DetailSheet, DetailTable, and DetailSheetNewName—introduced within the Aspose Cells variable support Excel templates.

While the few working examples you provided are useful, we need a clearer, comprehensive guide to the rules governing how these parameters can be used.

Could you please elaborate on the specifications for each parameter? This detailed explanation will serve as our primary technical reference until the official documentation is available.

For each of the three parameters, we need to know the specific technical requirements, including:

  • Acceptable Values (Syntax): What are the valid data types and formatting rules for assigning values to this parameter?
  • Restrictions: Are there any specific limitations on the length, characters, or context of the assigned values? Can it accept dynamic data or only hand coded data? (e.g. DetailSheet:{RootData.Product.Name} or DetailSheet:Shirt)
  • Optionality: Is the parameter required, or can it be omitted?
  • Default Behavior: If the parameter is optional, what is the default value or behavior applied by Aspose Cells?
  • Excel Constraints: Does the parameter only accept values allowed by the underlying Excel runtime, or are there any differences in behavior or limitations?
30

@sagaofsilence.dev,

We will evaluate your queries and concerns and provide necessary details soon.

31

@rupali14
DetailSheet
Acceptable Values (Syntax):: String value.
Restrictions: Value must be null or the name of worksheet. If null, this is a detail sheet.
It should be a simple string value. Variable is not supported.
Do you need a Smart marker Expression ({RootData.Product.Name} ) as the value ?
Optionality: If omitted, not master or detail sheet.
Default Behavior: Normal worksheet, not master or detail sheet.
Excel Constraints:

DetailTable:
Acceptable Values (Syntax):: String value.
Restrictions:
Optionality: If omitted, the smart marker in the detail sheet should be similar to master sheet, otherwise we can not find data source.
Default Behavior: See above Optionality:
Excel Constraints::

DetailSheetNewName:
Acceptable Values (Syntax):: Excel formula liked Expression
Restrictions: It should be a valid formula for Excel if we replace Variable ({a.bc}) as simple value.
Optionality: If omitted, new sheet will be Sheet1,Sheet2…
Default Behavior: See above Optionality:
Excel Constraints: The name must be a valid name of woksheet.

1 Like