Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > asp excel

Reply
Thread Tools

asp excel

 
 
magix
Guest
Posts: n/a
 
      03-23-2007
I try to use asp to extract excel data. if the item field in excel is empty,
can I use "" to represent empty ?

will this (" ") work ?
rs("Item") = ""

rs.open "SELECT * FROM [Sheet1$]", oConn
do until rs.EOF
if rs("Item") = "" then
emptyfield = true
else
emptyfield = FALSE
end if
rs.movenext
Loop


 
Reply With Quote
 
 
 
 
ThatsIT.net.au
Guest
Posts: n/a
 
      03-24-2007
Without making a connection and testing it, I would think yes.

if not try Trim(rs("Item")) = ""
or even Trim(Cstr(rs("Item"))) = ""

or maybe rs("Item") = null



--
Dim Alan as ThatsIT.net.au.Staffmember
Alan.signature = "Thank You"
Response.Write Alan.signature.toString()
__________________________________________

"magix" <(E-Mail Removed)> wrote in message
news:46043574$(E-Mail Removed)...
>I try to use asp to extract excel data. if the item field in excel is
>empty, can I use "" to represent empty ?
>
> will this (" ") work ?
> rs("Item") = ""
>
> rs.open "SELECT * FROM [Sheet1$]", oConn
> do until rs.EOF
> if rs("Item") = "" then
> emptyfield = true
> else
> emptyfield = FALSE
> end if
> rs.movenext
> Loop
>


 
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
From an ASP page, is there a way write to an EXCEL file without having EXCEL installed on the IIS machine ? fniles ASP General 6 04-27-2009 10:33 PM
How to return an excel file or excel data from ASP.NET Anonieko ASP .Net 2 02-12-2008 07:03 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
Export to excel in asp.net using excel template Grey ASP .Net 4 10-17-2007 08:08 AM
asp.net extracting excel charts from an Excel file Robbe Morris [C# MVP] ASP .Net 0 12-15-2006 03:03 AM



Advertisments