I’m new to UiPath, trying to filter an Excel file and write the output to a new Excel.
I have been reading all kind of threads and articles but couldn’t find a straight answer to this task which I thought to be a simple one.
-
I tried using ‘Filter Table’ activity, but this requires a name for the table. Is there a possibility to create the table name dynamically and not manually inside Excel?
-
I tried to use Datatable.Select() that returns array of DataRow, then add it to a datatable and write it to Excel but no success. Many are recommending to read this article as an example:
https://www.uipath.com/kb-articles/how-to-filter-a-data-table
I followed all the steps in the article but i got the following error:
For Each: Unable to cast object of type ‘System.Double’ to type ‘System.String’
Any idea how solve this issue or just any simple example about filtering Excel and writing the output to another Excel file?