[R] Reading Excel Formulas as values

Gabor Grothendieck ggrothendieck at gmail.com
Tue May 15 23:20:41 CEST 2012


On Tue, May 15, 2012 at 4:11 PM, Mike Smith <ziggy55311 at gmail.com> wrote:
> When I read excel files using the read.xlsx() command any cells that have
> formulas in them come up as NA.
>
> Is there a way to read just the numeric value of the cell without using the
> "paste value" command in Excel?  I need to read in hundreds of Excel
> spreadsheets and compile them into one large super spreadsheet
> automatically.  Hence the reason I cannot reformat each sheet manually.
>

Try read.xls in gdata.

-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com



More information about the R-help mailing list