Hi Guys,
I wanted to add a new column named as “Status” in the excel (Data Table) .To write a status Fail or Pass after each transaction processing.
The number of columns can get vary always in the excel. i need to add the ‘status’ as a column name at the end before processing.
Let me know how to do this. Thank you!
Hi @vinutha1 ,
Use add to column activity, it will add column at the end
Hi @vinutha1
use ADD Data Column activity and create a column status Along with your current DT.
Regards
I did the same. But its not updating the column and not even showing any error.
Yup…am suppose to update. Before that i need to add the ‘status’ column so that later i can update the results of each transaction.
could be because your argument type for the column is object. Try changing to string
Add data column is like a temp column added to the datatable which re using to update try with updating with column name(“Status”) and write range the data table.
Hope Clear with the above explanation!
Regards
U mean, after add data column am supposed to use write range?
Tried…dint work
Please refer to the xaml below.
Main.xaml (6.8 KB)
New Microsoft Excel Worksheet.xlsx (8.4 KB)
I have created with working example of add data column.
Regards
Thanks a lot…it worked!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
