On Tue, May 15, 2012 at 4:11 PM, Mike Smith <[email protected]> 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 ______________________________________________ [email protected] 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.
