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 speci
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 singl
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 shoul
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
Excel
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 m
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")
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 li
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
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
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")
xl[["V
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
rg
> Subject: Re: [Rd] xlsReadWrite Pro and embedding objects and
> files in Excel worksheets
>
> 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/RDCOM
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 window
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 s
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 "re
Hans-Peter and other R developers,
How are you? Have you made any progess with embedding Url's in Excel?
Well, I have been busy thinking of more things for you to do;)
My colleagues in the lab are not R literate, and some are barely
computer literate, so I give them everything in Excel workbook
17 matches
Mail list logo
