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???

[Alexey Smirnov]

<dm********@gmail.comwrote in message
news:11**********************@v33g2000cwv.googlegr oups.com...

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.ServerVari ables("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...DataReader.asp

<dm********@gmail.comwrote in message
news:11**********************@v33g2000cwv.googlegr oups.com...

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???

[Mark Rae]

"Alexey Smirnov" <al************@gmail.comwrote in message
news:u$**************@TK2MSFTNGP03.phx.gbl...

<dm********@gmail.comwrote in message
news:11**********************@v33g2000cwv.googlegr oups.com...

>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.ServerVari ables("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...US;q257757#kb2