Exporting pivot table with Image to Excel/PDF

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.
Thanks
Rejesh 

3 answers

Public
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: https://jsfiddle.net/flexmonster/38Lqymzp/
 
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,
Iryna

Public
Rejesh K R January 18, 2019

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

Public
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.
Regards,
Tanya

Please login or Register to Submit Answer