[R] Automatic datasets creation from multiple data sheets in a single excel file

Please let us know how to create automatic datasets from multiple data sheets in a single excel file... For example if there are 10 sheets in a single excel file, automatically 10 datasets need to be created at a time when i read an excel file as a whole at once. Please attach the necessary code

Re: [R] Automatic datasets creation from multiple data sheets in a single excel file

rajclinasia wrote: > > Please let us know how to create automatic datasets from multiple data > sheets in a single excel file... > > For example if there are 10 sheets in a single excel file, automatically > 10 datasets need to be created at a time when i read an excel file as a > whole at onc

Re: [R] Automatic datasets creation from multiple data sheets in a single excel file

If you have RExcel (and the necessary infrastructure, i.e. statconnDCOM and possibly rcom) installed, the following VBA macro will do the trick. -=-=-=-=-= Option Explicit Sub TransferAllSheetsAsDataframes(wb As Workbook) Dim ws As Worksheet RInterface.StartRServer For Each ws In wb.S