Hi Mark et al.
2007/2/12, Hans-Peter [EMAIL PROTECTED]:
Yes, but I started with the update of the free version and got delayed
there (not that I didn't know that paying customers should be
prefered...) - I'll update the pro version right now and you should
have it until Wednesday, maybe
Hi Mark,
I would like to be able to use a single Excel spreadsheet as an archive
for any output I generate in a single R session, including pdf files of
graphics and possibly the R history or even the R workspace itself.
What we do is:
- assemble all generated files (xls/png/txt) in a
Hi Mark,
Sorry to not reply earlier, I was away this week.
Hans-Peter and other R developers,
How are you? Have you made any progess with embedding Url's in Excel?
Yes, but I started with the update of the free version and got delayed
there (not that I didn't know that paying customers should
Hans-Peter,
Welcome back, I hope you had a good time away :)
I got what I thought were some answers that misinterpreted what my
intent was, so let me ask again and try to be more clear.
I would like to be able to use a single Excel spreadsheet as an archive
for any output I generate in a
If Excel has the capability to do it then by controlling Excel from R
using RDCOMClient or rcom packages you can do it (in Windows).
For example, the code below creates a plot in R and then creates an Excel
spreadsheet and inserts it.
Get up to speed on VBA and then use the Macro recorder in
I don't know of any native xls read/write facility in R, either
in core or as add-ons (I could be wrong), but if you want some source
code to scavenge on to build some R package out of it, there are two
perl modules, Spreadsheet::ParseExcel and Spreadsheet::WriteExcel
which are small enough to
Have you looked at RDCOMClient? I would imagine you could do what you
want with this package.
http://www.omegahat.org/RDCOMClient/
Best,
Jim
Hin-Tak Leung wrote:
I don't know of any native xls read/write facility in R, either
in core or as add-ons (I could be wrong), but if you want some
James W. MacDonald wrote:
Have you looked at RDCOMClient? I would imagine you could do what you
want with this package.
http://www.omegahat.org/RDCOMClient/
Interesting point. But the dcom client would be windows-specific?
(those I mentioned - the perl mondules, openoffice, run on windows,
you can also use my package which uses Jakarta POI to write the excel
files.
It can be used on any platform that supports java.
The Perl solution may be better if you want to do anything complicated,
but this package supports writing all basic R objects.
http://code.google.com/p/rexcelpoi/
Thanks for the useful suggestions. I am not as CS savvy as some of you,
so maybe Hans-Peter could reply? I haven't checked into it, but does his
package write to files that are OpenOffice compliant? Would that
satisfy more users?
Mark
Hin-Tak Leung wrote:
James W. MacDonald wrote:
Have
Its not entirely clear to me what it is that you are looking
for. Maybe you want to create an Excel spreadsheet with a hyperlink
to a web page? This R code will do that. It requires a Windows machine that
has Excel running on it.
library(RDCOMClient)
xl - COMCreate(Excel.Application)
I meant that the machine has Excel on it. Excel does not have to be running
prior to running the R code as the R code will start up and shut
down Excel itself.
On 2/8/07, Gabor Grothendieck [EMAIL PROTECTED] wrote:
Its not entirely clear to me what it is that you are looking
for. Maybe you
The gdata etc. packages (I cannot remember which of the g* packages
it is) contains a read.xls function which reads an excel file based
on a PERL script. I have used it for small stuff and for that it
worked fine. I don't think they contain a write module though.
Kasper
On Feb 8, 2007, at
Another option for creating XLS files it to write out HTML instead. Excel can
read html files just fine, and a useful trick is giving the html file a .xls
extension. So, from the user's point of view, it is an excel file even
though it's just an html file.
Using html works great for embedding
On Thursday 08 February 2007 2:09 pm, tshort wrote:
I don't know of an R package that has a function to encode files as a
multipart mime, but the link above is a good start.
Tclib has mime encoding module one could use it from within R with
.Tcl(package require tcllib)
Gabor,
What I want is a bit more than hyperlinks, although I did ask the
package developer about that to. My idea is, from within R, place things
like pdf files and .Rdata directly into an Excel spreadsheet. As a
practical matter, if I can create a report with some data that someone
else can
16 matches
Mail list logo
