https://community.blueprism.com/t5/Product-Forum/How-to-delete-multiple-empty-columns-in-collection/m-p/50003#M5306 I have 1000 rows and 200 columns in excel sheet which I am copying into collection (using Get worksheet as collection). Out of 200 columns, around 80 are empty. How should I delete those empty columns? If I use 'delete column' action, it will ask for column name but I want delete all null columns in one go. Please suggest. Tue, 26 Sep 2017 18:32:00 GMT Shwetavd 2017-09-26T18:32:00Z https://community.blueprism.com/t5/Product-Forum/How-to-delete-multiple-empty-columns-in-collection/m-p/50003#M5306 I have 1000 rows and 200 columns in excel sheet which I am copying into collection (using Get worksheet as collection). Out of 200 columns, around 80 are empty. How should I delete those empty columns? If I use 'delete column' action, it will ask for column name but I want delete all null columns in one go. Please suggest. Tue, 26 Sep 2017 18:32:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-delete-multiple-empty-columns-in-collection/m-p/50003#M5306 Shwetavd 2017-09-26T18:32:00Z https://community.blueprism.com/t5/Product-Forum/How-to-delete-multiple-empty-columns-in-collection/m-p/50004#M5307 Use Collection Maipulation ""Get Collection Fields"" Action to get Column Names into a Collection. Loop the Column Names Collection To find weather the Column is completely Empty using ""collection Contains Value"" Action Get the output parameter from the ""collection Contains Value"" action and Make a decision if the output parameter is false then use the Action ""Delete Column"" to delete the particular row. This Logic can be used for collection containing any number of columns. Tue, 26 Sep 2017 21:28:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-delete-multiple-empty-columns-in-collection/m-p/50004#M5307 ArchanaSepuru1 2017-09-26T21:28:00Z https://community.blueprism.com/t5/Product-Forum/How-to-delete-multiple-empty-columns-in-collection/m-p/50005#M5308 I'd recommend reading the Excel file using an OLEDB query. That way you can actively select the columns you want and ignore the ones you don't. Or in Excel, read across the first data row to identify empty columns for deletion. Tue, 26 Sep 2017 22:38:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-delete-multiple-empty-columns-in-collection/m-p/50005#M5308 John__Carter 2017-09-26T22:38:00Z https://community.blueprism.com/t5/Product-Forum/How-to-delete-multiple-empty-columns-in-collection/m-p/50006#M5309 Another option is to simply write a page in Excel VBO to get only the dataset with columns with values in. The UsedRange of Excel(used in Excel VBO) can have a larger area than the actual data Range. Wed, 27 Sep 2017 04:51:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-delete-multiple-empty-columns-in-collection/m-p/50006#M5309 Anton__Hosang 2017-09-27T04:51:00Z