Hello,
Sorry, but I'm not at my computer and will be away from it for 2 or 3
days, so I can't install package XLConnect and see what's going on.
Heve you tried the functions to get sheets first? (by number, maybe.)
Rui Barradas
Em 16-07-2012 22:30, Erdal Karaca escreveu:
Just tried XLConnect which seems to work without any problems...
When defining this:
wb <- loadWorkbook("c:\\path-to-xls-file")
readCell <- function(sheet, row, col) {
readWorksheet(wb, sheet, startRow=row, endRow=row, startCol=col,
endCol=col, header=FALSE)[[1]]
}
then, calling the function like this:
readCell("Tabelle1", 1, 1)
I will get this error message: "Fehler in startRow - 1 :
nicht-numerisches Argument für binären Operator" (error in startRow - 1:
non-numeric argument for binary operator)
What am I doing wrong?
Note: I just want to read the value of a specific cell. The best way is
to have a function providing an excel like coordinate (e.g. "A1")...
2012/7/16 Rui Barradas <ruipbarra...@sapo.pt <mailto:ruipbarra...@sapo.pt>>
Sorry, it's
findFn("xlsx")
And the first three hits ARE promising (they work). I use the
second, package xlsx. Package XLConnect is more flexible if you want
to do things to excel spreadsheets from R. Package xlsx is simpler
if you just want to read them and then use R.
Rui Barradas
Em 16-07-2012 07:37, Rui Barradas escreveu:
Hello,
Try the following.
install.packages("sos") # to install the package
library(sos) # to load the package nto R session
finFn("xlsx") # find it
Have fun.
Hope this helps,
Rui Barradas
Em 16-07-2012 06:17, Karan Anand escreveu:
hi,
i am new to r ,i have a xlsx data with me with 12
sheet in it and
need to convert it to csv first and then need to convert
it into time
series ,so if u can pls guide me a little how to do it.
Regards
karan
[[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
PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible
code.
______________________________________________
R-help@r-project.org <mailto: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.
______________________________________________
R-help@r-project.org <mailto: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.
______________________________________________
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.
