https://community.blueprism.com/t5/Product-Forum/How-to-delete-rows-non-empty-from-excel-sheet-work-sheet/m-p/54799#M9219 Hello All,   can some one help me on below scenario.   I need to delete some of the records from excel sheet.   Thanks in advance   With Kind Regards           Thu, 01 Feb 2018 04:31:00 GMT VenkatRamana 2018-02-01T04:31:00Z https://community.blueprism.com/t5/Product-Forum/How-to-delete-rows-non-empty-from-excel-sheet-work-sheet/m-p/54799#M9219 Hello All,   can some one help me on below scenario.   I need to delete some of the records from excel sheet.   Thanks in advance   With Kind Regards           Thu, 01 Feb 2018 04:31:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-delete-rows-non-empty-from-excel-sheet-work-sheet/m-p/54799#M9219 VenkatRamana 2018-02-01T04:31:00Z https://community.blueprism.com/t5/Product-Forum/How-to-delete-rows-non-empty-from-excel-sheet-work-sheet/m-p/54800#M9220 If you the records as static, and you only want to use the VBO 1) Read excel to a collection 2) Delete the sheet 3) Delete the rows in collection 4) Write it back to the Excel. Thu, 01 Feb 2018 12:58:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-delete-rows-non-empty-from-excel-sheet-work-sheet/m-p/54800#M9220 11235813sk 2018-02-01T12:58:00Z https://community.blueprism.com/t5/Product-Forum/How-to-delete-rows-non-empty-from-excel-sheet-work-sheet/m-p/54801#M9221   Could you provide a better performance solution? That is time consuming. I'd like avoid read to a collection, there are many columns that I dont' need How does work the DELETE (Left/Up)? The document about says nothing. Thanks   Sat, 10 Feb 2018 00:36:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-delete-rows-non-empty-from-excel-sheet-work-sheet/m-p/54801#M9221 mc 2018-02-10T00:36:00Z https://community.blueprism.com/t5/Product-Forum/How-to-delete-rows-non-empty-from-excel-sheet-work-sheet/m-p/54802#M9222 I believe you can use Delete method. Just provide the correct shift value. you can start searching from this point. https://msdn.microsoft.com/en-us/vba/excel-vba/articles/range-delete-me…   Tue, 13 Feb 2018 19:16:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-delete-rows-non-empty-from-excel-sheet-work-sheet/m-p/54802#M9222 TomaszAdamski 2018-02-13T19:16:00Z