Welcome to Dream.In.Code
Getting Help is Easy!

Join 109,295 Programmers for FREE! Ask your question and get quick answers from experts. There are 1,187 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now!



Using Perl scrips in Excel

 
Reply to this topicStart new topic

Using Perl scrips in Excel

craigy
post 7 May, 2008 - 02:32 PM
Post #1


New D.I.C Head

*
Joined: 7 May, 2008
Posts: 2

Hi all.

I've recently setup a searchable database on my website using Perl. The database data is in excel, but I need to transfer the hyperlinks to the results page (they're unique for each line of data). The links are working in Excel, but not on my website's results page.

If I'm not mistaken, I need to change the HTML code of the hyperlink to work with Pearl to the following code:
CODE
<a href="[[weblink]]">Web Link</a>
but Excel doesn't seem to accept Perl scripts and thinks the link is a "mailto:" link.

Does anyone know if this possible or how I can get round this?

Thanks in advance.
User is offlineProfile CardPM

Go to the top of the page


craigy
post 8 May, 2008 - 04:01 AM
Post #2


New D.I.C Head

*
Joined: 7 May, 2008
Posts: 2

QUOTE(craigy @ 7 May, 2008 - 02:32 PM) *

Hi all.

I've recently setup a searchable database on my website using Perl. The database data is in excel, but I need to transfer the hyperlinks to the results page (they're unique for each line of data). The links are working in Excel, but not on my website's results page.

If I'm not mistaken, I need to change the HTML code of the hyperlink to work with Pearl to the following code:
CODE
<a href="[[weblink]]">Web Link</a>
but Excel doesn't seem to accept Perl scripts and thinks the link is a "mailto:" link.

Does anyone know if this possible or how I can get round this?

Thanks in advance.


Doesn't matter now. I've resolved it smile.gif I realised I just type the code as is in the cell.
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 9/6/08 09:17AM

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month