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
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
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
3 matches
Mail list logo
