Is it possible to read multiple sheets of any workbook using the single datasource in ready api ?

Question

Hi,&nbsp;In ready api, we have provision to add data source and their we can select data source option from the drop down. Lets say i selected excel as an data source and add my excel sheet. I am able to add and successfully run the excel data source data and that too with out coding.&nbsp;Is it possible to read multiple sheets of any workbook using the single data-source in ready api ?&nbsp;Kindly let me know the steps for the same.&nbsp;&nbsp;Thanks,Himanshu&nbsp;&nbsp;

lucian · Answer

Hi,&nbsp;&nbsp;When you create an excel datasource you are prompted to select a worksheet so I don't think reading multiple worksheets using a single DataSource step is feasible without coding.&nbsp;But why do you want to do it using a single datasource step anyways?

shubhimu · Answer

Hi,&nbsp;Thanks for the reply. Actually our objective is to design a framework with minimum coding so that non technical person can also understand it easily.&nbsp;Although using POI i am able to achieve my purpose but if we can achieve this with out coding or minimum coding then that would be of great help.&nbsp;Thanks,Himanshu

groovyguy · Answer

While you cannot do this with a single Data Source, you can use multiple ones and if you set it up right, a Data Source Loop can ensure you are refreshing each one on a new pass.&nbsp;

sanj · Answer

You can do the following to select your appropriate excel sheet:For each sheet you will need a different data source

himanshutayal · Answer

Hi&nbsp;shubhimu&nbsp;You have to specify Worksheet Name and it will be same for 1 Data Source, if you want to get Data from different sheets then you need to add multiple datasource.&nbsp;My suggestion will be write a simple groovy code of around 10 lines to read data from excel sheet.&nbsp;look at the screenshot:

Forum Discussion

Is it possible to read multiple sheets of any workbook using the single datasource in ready api ?

Related Content

Groovy Automated DataSource Loopers

One datasource (Excel) and Multiple Test Cases

Code for groovy datasource

datasource-JDBC-Query

Load records from Datasource[Excel] into SOAP Request as multiple XML nodes

Recent Discussions

Sudh budh bar hshs the day of

Assert Step Not Executing All Assertions

Include external files (XML) for JDBC connection

Accessing database connection string from groovy test step

JDBC database connection pooling