Get Free Trial

Exporting pivot table with Image to Excel/PDF

Rejesh K R asked on January 17, 2019

Hi Team,
We have generated a pivot report with image in the values using cell customization.
While export the same report to excel/pdf the image cells are generated as blank. Could you please support us to resolve the issue.

3 answers

Iryna Kulchytska Iryna Kulchytska Flexmonster January 17, 2019

Hi Rejesh,
Thank you for posting your question on the forum.
Export to Excel and to PDF do not export images added by customizeCell.
We would like to suggest you a workaround for the reports with images in value cells. Starting from version 2.6.12 there is a useCustomizeCellForData property for Excel export which allows enabling and disabling customizeCell formatting for data cells. If you set the useCustomizeCellForData property to false in exportTo() API call, as follows: 

flexmonster.exportTo('excel', {useCustomizeCellForData: false});

then the Excel file will contain the underlying data in value cells.
Here is a JSFiddle sample:
This property is not available for Export to PDF right now, but it can be added.
Please let us know if the above approach for Export to Excel works for you.
Kind regards,

Rejesh K R January 18, 2019

Hi Iryna,
Thanks for you valuable update.
Is it possible to export the generated image to excel/PDF?
Rejesh K R

Tanya Gryshko Tanya Gryshko Flexmonster January 21, 2019

Hello, Rejesh,
Thank you for sharing your feedback.
We would like to inform you that images added using cell customization are not exported. This request is added to our backlog. However, we are not ready to provide you with an estimated timeframe for this feature.
Please let me know in case of any other questions.

Please login or Register to Submit Answer