enquiry

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]]

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]]

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]]