[R] how to read data from MSExcel into R

Jeff Newmiller jdnewmil at dcn.davis.CA.us
Wed Sep 11 16:17:37 CEST 2013


The assertion that you need administrator privileges to install packages is false. You can install them into a directory under your Documents directory for your own use. You only need a administrator privileges to modify the packages located in the software installation directory.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

Charles Determan Jr <deter088 at umn.edu> wrote:
>If there isn't multiple sheets you can use the 'gdata' package and
>read.xls().
>
>Otherwise you could re-save the file as a csv file and load that file
>with
>read.csv() assuming not multiple sheets again which a csv cannot
>contain.
>
>Regards,
>Charles
>
>
>On Wed, Sep 11, 2013 at 8:01 AM, Charles Thuo <tcmuigai at gmail.com>
>wrote:
>
>> how can one read data from MSEXcel into R especially in a case where
>one
>> does not have administrator rights to install additional packages. In
>short
>> how to read data from MSExcel into R with base packages only.
>>
>>         [[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.
>>



More information about the R-help mailing list