R help - Apr 2010 - Image into Excel file from R

Hi useRs,
I would like to know what R users are employing to get their
images/plots created in R, into Excel sheets.

I am aware of the various packages (xlsReadWrite, RODBC) to get data
frames into R, but I would like to copy images too.

Thank you for any help in solving this problem.

Regards,
Harsh Singhal

Hi Harsh,
I don't know the answer,
But I would suggest you search and look at:
rcom



----------------Contact
Details:-------------------------------------------------------
Contact me: Tal.Galili@gmail.com |  972-52-7275845
Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) |
www.r-statistics.com (English)
----------------------------------------------------------------------------------------------




On Sun, Apr 25, 2010 at 8:13 PM, Harsh <singhalblr@gmail.com> wrote:
> Hi useRs,
> I would like to know what R users are employing to get their
> images/plots created in R, into Excel sheets.
>
> I am aware of the various packages (xlsReadWrite, RODBC) to get data
> frames into R, but I would like to copy images too.
>
> Thank you for any help in solving this problem.
>
> Regards,
> Harsh Singhal
>
> ______________________________________________
> 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.
>
	[[alternative HTML version deleted]]

On Apr 25, 2010, at 1:13 PM, Harsh wrote:
> Hi useRs,
> I would like to know what R users are employing to get their
> images/plots created in R, into Excel sheets.
>
> I am aware of the various packages (xlsReadWrite, RODBC) to get data
> frames into R, but I would like to copy images too.
I guess this means you are in one of the Windows variations. You have  
a variety of graphical output formats available:

?capabilities
?Devices

... and then whatever insert-file keystroke or click operation you  
normally use.
>
> Thank you for any help in solving this problem.
You have not described what you have tried so far, so it's difficult  
to know what might be the next step.
>
> Regards,
> Harsh Singhal
>
-- 

David Winsemius, MD
West Hartford, CT

See:

https://stat.ethz.ch/pipermail/r-help/2010-January/225841.html

-J

> I am aware of the various packages (xlsReadWrite, RODBC) to get data
> frames into R, but I would like to copy images too.
The xlsReadWritePro version could do it (see code below). It's a
shareware package, but if people need/ask for a gratis license I send
it (please download and check ?xls.lic first; www.swissr.org). I'm
just finishing 'some' :-) RUnit tests and a new version will be
released tomorrow or after tomorrow.

Cheers,
Hans-Peter

rfile.img <- sub("origData", "origImage", rfile, fixed =
TRUE)
wfile.img <- sub("tmpWriteData", "tmpWriteImage", wfile,
fixed = TRUE)
pics <- c("pic1.jpeg", "pic2.png", "pic3.bmp",
"pic4.emf", "pic5.wmf",
"pic.jpg")
fpics <-  file.path(dirname(rfile), pics)


### test: image
### !!! tests have to be executed in sequencial order !!!

test.proImage.1write <- function() {
    exc <- xls.open(rfile.img)
    xls.image(exc, "set", fpics[1], "Pic1")
    xls.image(exc, "set", fpics[2], "Pic2")
    xls.image(exc, "set", fpics[3], "Pic3")
    xls.image(exc, "set", fpics[4], "Pic4")
    xls.image(exc, "set", fpics[5], "Pic5")
    xls.image(exc, "set", fpics[6], c(17, 7, 20, 8))
    xls.close( exc, file = wfile.img)

    res <- xls.image(wfile.img, "list")
    checkIdentical(res, c("Grafik 1", fpics))
}