exporting images from datagridview into excel

See more:

VB

SQL-Server-2008

Hi Guys,

Just a quick question.

I've compiled some code together that is retrieving all the item info with pictures into a datagridview, that's now coming through successfully, but i've hit a brick wall. when you click a button all the info without the pictures get extracted to an excel worksheet, if anyone could shed some light on this i would be very happy as i would like the images to be extracted as well.

For i = 1 To frmPastelItems.DGItems.RowCount - 1
            For j = 0 To frmPastelItems.DGItems.ColumnCount - 1
                If frmPastelItems.DGItems(j, i).Value.ToString() = "System.Drawing.Bitmap" Then
'this is where i'm stuck though, i'm trying to get the image out of the datagridview column and into the cell in the worksheet
                    Dim imgarray As Byte() = frmPastelItems.DGItems(j, i).Value
                    Dim memorystream As IO.MemoryStream = New IO.MemoryStream(imgarray, False)
                    imgPath = Image.FromStream(memorystream)

                    xlWorkSheet.Cells(i + 1, j + 1) = imgPath
                Else
'this section is working fine and filling the worksheet nicely
                    xlWorkSheet.Cells(i + 1, j + 1) = frmPastelItems.DGItems(j, i).Value.ToString()
                End If
            Next

        Next