Are there any activities or is there any way which can navigate and perform filtering within an excel sheet through uipath?
Read Range get the value is datatable and use filter DataTable activity
Thanks for the answer, i need to do more work within excel… For example, I need to remove some unwanted empty columns which have no headers within the excel sheet which was generated automatically by system. This excel sheet format will be same everytime so this removing unwanted columns is very useful. Please advise whether there is any way to do this?
Please advise is there
Can you share the Excel file if its not Confidential , or create a dummy excel with the scenario which you talking about.
there are many ways to get things done. just wanted to view the Excel Template
You can remove the columns using “Insert/Delete Columns” activity and to find the empty columns find it in the datatable and pass the column index to remove them. If you want to work more within the excel you can execute macros using “Invoke VBA” activity. Hope this helps.