Problem with cell and hyperlink - ASP

Discussion in 'ASP General' started by mapoart@gmail.com, Dec 6, 2007.

  1. Guest

    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
     
    , Dec 6, 2007
    #1
    1. Advertising

  2. Mike Brind Guest

    <> wrote in message
    news:...
    > 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
     
    Mike Brind, Dec 7, 2007
    #2
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?UGF1bA==?=

    datagrid-how to get cell value(hyperlink column)

    =?Utf-8?B?UGF1bA==?=, Oct 12, 2004, in forum: ASP .Net
    Replies:
    9
    Views:
    8,898
    =?Utf-8?B?UGF1bA==?=
    Oct 13, 2004
  2. news.rcn.com
    Replies:
    1
    Views:
    9,675
    Chris Smith
    Jul 12, 2004
  3. davetichenor
    Replies:
    1
    Views:
    844
    Eliyahu Goldin
    Oct 30, 2006
  4. Ken
    Replies:
    1
    Views:
    387
    Alvin Bruney
    Aug 16, 2003
  5. Dave
    Replies:
    0
    Views:
    957
Loading...

Share This Page