Hi Marina,
Glad your issue got resolved. Definitely that will also work for you, the query will be like:
"SELECT [RequestNo] ,[OrderNo], [Parts Name] FROM [Sheet1$]"
Just remember the above query always will work whenever you data is starting from the beginning of the sheet, that is "A1" cell. In case your headers, fall somewhere at the middle, the you need to modify the From part of the query.
Let us suppose if the headers go from B2 till E then the query would have been modified as:
"SELECT [RequestNo] ,[OrderNo], [Parts Name] FROM [Sheet1$B2:E]"
Similarly, if you want to put a filter as well while selecting the columns you can do by using a WHERE clause, then your query gets modified like this:
"SELECT [RequestNo] ,[OrderNo], [Parts Name] FROM [Sheet1$] WHERE [INPUT] = '@'"
Considering that INPUT is the name of the column where this value '@' resides.
Hope that helps to clear your doubts
🙂------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily
Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website:
https://devneet.github.io/Email: devneetmohanty07@gmail.com
----------------------------------
------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please provide a big thumbs up so that the others members in the community having similar problem statement can track the answer easily in future.
Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Technical Business Analyst,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
----------------------------------