Read data from special format Excel with ASP

Discussion in 'ASP General' started by Vanessa, Nov 10, 2005.

  1. Vanessa

    Vanessa Guest

    I need to read/extract data from an Excel file using ASP. However, the Excel
    file is not in regular tabular format; instead, it is actually a form.
    Therefore, it contains many checkbox and merged cells with data.

    I have followed this web page's instruction
    (http://www.haneng.com/Forums_Post.asp?id=4099) to read data out, but
    whenever the cell has checkbox or it is a merged cell, it can't read the
    data.

    Is there anyway to read data from Excel file which contains checkbox and
    merged cells? Thanks!
    Vanessa, Nov 10, 2005
    #1
    1. Advertising

  2. Vanessa

    AlanM Guest

    "Vanessa" <> wrote in message
    news:...
    >I need to read/extract data from an Excel file using ASP. However, the
    >Excel
    > file is not in regular tabular format; instead, it is actually a form.
    > Therefore, it contains many checkbox and merged cells with data.
    >
    > I have followed this web page's instruction
    > (http://www.haneng.com/Forums_Post.asp?id=4099) to read data out, but
    > whenever the cell has checkbox or it is a merged cell, it can't read the
    > data.
    >
    > Is there anyway to read data from Excel file which contains checkbox and
    > merged cells? Thanks!


    A suggestion

    although your date is in a form and in textboxes, you could have a hidden
    table in the excel sheet somewhere holding eth same data that would be
    easier to use,
    AlanM, Nov 10, 2005
    #2
    1. Advertising

  3. Vanessa

    Vanessa Guest

    Alan,
    That's a great idea! Thanks!

    "AlanM" wrote:

    >
    > "Vanessa" <> wrote in message
    > news:...
    > >I need to read/extract data from an Excel file using ASP. However, the
    > >Excel
    > > file is not in regular tabular format; instead, it is actually a form.
    > > Therefore, it contains many checkbox and merged cells with data.
    > >
    > > I have followed this web page's instruction
    > > (http://www.haneng.com/Forums_Post.asp?id=4099) to read data out, but
    > > whenever the cell has checkbox or it is a merged cell, it can't read the
    > > data.
    > >
    > > Is there anyway to read data from Excel file which contains checkbox and
    > > merged cells? Thanks!

    >
    > A suggestion
    >
    > although your date is in a form and in textboxes, you could have a hidden
    > table in the excel sheet somewhere holding eth same data that would be
    > easier to use,
    >
    >
    >
    Vanessa, Nov 10, 2005
    #3
    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. sajithkahawatta

    read a excel sheet using aspose.excel

    sajithkahawatta, Apr 19, 2007, in forum: ASP .Net
    Replies:
    3
    Views:
    520
    Steve C. Orr [MCSD, MVP, CSM, ASP Insider]
    Apr 19, 2007
  2. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,482
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  3. Girish
    Replies:
    0
    Views:
    387
    Girish
    Feb 13, 2004
  4. anujgupta872003

    Read Custom format of Excel

    anujgupta872003, Jan 5, 2012, in forum: Java
    Replies:
    0
    Views:
    313
    anujgupta872003
    Jan 5, 2012
  5. Md Rafiq
    Replies:
    0
    Views:
    113
    Md Rafiq
    May 6, 2009
Loading...

Share This Page