«

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" <> wrote in message
news:5950C833-BE22-4011-A2CF-...
>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,

Alan,
That's a great idea! Thanks!

"AlanM" wrote:

>
> "Vanessa" <> wrote in message
> news:5950C833-BE22-4011-A2CF-...
> >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,
>
>
>