I have two excel file and i need to update the Input data into Reporting excel sheet

I have two excel file and i need to update the Input data into Reporting excel sheetw.r.t each column. The column is not fixed in reporting sheet I need to add the condition if any new value is add in the Input sheet so i need to add that column in reporting sheet.See the sample output file for referance.

Reporting.xlsx (9.7 KB)
Sample Output.xlsx (9.7 KB)
Input.xlsx (8.3 KB)

Hello @Saransh_10!

you can check if a value from your input list is already a column in the Reporting excel, by reading both as DT, and then checking if each “row(“EC”).ToString” is inside ReportingDT.columns.

image

Attaching the small workflow I built below. If a value is not present, the bot will add a new column to the Reporting DT, with the correct name.

Last thing you’d need to do is add a row, with the numbers you want, on the correct column.
→ This can be easily done with an “Add Data Row” activity.

If your input file is large, For Each Row might not be the most efficient solution!

MegeData.zip (58.1 KB)