[R] How to read this data correctly
ruipbarradas at sapo.pt
Fri Jan 24 20:36:23 CET 2014
Cell F7 has a formula, =F4, and when I open the file in excel, I get
-¥0.42, which shouldn't read properly in R.
The problem seems to be in the file, not in read.xls.
Hope this helps,
Em 24-01-2014 19:22, Christofer Bogaso escreveu:
> Hi again,
> I need to read below xlsx file correctly (available here:
> http://snk.to/f-ch3exae5), and used following code (say, file is saved in
> F: drive)
>> read.xls("f:/Book1.xlsx", 1, header = F)
> 1 -0.419547704894512
> 2 -[$Â¥-411]0.42
> However please notice that, in my original excel file the cells F4 and F7
> have essentially the same values. Therefore I should get
> -0.419547704894512, for either cases above.
> Any idea on how to achieve that, without opening the xlsx file manually and
> then formatting the cell before reading it in R?
> Thanks for your help
> [[alternative HTML version deleted]]
> R-help at r-project.org mailing list
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help