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.
