I have an excel file in which there are atleast 15 worksheets and I want to import them into DataTable.I would like to know is it possible to import all the indiviual 15 worksheets?
Yes you can, if you have the same number of sheets in your test(Need to take care of the Global sheet).
The Other option is to change the default location.
Test Settings -> Resources -> Other Location.
you can use the importsheet statement to import individual sheets
Winds of Change
Thank you all for the response.I got the issue working and I apologize for the late response.