Writing a hyperlink to a csv file
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:<jdnewmil at 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 <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-psud.fr/epc/conservation/Marc.html>
Skype: girondot
[[alternative HTML version deleted]] ------------------------------------------------------------------------
______________________________________________ R-help at 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.