Unable to cast COM object of type 'Microsoft.Office.Interop.

Question

Hi,
I am getting this error while i export and import the excel file in the office 2003 format.
The error is:
Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)).
this is the code i wrote,

Microsoft.Office.Interop.Excel.Application objApplication = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel._Workbook workbook = objApplication.Workbooks.Add(Type.Missing);
Microsoft.Office.Interop.Excel.Sheets xlSheets = workbook.Worksheets;
Microsoft.Office.Interop.Excel._Worksheet worksheet = null;

Please any one help me for this problem...

Imtiyaz Ansari · Answer

congrats Moorthy ...

moorthy subramani · Answer

Hi, Imtiyaz Ansari, i got solutoin for this problem. I just delete the Key from the Registry Editor and it's working now. The Procedure is: Start--> Run --> regedit & HKEY_CLASSES_ROOT-->TypeLib-->{00020813-0000-0000-C000-000000000046} --> 1.8(Delete one) I Delete that 1.8 Key. Now it's working fine.

moorthy subramani · Answer

Hi Mohan Dass , I think it's because of installation of Office 2007. Just try to re-Install and then try to export and import the file.

Mohan Dass · Answer

Hi Moorthy, I too facing the same issue as you faced. I am getting below error message when i am trying to create Excel workbook in my code. I am trying to creaet Excel 2007 application. "Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))." as you told i checkd the registy i found only one enty under the key "000208D5-0000-0000-C000-000000000046". My Code is : Excel.Application app = new Excel.Application(); app.Visible = true; Excel.Workbook newWorkbook = app.Workbooks.Add(1); Excel.Worksheet xlWorkSheet = (Excel.Worksheet)newWorkbook.Sheets[1]; Thanks & Regards Mohan Dass.P So i don't know where to delete the key. Please help on this.

moorthy subramani · Answer

Hi, Imtiyaz Ansari, Thank you very much..

moorthy subramani · Answer

Hi, Imtiyaz Ansari My Application is working in 2007 format. Its not supporting in 2003. I need to run in 2003 format only. My Application was too large, so i update the click event below. Please give me the solution for this. private void btnExportToEx_Click(object sender, EventArgs e) { advTree1_BeforeNodeSelect(sender, null); System.Globalization.CultureInfo Oldci = System.Threading.Thread.CurrentThread.CurrentCulture; System.Threading.Thread.CurrentThread.CurrentCulture = new CultureInfo("en-us"); Microsoft.Office.Interop.Excel.Application objApplication; Microsoft.Office.Interop.Excel.Workbook workbook; Microsoft.Office.Interop.Excel.Worksheet worksheet; object misValue = System.Reflection.Missing.Value; objApplication = new Microsoft.Office.Interop.Excel.Application(); workbook = objApplication.Workbooks.Add(misValue); worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets.get_Item(1); worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Sheets[1]; worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.ActiveSheet; Microsoft.Office.Interop.Excel.Range oRng; oRng = worksheet.get_Range("A1", "I1"); worksheet.Name = "Exported"; try { ExportSheetDataList(); GetValuesToExcel(dtsFileData, worksheet); string strFileName = SaveFile(m_ResourceManager.GetString("Sheets")); if (String.IsNullOrEmpty(strFileName)) return; workbook.SaveAs(strFileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal); System.Threading.Thread.CurrentThread.CurrentCulture = Oldci; MessageBoxEx.Show(m_ResourceManager.GetString("ExportSucc"), m_ResourceManager.GetString("SSMPropEditor"), MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { if (!(worksheet == null)) System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet); workbook.Close(false); objApplication.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook); workbook = null; System.Runtime.InteropServices.Marshal.ReleaseComObject(objApplication); objApplication = null; } }

Imtiyaz Ansari · Answer

Hi moorthy subramani this code are used in office 2007 format. so try this code in office 2007... or sent your form (page ) solve your problam... email id :- ansariimtiyaz10@gmail.com

moorthy subramani · Answer

Hi, Imtiyaz Ansari, I tried this code, but still i am facing the same error while i run the application. Please can u give some other solution for my problem.. This is the code: Microsoft.Office.Interop.Excel.Application objApplication; Microsoft.Office.Interop.Excel.Workbook workbook; Microsoft.Office.Interop.Excel.Worksheet worksheet; object misValue = System.Reflection.Missing.Value; objApplication = new Microsoft.Office.Interop.Excel.Application(); [i am getting the error in this below line]: workbook = objApplication.Workbooks.Add(misValue); worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets.get_Item(1);

Imtiyaz Ansari · Answer

try this code:- firstly folling refarence add Microsoft.Office.Interop.Excel Microsoft.Office.Interop.Word this code are used gridview data create excel file try { string filename1 = "Damage Product List"; filename1 = "D:\Report\" + filename1 + ".xls"; Microsoft.Office.Interop.Excel.Application xlApp; Microsoft.Office.Interop.Excel.Workbook xlWorkBook; Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet; object misValue = System.Reflection.Missing.Value; xlApp = new Microsoft.Office.Interop.Excel.ApplicationClass(); xlWorkBook = xlApp.Workbooks.Add(misValue); xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); int i = 0; int j = 0; for (j = 0; j { xlWorkSheet.Cells[1, j + 1] = dataGridView1.Columns[j].Name; } for (i = 0; i { for (j = 0; j { DataGridViewCell cell = dataGridView1[j, i]; xlWorkSheet.Cells[i + 2, j + 1] = cell.Value; } } xlWorkBook.SaveAs(filename1, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); xlWorkBook.Close(true, misValue, misValue); xlApp.Quit(); MessageBox.Show("Excel file created , you can find the file"); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); return; }