How to remove empty columns from excel

Hi team,

I have an excel & as a part of formatting I need to remove empty columns.
The column numbers are not fixed, any column could be empty at a point of time.
How do we handle such scenarios then?


Did you had the chance to work with Filter Datatable activity?

The scenario can be:

  1. Read Excel
  2. Filter Empty columns
  3. Remove empty columns
  4. Write range the resulted filtered datatable.

I hope it helps.