Removing empty columns from data table

[ramya_anbazhagan (Ramya)]

Hi There,

I am reading a excel file without headers and i want to get the column count.

Read excel adds empty columns at the end and i am getting the wrong column count. So, how to remove the empty columns at the end and get the correct column count?

TIA

[Baskar_Gurumoorthy]

Hi @ramya_anbazhagan

please refer the below thread for removing empty columns.

Remove columns are empty

I have a datatable which contains 180 Colums. Out of which some columns are having null values in all the rows. I want to remove those columns. e.g. dtTemp column1 Column2 Column3 Column4 Column5 001 ABC 5 002 XYZ 6 003 PQR 7 I want to remove Column4 and column5. I am facing this error [image]

after removing you can get the column count using below syntax.
yourdatatable.columns.count

hope it helps!!!

[ramya_anbazhagan (Ramya)]

Thanks Baskar, it worked!

[Baskar_Gurumoorthy]

Thats Great!!! please mark it as solution.

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…