Yep, you are right, this works:
readCell <- function(workbook, sheetName, i, j) {
pos <- getSheetPos(workbook, sheetName)
readWorksheet(workbook, pos, startRow=i, endRow=i, startCol=j, endCol=j,
header=FALSE)[[1]]
}
2012/7/17 Rui Barradas <ruipbarra...@sapo.pt>
> 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 <ruipbarra...@sapo.pt <mailto:ruipbarra...@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 <mailto: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 <mailto: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 <mailto: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]]
______________________________________________
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.
