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 On Tue, May 15, 2012 at 4:11 PM, Mike Smith <ziggy55...@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. > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@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. ______________________________________________ R-help@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.