Hi Anis,
Thanks for your reply on my post.
I am aware of the VBO and filter kind of thing once we extract the full Work Sheet into my desktop.
but this scenario is that i need to filter out the required data on the website itself before extracting into my collection.
I want to extract the excel data for a fixed range based on filter criteria before extracting it to collection.
here id my requirement that i need to extract the data which is "San Francisco".
attaching the excel snapshot
with the link...
Hi, i recently came across this question.
Can we extract the excel data which is in particular color (eg., Red, Yellow, Etc).
I tried using the General way which is Get WS as Collection. but we get the complete data.
We need to filter out the excel data before coming into collection itself...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.