how to fetch data from excel sheet

[dmshah01in]

hi.
i am new to .net
i need to fetch data from excel sheet and display it on web page.
please help me how to do this???

 

[Guest]

hi.
i am new to .net
i need to fetch data from excel sheet and display it on web page.
please help me how to do this???

look for "excel" in the group

most recent example:

Dim oExcel As Excel.Application
oExcel = New Excel.Application
Dim oWorkbook As Excel.Workbook
oWorkbook =
oExcel.Workbooks.Open(Filename:=Request.ServerVariables("APPL_PHYSICAL_PATH")
& "otrapruebamas.xls") 'This line generates the exception
Dim x As String = oWorkbook.Worksheets(1).Range("A1").Value

 

[sloan]

You would do better to use an IDataReader, and a OLE DB provider.

http://support.microsoft.com/kb/306572/

Also see:
http://www.codeproject.com/useritems/Excel_DataReader.asp

 

[Mark Rae]

look for "excel" in the group

most recent example:

Dim oExcel As Excel.Application
oExcel = New Excel.Application
Dim oWorkbook As Excel.Workbook
oWorkbook =
oExcel.Workbooks.Open(Filename:=Request.ServerVariables("APPL_PHYSICAL_PATH")
& "otrapruebamas.xls") 'This line generates the exception
Dim x As String = oWorkbook.Worksheets(1).Range("A1").Value

Please don't advise people to use server-side Office automation - it is not
designed to work this way:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2