[R] [FORGED] Export R output in Excel

Erich Subscriptions erich.subs at neuwirth.priv.at
Thu Dec 29 23:32:50 CET 2016


Just a very brief footnote.
I is easy to write badly structured spreadsheets.
But if people dong this would not have spreadsheets 
and be forded to write code, they probably also
would write badly structured code.

There is a lot of bad R code around also!



> On Dec 29, 2016, at 15:40, Bert Gunter <bgunter.4567 at gmail.com> wrote:
> 
> (Private -- as this is just my personal opinion and not really helpful).
> 
> I found your comments informative. Thank you.
> 
> My own experience with scientific colleagues -- biologists mostly --
> who use Excel in the way that you describe is that the "haptic" (great
> word!) ease with which they manipulate the data almost inevitably
> results in errors. That is, the *lack* of enforced structure in Excel
> allows them to do things that they shouldn't or don't mean to do,
> typically without raising any flags, typically causing downstream
> errors that can be hard to trace. Irreproducibility follows.
> 
> My point is that the structure that you consider burdensome -- at
> least initially -- is desirable exactly because it forces them to
> think more carefully about what they are doing. Debugging, or worse
> yet, failure to realize that debugging is needed, takes far more time
> and is far more consequential.
> 
> As I said, just my opinion, no reply necessary, and I do appreciate
> your thoughtful remarks.
> 
> Best,
> Bert Gunter
> 
> Bert Gunter
> 
> "The trouble with having an open mind is that people keep coming along
> and sticking things into it."
> -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip )
> 
> 
> On Thu, Dec 29, 2016 at 2:16 AM, Erich Subscriptions
> <erich.subs at neuwirth.priv.at> wrote:
>> Well, my few cents again.
>> the packages
>> openxslx and xlsx allow to write dataframes as Excel sheets.
>> (xlsx is Java based, so it has more requirements to run than openxlsx,
>> which is just C++ based)
>> 
>> On Windows, R tools for Visual Studio allows Excel export.
>> For Windows, there also is our Excel add-in RExcel allowing
>> to use R from within Excel, and the R package rcom
>> which also allows to interact with Excel from R (more than just writing Excel workbooks).
>> Our products (rcom and RExcel), however, are not unter a FOSS license.
>> 
>> And a more general remark: There are a lot of things where R is a much better choice than Excel,
>> but there are a few things where it really makes sense  to use spreadsheets.
>> 
>> Spreadsheets offer a totally different paradigm to work with data, or more generally,
>> numbers and formulas.
>> One can interact with the data directly, not hide them behind variable names.
>> And, the interaction is haptic, gesture based, not expressed as a language.
>> 
>> Rearranging the layout of a pivot table by dragging variable “blocks”
>> is very intuitive and something which R itself doe not offer
>> (in fact, I wrote an add-in for R Commander to implement it).
>> 
>> Of course, Excel is not a good chice for a polished reproducible workflow.
>> But I think quite a few people (including me), when starting a new project,
>> are not ready immediately to set up this “perfect” workflow,
>> and it is much easier to experiment with the data with a spreadsheet based
>> interface.
>> 
>> For me, working with spreadsheets is more like improvising some Jazz,
>> and writing R code is like writing a score for a composition.
>> 
>> 
>> 
>> 
>> 
>>> On 29 Dec 2016, at 00:15, Rolf Turner <r.turner at auckland.ac.nz> wrote:
>>> 
>>> On 29/12/16 10:45, Bryan Mac wrote:
>>>> Hi,
>>>> 
>>>> How do I export results from R to Excel in a format-friendly way? For
>>>> example, when I copy and paste my results into excel, the formatting
>>>> is messed up.
>>> 
>>> 
>>> Short answer:  *Don't*.  ("Friends don't let friends use excel for statistics.")
>>> 
>>> Longer answer:  Googling on "export R data to excel" yields lots of "useful" hits --- "useful" given the (false) assertion that it is useful to export things to excel.
>>> 
>>> cheers,
>>> 
>>> Rolf Turner
>>> 
>>> --
>>> Technical Editor ANZJS
>>> Department of Statistics
>>> University of Auckland
>>> Phone: +64-9-373-7599 ext. 88276
>>> 
>>> ______________________________________________
>>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>>> 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 -- To UNSUBSCRIBE and more, see
>> 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.



More information about the R-help mailing list