☝️Small business or a startup? See if you qualify for our special offer.
+

Export File that already has a pivot table created, not just dataset

Answered
Erick asked 5 days ago

Wanted to confirm I would have the ability to export a pre-configured Pivot Tables with drill-down enabled inside Excel (not just raw data)?

3 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster 4 days ago

Hello Erick,

Thank you for contacting us.

Currently, Flexmonster exports all the data visible on the grid to the static Excel file. This way, while the rows are drilled up on the grid, the exported Excel only contains the drilled-up data.

You are welcome to contact us if other questions arise.

Kind regards,
Nadia

Public
Erick 3 days ago

Would my developer be able to customize the Javascript to export pivot table with raw data included. He's done custom Java work prior. But with this tool permit use to customize? 

Public
Maksym Diachenko Maksym Diachenko Flexmonster 1 day ago

Hello, Erick!

Thank you for reaching out to us.

Exporting an Excel pivot table is outside the scope of Flexmonster's built-in functionality. However, this may be possible to implement with an external JavaScript library for working with Excel.

To achieve this, you should use the data directly from the data source rather than fetch it from Flexmonster. If you want to replicate the layout displayed in Flexmonster, you can use the getReport method to retrieve the current settings. The report would only serve as a configuration reference, while the export procedure should be implemented on your end.

Please let us know if any questions arise.

Best Regards,
Maksym

Please login or Register to Submit Answer