2 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
> th
-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 h
On Tue, May 15, 2012 at 4:11 PM, Mike Smith 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 hund
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
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 su
5 matches
Mail list logo
