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_...@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.giron...@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]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
