How to remove whole column if Header is Blank in excel

[shaik.muktharvalli1 (shaik muktharvalli)]

How to remove whole column if Header is Blank in excel

Condition: Without Knowing Index of Column

Thank:
Shaik Muktharvalli

[pravallikapaluri]

Hi @shaik.muktharvalli1

Check the thread,It might help you

I want to remove entire column if balank header or entire column blank then have to remove entire column without knowing the index

[image] if balank header or entire column blank then have to remove entire column

Hope it helps!!

[vrdabberu (Varunraj Dabberu)]

Hi @shaik.muktharvalli1

Please find the below thread.

I want to remove entire column if balank header or entire column blank then have to remove entire column without knowing the index

Hey @shaik.muktharvalli1 , When you read a datatable from excel and the column headers are empty, then the column headers are converted to Column1, Column2 and so on. So to remove those, columns you can use [image] Note:- When reading from excel AddHeaders should be enabled

Hope it helps!!

[mkankatala (Mahesh Kankatala)]

Hi @shaik.muktharvalli1

=> Use read range with add headers uncheck and do not give any range.
=> Now use for loop with dt.Columns
=> Inside the loop use if condition with

String.IsNullOrEmpty(dt.Rows(0)(currentItem.ColumnName).ToString) OrElse dt.AsEnumerable.Where(function(x) Not String.IsNullOrEmpty(x(currentitem.ColumnName").ToString)).Count=0

=> On then side use delete column activity

Hope it helps!!

[pravallikapaluri]

Hi @shaik.muktharvalli1

[shaik.muktharvalli1 (shaik muktharvalli)]

Thank You @pravallikapaluri