Loading

C# DATAGRIDVIEW IMAGES NOT EXPORTED TO EXCEL

C# DATAGRIDVIEW IMAGES NOT EXPORTED TO EXCEL

Legent Mady

9y1.8k

i am using vs2015

export to gridview my datagridview1 columns are regno,name,image

my code is..

private void copyAlltoClipboard()

{

dataGridView1.SelectAll();

DataObject dataObj = dataGridView1.GetClipboardContent();

if (dataObj != null)

Clipboard.SetDataObject(dataObj);

}

private void button3_Click_1(object sender, EventArgs e)

{

copyAlltoClipboard();

Microsoft.Office.Interop.Excel.Application xlexcel;

Microsoft.Office.Interop.Excel.Workbook xlWorkBook;

Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;

object misValue = System.Reflection.Missing.Value;

xlexcel = new Excel.Application();

xlexcel.Visible = true;

xlWorkBook = xlexcel.Workbooks.Add(misValue);

xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

Excel.Range CR = (Excel.Range)xlWorkSheet.Cells[1, 1];

CR.Select();

xlWorkSheet.PasteSpecial(CR, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, true);

}

image column is empty on excel sheet

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Madhanmohan Devarajan9y ago
PasteSpecial is the place you need to concentrate.

Also please provide the respective type values (parameters) for the function PasteSpecial.

Your code:
xlWorkSheet.PasteSpecial(CR, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, true);

Why CR is passed as parameter ? Because Format has to be provided as parameter as shown in Example not the cell range (CR). How about other parameters "Type.Missing" ? what are the values you are those values?

The actual parameters should be:
xlWorkSheet.PasteSpecial( Object Format, Object Link, Object DisplayAsIcon, Object IconFileName, Object IconIndex, Object IconLabel, Object NoHTMLFormatting )

Ex:
xlWorkSheet.PasteSpecial( "HTML", False, False)

Please try this, It should work.
0
Legent Mady9y ago
please explain...
in my code..... with your code
0
Madhanmohan Devarajan9y ago
xlWorkSheet.PasteSpecial(CR, true);
// Since all the parameters are optional, you don't need to give those if you don't have any values.

Here is the syntax for the PasteSpecial given in the microsoft site.
void PasteSpecial( Object Format, Object Link, Object DisplayAsIcon, Object IconFileName, Object IconIndex, Object IconLabel, Object NoHTMLFormatting )
https://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel._worksheet.pastespecial.aspx
0