^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 <ruipbarra...@sapo.pt <mailto: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 <mailto:R-help@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.
______________________________________________ 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.
