Getting a error when Opening excel sheet on C#

diya

Hi.....

I am using MS office 2003 and Visual studio 2008 .I have added a reference to Microsoft.Office.Interop.Excel 11.0 library .

Added the following code:

private void button1_Click(object sender, EventArgs e)
        {
            object format = 5;//Nothing value.

            ApplicationClass xlApp = new ApplicationClass();
            Workbook xlBook = xlApp.Workbooks.Open("D:\\WORKS\\App\\bin\\Debug", 0, false, format, null, null, false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, null, true, false, 0, true, false, false);
            Sheets xlSheets = xlBook.Worksheets;
            Worksheet xlSheet = (Worksheet)xlSheets.get_Item("Sheet1"); // open Sheet1.
            xlApp.Visible = true;
        }

Getting the error:

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: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

Plz.. help me to solve this error

3 Replies

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

Amit Choudhary16y ago
Accepted answer
hi diya,

you can add the microsoft interop dll by downloading it from microsoft website no need to install the MS-Office
add the downloaded dll to your bin folder and be free from worry..
Download links are here:
1. For office 2003
2. For office 2007

Don't forget to mark as answer.

diya16y ago

Hi......

Thank u

   yes it is file name here:

    Workbook xlBook = xlApp.Workbooks.Open(filename

But stil getting the same error:

 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: Error loading type library/DLL. (Exception from
HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).



I dont think there is a pblm in the code, bcz.. it is work in other
systems. i think some dll are missing while installation of ms office.I
need a help on this basis..


I have added reference to Microsoft.Office.Interop.Excel 11.0 library .. but the dll is not appearing on bin\\ debug folder of my application



thanku

Amit Choudhary16y ago
hi diya..

i have doubt on the following line:
Workbook xlBook = xlApp.Workbooks.Open("D:\\WORKS\\App\\bin\\Debug"
Here it should be the file name. Not the directory name.... if error still persists then tell me..
Else if solved then mark as answer.