Hi Rui,

Thanks for your reply.

However why you said, 'shouldn't read properly in R'?

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@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@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.
>>
>>

	[[alternative HTML version deleted]]


