Try XLConnect. It seems to read the data in just fine. Did have to
create a named region, otherwise it would just read in the area that
had data.
require(XLConnect)
wb - loadWorkbook(C:\\Users\\Owner\\Downloads\\Book1 (1).xlsx)
x - readWorksheet(wb, 1, header = FALSE) # without region; only
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
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
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.
^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
Hi,
I am getting this:
read.xls(Book1.xlsx,1,header=F)
# V1
#1 -0.4195477
#2 -0.4195477
sessionInfo()
R version 3.0.2 (2013-09-25)
Platform: x86_64-unknown-linux-gnu (64-bit)
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other
Hi,
I don't know that it is a problem in R reading the file per se. It is more of
an issue, as far as I can see, that read.xls() is not written to deal with some
aspects of cell formatting of certain types. In this case, the cell is
formatted using a financial format with Japanese Yen. I did
7 matches
Mail list logo