How to read Data from Excel when it have Multiple Headers

Help Activities
, ,
6

Hi @ramesh_kola ,

As observed my @postwick , we do see that the table data or Chunks of data is organized in a Group Table, and each group contains 5 Column data or rather the same Columns.

Hence, this several group of data can be combined into a Single Table/Datatable by Merging the n number of Group tables available dynamically.

We could follow the below Steps :

  1. Use Read Range Activity to read the data as a Datatable, say DT with range specified as “A3” as that is the start of row data.
    image

  2. Next, we create a Output Datatable using Build Datatable Activity with the required column Names as observed/available in one group.
    image

  3. Next we get the Total Number of Groups present in the Data by Dividing the Total Number of Columns by 5. We perform an Iteration upto this number. Selecting the Column Chunks (every 5 columns) and Merging the Selected Columns Data to the Output Datatable.
    image

  4. Next, If required we could write the Output datatable to an Excel file using Write Range Activity.

Check the workflow below :
Excel_Combine_TableChunks.zip (10.1 KB)

Let us know if the method is not agreeable or if the Grouping assumption is wrong.