Displaying 1 result from an estimated 1 matches for "keepformulas".
2012 May 15
4
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.