Existing functionality of the IO() method is to read in named ranges/tables from an Excel workbook. More flexibility could be added here. In particular, being able to read in an Excel workbook where each table is on its own worksheet and no named ranges/tables exist.
Existing functionality of the
IO()method is to read in named ranges/tables from an Excel workbook. More flexibility could be added here. In particular, being able to read in an Excel workbook where each table is on its own worksheet and no named ranges/tables exist.