How to remove the empty columns

[lrtetala (Lakshman Reddy)]

Hi @anjani_priya

Please check this

How to remove columns from excel (old solutions unable to be opened sorry!)

@kidd Follow this to remove all empty columms For loop with dt.Columns Inside loop use filter datatable on dt and output into filtereddt and in condition use currentitem.ColumnName and select is empty Now use if condition filtereddt.Rowcount=0 On then side use remove data column and give the column name as currentitem.ColumnName and datatable as dt This will delete all columns in which all rows are empty Cheers

Regards,