Deleting Colunms form Excel

[kalyani (KPandala)]

HI
I want to remove all the columns from an excel file except the First column, I dont want to use the foreach activity.

What i tried is i am attaching the XmalNewMain.xaml (10.4 KB)

[sarathi125 (Parthasarathi)]

Hi @kalyani,

Check this link for a post did the same,

How to remove multiple columns from an excel datatable?

@Snowman, You can’t give multiple column Index/Name in Remove Data Column activity. Whereas we have an alternate with the combination of LINQ->Datatable Assign → String Array arrayOfColumnsToBeRemoved = {“Column1”,“Column2”} Assign → Select a Array of ColumnNames without these columns from the datatable dt with the query string Array arrayOfColumnsToBeSelected = (From col in dt.Columns.Cast(of System.Data.DataColumn) where not(arrayOfColumnsToBeRemoved.Contains(col.ColumnName)) Select …

[balupad14 (Balamurugan)]

Hi @kalyani,

Here I have attached a sample to delete the entire column. The sample contains only one column delete. By using the for loop you can able to delete all the columns without losing the format.

ExcelDeleteColumn.zip (8.1 KB)

Regards
Balamurugan.S

[kalyani (KPandala)]

Thank u so much,

It worked