[R] Reading Excel Formulas as values

[Peter Alspach]

Tena koe Mike

Another alternative to those already given is to use the RODBC package.

HTH ....

Peter Alspach.

-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On Behalf Of Mike Smith
Sent: Wednesday, 16 May 2012 8:11 a.m.
To: r-help at r-project.org
Subject: [R] Reading Excel Formulas as values

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.

	[[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.

The contents of this e-mail are confidential and may be subject to legal privilege.
 If you are not the intended recipient you must not use, disseminate, distribute or
 reproduce all or any part of this e-mail or attachments.  If you have received this
 e-mail in error, please notify the sender and delete all material pertaining to this
 e-mail.  Any opinion or views expressed in this e-mail are those of the individual
 sender and may not represent those of The New Zealand Institute for Plant and
 Food Research Limited.