SfDataGrid Image Column Export

[yapwen]

Hi,

How to Export the image data in the image column in SfDataGrid .

Attached is the sample shown SfDataGrid export to excel with data except image data.

Thanks.

Regards,

Yap

Attachment: SfDataGridExport_155d0c52.zip

[Elavarasan M]

Hi Yap, 

Thank you for contacting Syncfusion support. 

We have analyzed your query and prepared the sample to export GridImageColumn into Excel as well as PDF.  

 

Please find the sample from below, 

Sample: http://www.syncfusion.com/downloads/support/forum/124770/ze/SfDataGrid_Sample-1134020668 

 

Note: You have to set the UseBindingValue to the column as true when loading Image through converter and the underlying property of GridImageColumn is string. Otherwise you have to set the GridImageColumn underlying property as  BitMapImage instead of string.  

You can refer the below UG documentation to know more about the excel exporting, 

http://help.syncfusion.com/wpf/sfdatagrid/export-to-excel 

Also refer the below UG documentation to know more about the PDF exporting, 

http://help.syncfusion.com/wpf/sfdatagrid/export-to-pdf 

You can also refer the below KB to know about the GridTemplateColumn PDF exporting, 

https://www.syncfusion.com/kb/3447/how-to-export-images-which-is-loaded-inside-the-gridtemplatecolumn-to-pdf-document 

Regards, 

Elavarasan M

[yapwen]

Hi Elavarasan,

Thanks for reply.

Attached is the excel file from exported. Its look a bit messy.

How to make the row height as shown in SfDataGrid for exported excel file.

Thanks Elavarasan.

Regards,

Yap

Attachment: Excel_Row_Height_3351a832.zip

[Elavarasan M]

Hi Yap, 

 

Thanks for your reply. 

 

You can change the entire row height and the column width while exporting the SfDataGrid to excel like the below code example, 

 

var options = new ExcelExportingOptions(); 

ExcelEngine excelEngine = new ExcelEngine(); 

IWorkbook workBook = excelEngine.Excel.Workbooks.Create(); 

workBook.Worksheets.Create(); 

options.ExportMode = ExportMode.Text; 

this.dataGrid.ExportToExcel(dataGrid.View, options, workBook.Worksheets[0]);             

workBook.Worksheets[0].Range.RowHeight = 70; 

 

workBook.Worksheets[0].Range.ColumnWidth = 100; 

 

You can also set the particular row height and particular column width like the below code example, 

 

workBook.Worksheets[0].SetColumnWidth(1, 30); 

 

workBook.Worksheets[0].SetRowHeight(1, 30); 

 

We have modified the sample based on this and please find the sample from below, 

 

Sample: http://www.syncfusion.com/downloads/support/forum/124770/ze/SfDataGrid_Sample1099366103 

 

 

You can refer the below UG documentation to know about the row height and column width customization while exporting the SfDataGrid, 

 

http://help.syncfusion.com/wpf/sfdatagrid/export-to-excel#row-height-and-column-width-customization 

 

Regards, 

Elavarasan M

[yapwen]

Dear Elavarasan,

Thanks for reply.

Thank you.

Regards,

Yap

[Elavarasan M]

Hi Yap,

Thank you for your update.

Please let us know if you require any other assistance.

Regards, 

Elavarasan M