Deleting Colunms form Excel

activities

#1

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)


#2

Hi @kalyani,

Check this link for a post did the same,


#3

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


#4

Thank u so much,

It worked