[R] nice report generator?

[Greg Snow]

Duncan, 

If you are taking suggestions for expanding the tables package (looks great) then I would suggest some way to get the tables into MS products.  If I create a full output/report myself then I am happy to work in LaTeX, but much of what I do is to produce tables and graphs to clients that don't know LaTeX and just want something that they can copy and paste into powerpoint or word.  For this I have been using the R2wd package (and the wdTable function for the tables).  I would love to have some toolset that I could use your tables package to create the main table, then transfer it fairly simply to word or excel.  I don't care much about the fluff of how the table looks (coloring rows or columns, line widths, etc.) just getting it into a table (not just the text version).

One possibility is just an as.matrix method that would produce something that I could feed to wdTable.  Or just a textual representation of the table with columns separated by tabs so that it could be copied to the clipboard then pasted into excel or word (I would then let the client deal with all the tweaks on the appearance).

Thanks,

-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On Behalf Of Duncan Murdoch
Sent: Thursday, December 08, 2011 4:52 PM
To: Tal Galili
Cc: r-help
Subject: Re: [R] nice report generator?

On 11-12-08 1:37 PM, Tal Galili wrote:
> Helloe dear Duncan, Gabor, Michael and others,
>
> Do you think it could be (reasonably) possible to create a bridge between a
> "cast_df" object from the {reshape} package into a table in Duncan's new
> {tables} package?

I'm not that familiar with the reshape package (and neither it nor 
reshape2 appears to have a vignette to give me an overview), so I don't 
have any idea if that makes sense.  The table package is made to work on 
dataframes, and only dataframes.  It converts them into matrices with 
lots of attributes, so that the print methods can put nice labels on. 
But it's strictly rectangular to rectangular in the kinds of conversions 
it does, and from the little I know about reshape, it works on more 
general arrays, converting them to and from dataframes.


>
> That would allow one to do pivot-table like operations on an object using
> {reshape}, and then display it (as it would have been in excel - or better)
> using the {tables} package.

You'll have to give an example of what you want to do.

Duncan Murdoch


>
>
>
>
>
>
> ----------------Contact
> Details:-------------------------------------------------------
> Contact me: Tal.Galili at gmail.com |  972-52-7275845
> Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) |
> www.r-statistics.com (English)
> ----------------------------------------------------------------------------------------------
>
>
>
>
> On Thu, Dec 8, 2011 at 5:24 PM, Michael<comtech.usa at gmail.com>  wrote:
>
>> Hi folks,
>>
>> In addition to Excel style tables, it would be great to have Excel 2010
>> Pivot Table in R...
>>
>> Any thoughts?
>>
>> Thanks a lot!
>>
>> On Thu, Dec 8, 2011 at 4:49 AM, Tal Galili<tal.galili at gmail.com>  wrote:
>>
>>> I think it would be *great *if an extension of Duncan's new "tables"
>>> package could include themes and switches as are seen in the video Gabor
>>> just linked to.
>>>
>>>
>>> Tal
>>>
>>>
>>>   On Thu, Dec 8, 2011 at 6:58 AM, Gabor Grothendieck<
>>> ggrothendieck at gmail.com>  wrote:
>>>
>>>>   On Wed, Dec 7, 2011 at 11:42 PM, Michael<comtech.usa at gmail.com>  wrote:
>>>>> Do you have an example...? Thanks a lot!
>>>>
>>>> See this video:
>>>> http://www.woopid.com/video/1388/Format-as-Table
>>>>
>>>> --
>>>> Statistics&  Software Consulting
>>>> GKX Group, GKX Associates Inc.
>>>> tel: 1-877-GKX-GROUP
>>>> email: ggrothendieck at gmail.com
>>>>
>>>> ______________________________________________
>>>> 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<http://www.r-project.org/posting-guide.html>
>>>> and provide commented, minimal, self-contained, reproducible code.
>>>>
>>>
>>>
>>
>
> 	[[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.

______________________________________________
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.