Software

Ask something
Question Locked

Excel Data to HTML Page

0 helpful
5 replies

by joey.tucker

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hello, wondering if someone could point me in the right direction. I need to pull over data on an excel spreadsheet to a HTML page. That part all works and looks fine. The one little wrinkle I have is that one column in the spreadsheet are hyperlinks. The names come across to the HTML but not the links, I need these links to come across. Is there a way to accomplish this?

5 replies

by robo_dev

Is it because the leading apostrophe?

Try to type this formula at A1 of your given file: =HYPERLINK(SUBSTITUTE(B1,"'","",1))

by joey.tucker

with this code:

' Write the SQL Query
RS.open "SELECT * FROM my_range", oConn

do until RS.EOF
' Response.Write ( RS("NAME") & RS("Ext") & RS("Dept") & RS("Location") & RS("Signatures")& "")

WITH Response
.Write "

" & vbCrlf
.Write "

" & rs( "Name") & "

" & vbCrlf
.Write "

" & rs( "Ext" ) & "

" & vbCrlf
.Write "

" & rs( "Dept" ) & "

" & vbCrlf
.Write "

" & rs( "Location" ) & "

" & vbCrlf
.Write "

" & rs( "Signatures" ) & "

" & vbCrlf
END WITH

by joey.tucker

I have a spreadsheet with 5 coliumns. Each column is in a "range". I am using this code: RS.open "SELECT * FROM my_range", oConn
to pulll over the data from excel to the html page. A Responce.Write command writes the data from each column to the web page. But, the 5th column, which is hyperlinks on the spreadsheet justs pulls over the text, not the text with the hyperlinks.

This discussion is closed to new replies.