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.