Delete column of the sheet

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

@James90

Use remove DataColumn Activity.

You can also use Invoke Method

1 Like

@Vijay_Tulsalkar
Can you show me some demo?

@James90,

Please find the attached file for your reference.

Main.xaml (11.0 KB)

Hi @lakshman
How can we do in sheet, its not working there, can you please help me on it.

@James90,

Please find that attached files.

Main.xaml (7.8 KB)
New Microsoft Excel Worksheet.xlsx (9.2 KB)

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

@lakshman
Thank you

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.