Excel merge read range for multiple ranges

[uiStijn (Stijn Ekkelboom)]

Hey Team,

Is there a way to merge read range outputs in Excel for multiple ranges without having to use the read range activity 6 times?

[Sudharsan_Ka]

HI @uiStijn

That is not possible either you need to read it completely and then filter them and then get the data with expression or you need to use six read range

Regards
Sudharsan

[Gokul001 (Gokul Balaji)]

Hi @uiStijn

Can you try with this method

• You can use multiple read range activities for each range and then use merge data table activity to combine them into one data table, if the number of columns of the ranges is all the same.

• You can use append range activity to append data from different sheets or workbooks into one sheet and then use read range activity to read the whole sheet into a data table, if the structure of the data is consistent.

Check out this blog

UiPath Read Range, Write Range and Append Range

Regards
Gokul

[uiStijn (Stijn Ekkelboom)]

Hey guys, i fixed it with this Assign:

MergedDatatable = extracted_bas_Value_0_1_2_3.AsEnumerable().Concat(
extracted_bas_Value_4_5.AsEnumerable()).Concat(
extracted_bas_Value_6_7.AsEnumerable()).Concat(
extracted_bas_Value_8_9.AsEnumerable()).Concat(
extracted_bas_Value_10_11_12_13.AsEnumerable()).Concat(
extracted_bas_Value_14_15.AsEnumerable()).CopyToDataTable()