Create and render pivot table with data model in Excel file in Java

Aspose.Cells Product Family
,
1

we want to create an application, where we can render data to pre-build excel with the data model.
will aspose support this kind of operation.

2

@nvn16,

I am not entirely certain about your issue, so kindly elaborate with sample Excel files to understand your requirements. Also, how could you accomplish the task in MS Excel manually? By the way, we have Smart Markers feature where you use a template Excel file containing markers and other formattings or data. You set the link to external data source (for markers), so markers are processed and data is filled into the relevant columns’ cells accordingly.

3

@Amjad_Sahi,

file : Sample_DataModel.zip - Google Drive
We want to generate similar excel using aspose cells which are having Data Model internally.

Could you please confirm if Aspose Cells supports the Data model feature?
If yes, how can we achieve it using aspose cells?
If No, any ETA when can Aspose cells support Data Models?

We checked comments on other tickets/forums that aspose cells are not currently supporting Data Models.

Thanks.
Naveen

4

@nvn16,

Checking your provided file, I guess you need to create and render Pivot Tables with data model. Please note, currently, Aspose.Cells can’t refresh and calculate the PivotTable with data models. We will support PivotTable with data model later before the end of Q2, 2021 because this feature is complex and some documents are not completed yet.

5

@Amjad_Sahi, thank you.
could you please update this ticket once the feature is developed.

6

@nvn16,

We already logged a ticket with an id “CELLSNET-47214” into our database for it. The ticket id is attached to this thread as well. Once we support it, we will update you here.

7

thanks @Amjad_Sahi

8

You are welcome.