search for: multisheets

I?ve got an Excel workbook with about 30 worksheets. Each worksheet has 10000 rows of data over 30 columns. I?d like to read the data from each worksheet into a dataframe or matrix in R for processing. Normally, I use read.csv when interacting with Excel but I?d rather manipulate a multisheet workbook directly than set about splitting the original workbook and saving down each part as a csv.

...rt doesn't delete it). When I now save the xls-file, and import it again using the RODB package, the data is now complete. Any idea what to do about that? My main problem is to get the spreadsheetML into R so I tried other file formats to which ssconvert can convert to, but only excel supports multisheets. Best, Stefan Example code: system(paste('ssconvert "excelcohortdata_men_reference scenario.xml" "excelcohortdata_men_reference scenario22.xls"')) channel1<-odbcConnectExcel("excelcohortdata_men_reference scenario10.xls") odbcGetInfo(channel1) sqlTables(...

Hello, All: The "writeFindFn2xls" function in the "sos" package tries to write an Excel file with 3 sheets ('PackageSum2', 'findFn', 'call'). Unfortunately, it is often unable to do this because of configuration problems that are not easy to fix. I've found 3 contributed packages that provide facilities to write Excel files with

...rt doesn't delete it). When I now save the xls-file, and import it again using the RODB package, the data is now complete. Any idea what to do about that? My main problem is to get the spreadsheetML into R so I tried other file formats to which ssconvert can convert to, but only excel supports multisheets. Best, Stefan Example code: system(paste('ssconvert "excelcohortdata_men_reference scenario.xml" "excelcohortdata_men_reference scenario22.xls"')) channel1<-odbcConnectExcel("excelcohortdata_men_reference scenario10.xls") odbcGetInfo(channel1) sqlTables(...