[R] How to Save R library data into xls or dta format

Prof Brian Ripley ripley at stats.ox.ac.uk
Tue Mar 1 11:33:50 CET 2011


On Tue, 1 Mar 2011, Santosh Srinivas wrote:

> for excel .. see library(xlsx)

(That's for Excel >= 2007 only, .xlsx not .xls are requested.)

Simply consult the relevant manual, 'R Data Import/Export': all of 
this is covered there.  There is a very new package XLConnect that is 
only covered in the latest version (post R 2.12.2).

>
> On Tue, Mar 1, 2011 at 2:57 PM, JoonGi <joongi at hanmail.net> wrote:
>>
>> Thanks in advance.
>>
>> I'm having a trouble with data saving.
>>
>> I want to run the same data which is in Ecdat library at different statistic
>> programs(excel, stata and matlab)
>>
>> The data I want to use is
>>
>> library(Ecdat)
>> data(Housing)
>>
>> and I want to extract this data our of R as *.dta *.xls formats.
>> So, my first try was to open the data in R window and drag and paste to
>> excel or notepad.
>>
>> BUT, it didn't work.
>>
>> Do you have any decent skills to extract this library data?
>>
>> Please, share to me.

We already did: we wrote a manual for you!

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595



More information about the R-help mailing list