I’m importing the following spreadsheet into a data table (and various similar spreadsheets) using the UiPath.Excel.Activities.ReadRange activity
As you can see, there are a number of columns that start Z, and some of these columns may have duplicate column names.
In these cases, I want to add the values together, and only have one column in the data table for that heading. So in the example above, the values for Z54 would be added, leaving just a single Z54 column.
I need the headers in the datatable to be the headers in the spreadsheet, so I can’t uncheck the “Add Headers” in options on the ReadRange Excel activity.
Is there a simple way around this? Thanks in advance!