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 <ruipbarra...@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]]
______________________________________________ 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.
