How to remove multiple columns based on their names from an excel?

Help Studio
#1

I have an excel file that has multiple empty columns, how can I remove those empty columns from this
OrderSummaries.xls (11.3 KB)
s excel file

#2

Hey

can you give a try with this example?
Main.xaml (7.7 KB)

Regards

#3

@fernando_zuluaga
getting this error

image

#4

Hey you should change the path of the documents in the read range activity and write range activity

Regards!

1 Like
#5

Hey!

As I don’t know if these columns will always come blank, I created a workflow that will analyze all your columns and them check if the number of blank values are equal to the total rows, if its equal then the robot will delete the column.
In the end the robot will create a file_Filtered.xls

You can use it for other excel files too, just change the file path
Here is the code:
RemoveEmptyColumns.zip (74.8 KB)

1 Like
#6

This error occurs when the “Read Range” activity from the modern is used to read a .xls file
You can just change this Read Range to the Excel Application Scope + Read Range from the classic.

1 Like
#7

thanks
@fernando_zuluaga
@imloan

1 Like