Hi Marc,

Thanks for the reply.

The question is whether it is possible to write some text (with a
hyperlink) to a csv file, such that when you open the file in excel, it
shows the text as hyperlinked. I guess it boils down to whether there are
any 'tags' that you can put in the csv/txt file so that excel recognizes it
as hyperlinked text.

Does that make sense?

thanks!

On Sat, Mar 16, 2013 at 4:16 AM, Marc Girondot <marc_grt@yahoo.fr> wrote:

> Le 15/03/13 12:53, Brian Smith a écrit :
>
>  Hi,
>>
>> I was wondering if it is possible to create a hyperlink in a csv file
>> using
>> R code and some package. For example, in the following code:
>>
>> links <- cbind(rep('Click for Google',3),"google search address goes
>> here")
>> ## R Mailing list blocks if I put the actual web address here
>> write.table(links,'test.csv',
>> sep=',',row.names=F,col.names=**F)
>>
>>
>> the web address should be linked to 'Click for Google'.
>>
> The browseURL() function open your internet browser with the url indicated
> as parameter:
> browseURL("http://www.r-**project.org <http://www.r-project.org>")
>
> But I am not sure how you want call it. You should be more precise about
> the context you want to use it.
> For example:
>
> links <- data.frame(c(' for Google', ' for Bing'),
>                c("http://www.google.com", "http://www.bing.com"),
>                     stringsAsFactors = FALSE)
> cat("Choose an option:\n", paste(1:2, links[,1],"\n"))
> f<-scan(nmax=1, quiet=TRUE)
>
> browseURL(links[f,2])
>
> Sincerely
> Marc
>
> --
> ______________________________**____________________________
> Marc Girondot, Pr
>
> Laboratoire Ecologie, Systématique et Evolution
> Equipe de Conservation des Populations et des Communautés
> CNRS, AgroParisTech et Université Paris-Sud 11 , UMR 8079
> Bâtiment 362
> 91405 Orsay Cedex, France
>
> Tel:  33 1 (0)1.69.15.72.30   Fax: 33 1 (0)1.69.15.73.53
> e-mail: marc.girondot@u-psud.fr
> Web: http://www.ese.u-psud.fr/epc/**conservation/Marc.html<http://www.ese.u-psud.fr/epc/conservation/Marc.html>
> Skype: girondot
>
>

	[[alternative HTML version deleted]]

