Hi,
I am using win UltraGrid to export table in excel. My problem is when I am trying to export Image column in excel sheet. its not being exported.
In the excel, Column shows "System.Drawing.Bitmap".
I'm wondering if there is a way to export image in excel. Please help me ASAP
You must add the shape to the Worksheet at the end of your method:
e.CurrentWorksheet.Shapes.Add(eImg);
I'm having a little trouble getting this working. I've done the below and it all seems to "work" in that I get no exceptions etc., but no images are on the spreadsheet. I noticed that in my eImg object, the worksheet property is null - does this need setting somehow?
void
if (e == null) return;
if (e.GridColumn.Key == "BTImage")
{
Infragistics.Win.UltraWinGrid.
];
System.Drawing.
PlaceImage(bmp, e);
}
{ }
Infragistics.Excel.
eImg.TopLeftCornerCell = e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[e.CurrentColumnIndex];
eImg.BottomRightCornerCell = e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[e.CurrentColumnIndex];
eImg.TopLeftCornerPosition =
eImg.BottomRightCornerPosition =
eImg.PositioningMode = Infragistics.Excel.
Unfortunately, support for images was not added to the Excel assembly until version 7.2. You will need to upgrade to be able to use this feature.
Hi I'm trying to add an image to a worksheet but have no luck. I have read several posts on the infragistics forums but none of them use Excel engine in the 7.1 release. Can someone assist me in adding an image to worksheet in this specific version? I’ve tried the WorksheetImage but this is not available in the current version that I’m using. Any suggestions welcome.
Thank you very much. I have impleted with your idea and working fine.