Read data from special format Excel with ASP

V

Vanessa

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

AlanM

Vanessa said:
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,
 
V

Vanessa

Alan,
That's a great idea! Thanks!

AlanM said:
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,
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,901
Latest member
Noble71S45

Latest Threads

Top