how to fetch data from excel sheet

Discussion in 'ASP .Net' started by dmshah01in@gmail.com, Feb 7, 2007.

  1. 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???
    , Feb 7, 2007
    #1
    1. Advertising

  2. <> wrote in message
    news:...
    > 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
    Alexey Smirnov, Feb 7, 2007
    #2
    1. Advertising

  3. sloan Guest

    sloan, Feb 7, 2007
    #3
  4. Mark Rae Guest

    "Alexey Smirnov" <> wrote in message
    news:u$...

    > <> wrote in message
    > news:...
    >> 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


    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
    Mark Rae, Feb 7, 2007
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. zxo102
    Replies:
    3
    Views:
    3,246
    Stuart Corrie
    Aug 9, 2005
  2. sajithkahawatta

    read a excel sheet using aspose.excel

    sajithkahawatta, Apr 19, 2007, in forum: ASP .Net
    Replies:
    3
    Views:
    524
    Steve C. Orr [MCSD, MVP, CSM, ASP Insider]
    Apr 19, 2007
  3. Deepa Rajendran

    Fetch an excel sheet name in ruby

    Deepa Rajendran, Feb 24, 2009, in forum: Ruby
    Replies:
    4
    Views:
    108
    Hannes Wyss
    Feb 24, 2009
  4. Deepa Rajendran

    Fetch an excel sheet name in ruby

    Deepa Rajendran, Feb 24, 2009, in forum: Ruby
    Replies:
    0
    Views:
    79
    Deepa Rajendran
    Feb 24, 2009
  5. Deepa Rajendran

    Fetch an excel sheet name in ruby

    Deepa Rajendran, Feb 24, 2009, in forum: Ruby
    Replies:
    2
    Views:
    134
    Deepa Rajendran
    Feb 25, 2009
Loading...

Share This Page