Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Problem with cell and hyperlink - ASP

Reply
Thread Tools

Problem with cell and hyperlink - ASP

 
 
mapoart@gmail.com
Guest
Posts: n/a
 
      12-06-2007
Hi,
I'm using pure ASP/VBscrtipt.
I spent days to looking for solution to take hyperlink cell from excel
file.

i'm using this kind of think to take the data out...

sFileConnectionString = "Driver={Microsoft Excel
Driver .xls)};DriverId=790;Dbq="&sFilePath&";DefaultDir=" &sDataDir&";"
sFileSQL = "SELECT * FROM [" & sSheetName & "$]"
dim oFileCN, oFileRS, aSourceData
set oFileCN = server.createobject("ADODB.Connection")
oFileCN.Open sFileConnectionString
set oFileRS = oFileCN.Execute(sFileSQL)
if not oFileRS.EOF then
aSourceData = oFileRS.getRows()
end if
oFileRS.Close
set oFileRS = nothing
oFileCN.Close
set oFileCN = nothing

Could you help me?

Mapo
 
Reply With Quote
 
 
 
 
Mike Brind
Guest
Posts: n/a
 
      12-07-2007

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
> I'm using pure ASP/VBscrtipt.
> I spent days to looking for solution to take hyperlink cell from excel
> file.
>
> i'm using this kind of think to take the data out...
>
> sFileConnectionString = "Driver={Microsoft Excel
> Driver .xls)};DriverId=790;Dbq="&sFilePath&";DefaultDir=" &sDataDir&";"
> sFileSQL = "SELECT * FROM [" & sSheetName & "$]"
> dim oFileCN, oFileRS, aSourceData
> set oFileCN = server.createobject("ADODB.Connection")
> oFileCN.Open sFileConnectionString
> set oFileRS = oFileCN.Execute(sFileSQL)
> if not oFileRS.EOF then
> aSourceData = oFileRS.getRows()
> end if
> oFileRS.Close
> set oFileRS = nothing
> oFileCN.Close
> set oFileCN = nothing
>
> Could you help me?
>


Help with what? You don't actually say what the problem is. If it's
getting the result to display as a hyperlink on a web page, then you will
need to use the value to build an html hyperlink. Hyperlink cells in Excel
contain just text.

--
Mike Brind


 
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
How to add a hyperlink column to asp.net datagrid - where only one value is a hyperlink davetichenor ASP .Net 1 10-30-2006 02:57 PM
How to add a hyperlink column to asp.net datagrid - where only one value is a hyperlink Dave ASP .Net Datagrid Control 0 10-21-2006 07:48 PM
datagrid-how to get cell value(hyperlink column) =?Utf-8?B?UGF1bA==?= ASP .Net 9 10-12-2004 11:39 PM
How to set and highlight text in JTable cell on selection and/or invoke cell editor directly. news.rcn.com Java 1 07-12-2004 10:22 PM
Dynamically Hyperlink and Event Handler for the Hyperlink ? Ken ASP .Net Datagrid Control 1 08-15-2003 11:38 PM



Advertisments