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@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 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.
>>
>
> ______________________________________________
> 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.
>

	[[alternative HTML version deleted]]

