Hi All, I am trying to add 3 new columns with headers to an existing data table and also write to the excel in those columns based on a condition. So i have:
- Excel Scope
- Read Range
- Insert/Delete Columns.
Then it has to go through other processes and based on those results: if the user Id is found then:
- write “complete” in the Status column (the new column 1),
- write “todays date” in the Date column (new column 2),
- write “yes” in the PreExisting column (new column 3)
Also i need to loop through each row with the 3 write cells. Right now it does not loop through any cells and it writes the data outside of the correct column.