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 <[email protected]>
> 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]]
>>>
>>> ______________________________________________
>>> [email protected] 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.
>>>
>>>
>> ______________________________________________
>> [email protected] 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.
>>
>
> ______________________________________________
> [email protected] 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]]
______________________________________________
[email protected] 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.
