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.
Use remove DataColumn Activity.
You can also use Invoke Method
Can you show me some demo?
How can we do in sheet, its not working there, can you please help me on it.
Please find that attached files.
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.
Vijay Kumar C.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.