[R] How to read this data correctly

[Rui Barradas]

^Hello,

Inline.

Em 24-01-2014 20:49, Christofer Bogaso escreveu:
> Hi Rui,
>
> Thanks for your reply.
>
> However why you said, 'shouldn't read properly in R'?

I've said this because I don't know if a cell with a formula can be read 
in R.
Also, because when I've opened it in excel, there was some strange 
character, like I've said, -¥0.42.

Rui Barradas
>
> Basically I was looking for some way so that I would get
> -0.419547704894512 value in R against cell F4 & F7. Because F7 is linked
> with F4.
>
> Ofcourse I can open Excel file then format that cell accordingly.
> However I am looking for some way in R so to avoid any manual process.
>
> Thanks and regards,
>
>
> On Sat, Jan 25, 2014 at 1:21 AM, Rui Barradas <ruipbarradas at sapo.pt
> <mailto:ruipbarradas at sapo.pt>> wrote:
>
>     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 <mailto:R-help at r-project.org> mailing list
>         https://stat.ethz.ch/mailman/__listinfo/r-help
>         <https://stat.ethz.ch/mailman/listinfo/r-help>
>         PLEASE do read the posting guide
>         http://www.R-project.org/__posting-guide.html
>         <http://www.R-project.org/posting-guide.html>
>         and provide commented, minimal, self-contained, reproducible code.
>
>