[R] Writing a hyperlink to a csv file

[MacQueen, Don]

Besides what others have suggested, there are at some packages for writing
Excel files directly, and either of those might have a way to write
something that Excel will recognize as a hyperlink.

xlsx, XLConnect are both Java-based; I would start with these.

-Don

-- 
Don MacQueen

Lawrence Livermore National Laboratory
7000 East Ave., L-627
Livermore, CA 94550
925-423-1062





On 3/16/13 6:28 AM, "Brian Smith" <bsmith030465 at 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_grt at 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 at u-psud.fr
>> Web: 
>>http://www.ese.u-psud.fr/epc/**conservation/Marc.html<http://www.ese.u-ps
>>ud.fr/epc/conservation/Marc.html>
>> Skype: girondot
>>
>>
>
>	[[alternative HTML version deleted]]
>