How to open and read existing Excel

[ansrikanth]

Hi all,

Can any one of you guide me how to resolve this error..

Iam having an excel sheet (Office 97) in my c: drive (C:\test.xls) I have to open that excel and read the internal data..this is my task..
So, I have added an excel8.0 object reference to my project and placed the code..

but i got the fallowing error which iam not able to understand/resolve from long time..
Attachment
Please help me..early help in this regard will be greatly appreciated...

thank you,

Regards,
Srikanth

[shweta123]

Hi,
Please try this code

Dim myexcel As Excel.Application
Dim aWorkbook As Excel.Workbook
Dim strExcelFile As String = "C:\Book1.xls"

If Not IO.File.Exists(strExcelFile) Then Return
myexcel = New Excel.Application
aWorkbook = myexcel.Workbooks.Open(strExcelFile)
myexcel.Visible = True


Shweta

[ansrikanth]

Sorry dear....no use....

but..found some thing different...

The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)) ....bla..bla...


Thank you,

Regards
Srikanth