in such case to import into datatable, you will have wirte statements to import the specific data applying filters while retrieving from excel that will be as good as working directly with the excel only, so I would like to recommend using excel directly.
yes, you can query excel as well, see if this post helps you
https://www.learnqtp.com/qtp-database-ch...ving-data/
yes, you can query excel as well, see if this post helps you
https://www.learnqtp.com/qtp-database-ch...ving-data/