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)?
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
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?
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