Posted: 4 Sep 2017 11:32 EDT Last activity: 16 Oct 2018 12:03 EDT
Filtering Excel Sheet - Robotic Automation
I am trying to perform a simple Excel file processing automation. So far i have built the automation to open the workbook and read the content using Replace table method of the LookupTable component which i found in the Toolbox. But to apply filter, i guess i have to include a TableView component. I am not able to find the that component in my toolbox. Am i missing something?
Please let me know how to proceed from this point. Thanks in advance.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Although i was able to get the above component, i am still struggling to perform a simple filter of the excel sheet content. I have attached my automation along with the sample excel sheet that i am using for filtering. Please let me know if what i am doing is correct. Also, do add if that is the right way of filtering data or if there are any other simpler ways to do it.
Also this automation gives me an error message on execution. I have attached the error message as well.
I am not getting the error message anymore. I guess the system was trying to understand which worksheet to keep the res correctionlt from the GetTable Method. Now i am able to create the file. Problem is that the file that gets created is empty. Am not sure what i am missing here.
Would be great if someone could suggest a correction to the attached automation.
Have attached the final automation file where i get the data from a certain file and perform filtering on top of that and saving the result of the filtering into another file. Am sure it's pretty simple. But if someone out there is struggling the way i did, this might help you.