What Excel does or does not recognize as a url in any particular instance is up
to Excel. The CSV format itself has no concept of markup that would allow you
to convey this idea. HTML does, and I think Excel can import HTML, but I have
never tried intentionally using HTML as a data exchange format for Excel.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
Brian Smith <bsmith030...@gmail.com> wrote:
>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.
______________________________________________
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.
