Reading Excel Formulas as values

It sounds like this might actually make more sense to do in VBA and
not R (gasp!) if your only goal is to have excel in --> excel out.

[UNTESTED] As far as a workaround if you really want to do this in R,
perhaps you can specify that you want character vectors everywhere and
your connection client won't try to evaluate them. I don't really know
if this actually works though...If you are again willing to step
outside of R, there are clients [I'm thinking perl and Python] that
convert things to character csv's which would certainly make this
work.

Best,
Michael

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.