Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Read data from special format Excel with ASP

Reply
Thread Tools

Read data from special format Excel with ASP

 
 
Vanessa
Guest
Posts: n/a
 
      11-10-2005
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!
 
Reply With Quote
 
 
 
 
AlanM
Guest
Posts: n/a
 
      11-10-2005

"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,


 
Reply With Quote
 
 
 
 
Vanessa
Guest
Posts: n/a
 
      11-10-2005
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,
>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
User Entered Data(Read Only Data) to Excel Md Rafiq Ruby 0 05-06-2009 04:01 PM
How to return an excel file or excel data from ASP.NET Anonieko ASP .Net 2 02-12-2008 07:03 PM
Excel: NZ phone number special format? Boppy NZ Computing 10 01-05-2008 09:26 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
(XML) HTTP(S) in the Auto-lead Data Format (ADF) 1.0. HOW DO I READ THE DATA? Girish ASP General 0 02-13-2004 12:46 AM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57