[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