Question
How to filter the data from Excel sheet in openspan
Hi Team,
Could you please let us know the easiest way to filter the data from the data from excel sheet. Any other alternatives that are provided in openspan.
In the Automation attached in the snapshot I am trying to read the data from excel and load it into lookup table and then want to load this lookup table into tableview and from here trying to filter the data and then load into gridview or into another excel sheet. But I am struck up at initial loading of data exporting from excel to lookup table am getting error. Please help me what I am missing here.
Please find the attached snapshots of Automation and Excel sheet and the error.
Regards,
Jyothi
**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.
Hi Jeff,
Thanks for the reply, I am able to load the data into lookup table now. If any details please let me know about how to filter the data after passing the data to lookup table to table view or let me know any other alternatives for filtering the data from Excel and load it.
To filter a TableView add a Filter statement. Then when you use the ApplyFilter method you can filter the table.
Once you have filtered the data, you can use the column properties to access the values of the row.
where can i find the column property of tableview? I can't seem to find it
where can i find the column property of tableview? I can't seem to find it
I have subsequent question to this post, that how we can import the data from sheet without mentioning start and end range.
The problem is that the table you are exporting does not have columns named the same as your Lookup Table. The simplest way to fix this is to add headers to your Excel sheet that match your columns in the Lookup Table. Then change your export to include the header row - make CreateHeader true - this will cause the table columns to be named by the headers. Once the output table from your export matches your Lookup Table, the rest of your automation should work.
Check out my Excel post for more information.