Hi @All
I would like to know, how can we delete column by the column name or column number, can anyone help on it, how to do?
Your help in this matter will be highly appreciated.
Thank you
Hi @James90
Please follow below steps to delete Excel column.
1) Use Excel Application Scope activity with Read Range to get sheet data into Datatable(DT1).
2) Use Remove Data Column Activity and provide column name which you want to delete and store the result in another datatablel(DT2).
3) Use Excel Application Scope activity with Write Range to get write the modified data(DT2) back to Excel file.
Regards,
Vijay Kumar C.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.