[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