If i want to read data from 2nd worksheet in excel file. How would i do that ?below code, reading data from sheet1 default.String strval= findTestData(“TESTDATA_XYZ”).getValue(1,1)i have many worksheets(sheet1, sheet2, sheet3). i need to read data from sheet2. is there any method present to recognize the worksheets?
hi,
check this chain
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Work with multiple sheet on Excel file | 0 | 772 | November 19, 2016 | |
| Read Test Data from Excel | 6 | 5576 | September 2, 2020 | |
| Work with multiple sheet on Excel file | 9 | 5314 | May 29, 2020 | |
| Work with multiple sheet on Excel file | 1 | 401 | November 21, 2016 | |
| How to read values from another sheet in Test data Excel sheet | 2 | 4090 | February 4, 2019 |