In my scenario I have multiple tables in one excel. All tables are having same header and all tables are placed horizontally. Between each table we have some empty cells. Each table has a table header right above it.
Need to store all table values into one datatable.
How to fix this.
Hello @balanirmalkumar.s
If you name your table-ranges you can input this name inside “Read Range Workbook” Range property.
Regards
Soren
Table range is dynamic. Based on input file range will differ.
Unfortunately (as far as I know) the Activity “Read Range Workbook” does not work with the built-in (dynamic) table names from Excel.
Welcome to the Community!!
Use a loop like while to determine tables with a condition based on detecting table headers or empty rows between tables.
Hope this helps!!
sharazkm32
ashokkarale
marquezd
RGTaffy
SorenB
cprima
KB_Fleet
Nithinkrishna
V_M_P_Bharath
Nisha_K21