Displaying 1 result from an estimated 1 matches for "work_2012".
2012 Mar 15
2
Importing multiple worksheets from one Excle/ csv file into R
...one sheet (or 'one
file') each time, so that seems I have to create 50 csv files and do 'copy
and paste' work 50 times which is not ideal!
Alternatively I heard about a package 'xlsReadWrite' and created a 3 sheets
example (e.g. 3 sheets in one Excle file, saved at 'Z:/WORK_2012/Data/' on
my PC and is called 'test.xls' ) But my code failed to work.
-----------------
library(xlsReadWrite)
data1<-read.xls("Z:/WORK_2012/Data/test.xls")
Error in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, :
Incorrect number of argument...