Error 115 Type 'Excel.IExcelDataReader' is not defined

Question

I have a vb.net application with excel export and import. I am not much familiar with this application as my ec-colleague left this to me without much information. Now when i am trying to build the application its showing the following error

Error   115 Type 'Excel.IExcelDataReader' is not defined.   E:\CManager\CManager\\Win764\CManager\MyApp.vb  2376    28  ContributionManager

I tried to get its dll but couldnt find any.

Can anybody please help on this...

its may be some third party tools for excel files.check if some dll is missing. — akhil kumar, Feb 04 '15 at 08:33
@akhilkumar yes it is. But whenever i am trying to add dlls its saying its already existing in the solution — TechNo, Feb 04 '15 at 08:42
please remove all the existing dlls realted to exceldatareader and add once more.it may be because of different versions. — akhil kumar, Feb 04 '15 at 08:46

score 1 · Answer 1 · answered Feb 04 '15 at 11:25

so.. first
Add Referente to your Project to Microsoft.Office.Interop, in COM section

in your Form

 Imports Microsoft.Office.Interop.Excel
 Imports Microsoft.Office.Interop

and use

    Dim xlApp As Microsoft.Office.Interop.Excel.Application
    Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook
    Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet

 xlApp = New Microsoft.Office.Interop.Excel.Application
 xlWorkSheet = xlWorkBook.Sheets("sheet1")

'write sometring on sheet
'and savt it !

   xlWorkSheet.SaveAs("D:\Reports\" & worker & Id & ".xlsx")

    xlWorkBook.Close()
    xlApp.Quit()

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

score 0 · Answer 2 · answered Feb 04 '15 at 08:28

0

ExcelDataReader

...btw. Have you ever heard of that google thingy ;)

answered Feb 04 '15 at 08:28

David Sdot

2,343
1
20
26

score 0 · Accepted Answer · answered Feb 04 '15 at 10:54

0

Removed the existing dlls and added once again! its resolved

answered Feb 04 '15 at 10:54

TechNo

615
2
7
24

Error 115 Type 'Excel.IExcelDataReader' is not defined

3 Answers3