[R] enquiry
Rui Barradas
ruipbarradas at sapo.pt
Tue Jul 17 12:00:53 CEST 2012
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 <ruipbarradas at sapo.pt <mailto:ruipbarradas at 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 at r-project.org <mailto:R-help at 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 at r-project.org <mailto:R-help at 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 at r-project.org <mailto:R-help at 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.
>
>
More information about the R-help
mailing list