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
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 no
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 attac
^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 st
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. Howev
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 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 noti
7 matches
Mail list logo
