Exporting Datagridview data with Images to Excel...

Hi Everyone,

I have datagridview in that 17 columns are text columns and 5 columns are Image columns,when I'm trying to export whole gridview data's along with images to EXCEL,getting "HRESULT: 0x800A03EC" Error..While debugging the code I'm getting the error on image column not able to export..
Can anybody help us to resolve this issue..

Here is my code which i used:

private void btnexportexcel_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog savefile = new SaveFileDialog();
savefile.Filter = "Excel (*.xls)|*.xls";
if (savefile.ShowDialog() == DialogResult.OK)
{
if (!savefile.FileName.Equals(string.Empty))
{
FileInfo finfo = new FileInfo(savefile.FileName);
if (finfo.Extension.Equals(".xls"))
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;

xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(2) ;
int i = 0;
int j = 0;

for (i = 0; i <= dataGridView1.RowCount - 1; i++)
{
for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)
{
DataGridViewCell cell = dataGridView1[j, i];
xlWorkSheet.Cells.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
xlWorkSheet.Columns.AutoFit();

if (cell.Value.GetType() == typeof(Bitmap))
{
string image =Convert.ToString(dataGridView1.CurrentRow.Cells[i].Value);
Excel.Range oRange = (Excel.Range)xlWorkSheet.Cells[i + 1, j + 1];
float Left = (float)((double)oRange.Left);
float Top = (float)((double)oRange.Top);
const float ImageSize = 32;
xlWorkSheet.Shapes.AddPicture(image, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, Left, Top, ImageSize, ImageSize);
oRange.RowHeight = ImageSize + 2;
}
else
{
xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;
}

}
}

xlWorkBook.SaveAs(savefile.FileName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue,
Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();

releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);

MessageBox.Show("Excel file created , you can find the file " + savefile.FileName);

}
else
{
MessageBox.Show("Invalid file type");
}
}
else
{
MessageBox.Show("You did pick a location " + "to save file to");
}
}
}

catch (Exception ex)
{
MessageBox.Show("Exception Occured", ex.Message);
}
}

4 Replies

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

Shalini rajendran11y ago
Here is the Stack Trace: System.Runtime.InteropServices.COMException was caught HResult=-2146827284 Message=Exception from HRESULT: 0x800A03EC Source="" ErrorCode=-2146827284 StackTrace: at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData) at Microsoft.Office.Interop.Excel.Range.set__Default(Object RowIndex, Object ColumnIndex, Object value) at Finance_Project.Customer_View.btnexportexcel_Click(Object sender, EventArgs e) in d:\Visual Studio 2012\Finance_Project\Finance_Project\Customer_View.cs:line 387 InnerException:
dinesh kumar11y ago
That's ok could you post the stack trace. because these exception normally happens when opening an older versions of xls workbook opened in Excel 2007 or 2010.
Shalini rajendran11y ago
Here I can not express all the code itseems,the code which i exposed has written under "ExportExcelbutton_Click" method... Here is the line were I'm getting exception.. if(cell.value.GetType()==typeof(Bitmap)) { }
dinesh kumar11y ago
Can you please attach any sample ? it might be easy to debug rather than examining code.