how to loop data from multiple sheets of datasource

Question

how can i loop the data from Excel Datasource from multiple sheets&nbsp;
&nbsp;
I have single Excel File with multiple sheets like (Sheet1, Sheet2)&nbsp;
&nbsp;
Currently I am using as datasource step with Excel File and Sheet1&nbsp;
but where as i need to use all the data from Sheet 1 than sheet 2&nbsp;

radford · Accepted Answer

I'm not sure if this is the best way, and it does assume all of your sheets are the same,&nbsp;but you could achieve this with two nested loops. The "Outer" loop can be a simple grid source which lists your sheet names, and then your "Inner" loop iterates though the Excel rows. You then set the work sheet name via Groovy within the "Outer" loop, but before the "Inner" loop. Looking something like this:

Everything should be self explanatory, except the "Set Current Sheet" step whose code is:
&nbsp;
def sheetName = context.expand( '${DataSource - Grid - Sheet Name#SheetName}' )
log.info('Current sheet name = "' + sheetName + '"')

dataSourceTestStep = testRunner.getTestCase().getTestStepByName("DataSource - Excel")
log.info('Data source type = ' + dataSourceTestStep.getDataSourceType())

excelDataSource = dataSourceTestStep.getDataSource()
excelDataSource.setWorksheet(sheetName)
The key thing here is the Excel data source, whose class is ExcelDataSource, the linked&nbsp;API docs&nbsp;provide full details.
&nbsp;

Forum Discussion

how to loop data from multiple sheets of datasource

Recent Discussions

Update API definition : Error with the json format

Test result Pass when data source times out

Run Test Case properties not populating for Data Source based items

Related Content

How to select Excel sheet in python?

One datasource (Excel) and Multiple Test Cases

using excel spread sheet with testcomplete