[R] How to read this data correctly

[Rui Barradas]

Hello,

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,

Rui Barradas

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)
>
>
>> library(gdata)
>> read.xls("f:/Book1.xlsx", 1, header = F)
>                    V1
> 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
> 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.
>