I can't replicate your problem. I created a spreadsheet in Excel 2007 consisting of three columns. Numbers from 1 - 15, rand(), and the sum of the first two columns. Using all the defaults with read.xlsx() (package: xlsx), I get the values of each column and using keepFormulas=TRUE, I get the formulas as factors. I don't get any NA's. I can also place a formula on the second sheet that accesses data from the first sheet without any problems. I haven't tried, Excel 2010.
Could your formulas be accessing data from another spreadsheet? ---------------------------------------------- David L Carlson Associate Professor of Anthropology Texas A&M University College Station, TX 77843-4352 > -----Original Message----- > From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- > project.org] On Behalf Of Mike Smith > Sent: Tuesday, May 15, 2012 3:11 PM > To: r-help@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@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.