Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
135
Insert Picture on Excel Export
posted
Hi, I need to export a list in Excel with nested picture inside ... If i use the normal export procedure with Header change in the excel file i find the right picture but not in line with the data . If I use the Infragistics

UltraWebGridExcelExporter

 The result it's to have the html code in the Cell ... like this

<img src='C:\Progetti\SpinnakerNetInf\ObjImg\762008/img029.jpg' width=110 Height=73>

Could you please tell me if there is some specific command to give to the row to export immage?

Or Ho can nested the picture on Excel export ?

 Thank you

Alessandro

Parents
No Data
Reply
  • 44743
    posted

    Currently, images must be manually exported by creating a WorksheetImage instance. If you want to position the image inside a cell, you can call GetBoundsInTwips() on a WorksheetCell instance. Pass the returned Rectangle to the SetBoundsInTwips method on the WorksheetImage. Then add the WorksheetImage to the Shapes collection on the Worksheet. Use the overload of SetBoundsInTwips which takes a maintainAspectRatio boolean parameter to make sure the image is not distorted.

Children