Delete specified columns from specified sheets in excel

Help
, ,
1

sheets.xlsx (9.8 KB) Hey guys,
I want to delete specified columns from specific sheets in this Excel file.

I want to delete columns from (F:till end) in the sheets names starting as WCK (i.e, WCK1001 and WCK1005). Please do share some help. Thank you. @balupad14 @Palaniyappan @sandipauti

2

Hi @NiranjanKN

Assign str file=Directory.getFiles(inputffilepath)
For each item in strfiles
Use excel new.Application scope
Dt=Dt.Select(“[column name]<>‘’”). copy todatatable ()

Thanks
Ashwin.S

1 Like
3

Hi @NiranjanKN,

Take a look these

Regards
Balamurugan.S

1 Like