Export RichText Column to Excel

[Albert K]

Hi,

I would like to know if it is possible to an Excel export a Grid with a column where the data is created by the Rich Text Control.  This control has formatted Text as well as embedded photo.

Thank you.

[Santhosh Iruthayaraj]

Hi Albert K,

Greetings from Syncfusion Support.

We have reviewed your query regarding the export of formatted rich text with embedded images from a Grid column to Excel. Unfortunately, exporting formatted content that includes embedded images from the Grid to Excel is not feasible.

However, it is possible to export the formatted rich text in one column and the image in another column. The Excel export library supports exporting formatted rich text by default. To export an image in a separate column, you can use the “excelQueryCellInfo” event of the Grid and assign the base64 string of the image.

Please find the code snippet and sample below for your reference:

[app.component.ts]

 

  excelQueryCellInfo(args) {

    if (args.column.headerText === 'Employee Image') {

      args.image = {

        height: 75,

        width: 75,

        base64: args.data.EmployeeImage,

      };

    }

  }

 

Sample: https://stackblitz.com/edit/angular-grid-u7mdtf-7ci66xzw

For more details regarding the export of images, hyperlinks, and customized text, please refer to the following documentation:

Documentation: Exporting Templates in Angular Grid control | Syncfusion

Please let us know if you need any further assistance.

Regards,

Santhosh I

[Albert K]

Thanks, Is there any other way around this, as separating the text from the image in a rich text input does not make sense in my use case.  Is there a way to convert the RichText data in to a image ?  

Is export of Grid with RichText (text and image) to PDF a possible ?

Is there plan to support RichText with text and image export to Excel? 

[Santhosh Iruthayaraj]

Hi Albert K,

Currently, we don’t have built in support to export the HTML grid data to Excel/PDF. Therefore, it is not feasible to achieve your requirement. However, we have already confirmed the requested requirement as an improvement from our side and logged a feature request for the same as “Support for exporting HTML grid data into Excel document”. At the planning stage for every release cycle, we review all open features and identify features for implementation based on specific parameters including product vision, technical feasibility, and customer interest. And this feature will be included in any of our upcoming releases.

You can now track the status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.    

Feedback Link:https://www.syncfusion.com/feedback/7058/support-for-exporting-html-grid-data-into-excel-document

We are moving this thread to solved for now. You can also communicate with us regarding the open features any time using our above Feature Report page or reopen the incident.

Regards,

Santhosh I