I'm currently taking an initial look at ActiveData and am wondering how I can access data across a number of worksheets within a .xls?
You have to specify the worksheet name on the options tab of the ActiveData asset. I don't know of a way to specify the sheet name at runtime, but a work around could be to create multiple ActiveData assets each with the individual sheet required.
Using TestPartner 6.0 Build 462
Test Scripts & Visual Tests