[DataDriven] Change sheet of an Excel file

Product Forums Katalon Studio
,
#1

Hello!

Version
Katalon 5.4.2.

**Problem
**I try to change a sheet of my Excel file with the script view.
My current code is

import static com.kms.katalon.core.testdata.TestDataFactory.findTestDataimport com.kms.katalon.core.testdata.ExcelDataExcelData data = findTestData("Data").changeSheet("SheetA")

However data value is null.

Someone has any idea?

Thank’s,

#2

**Solved
**changeSheet(“SheetA”) is a void method.

**New code:
**

ExcelData data = findTestData("Data")changeSheet("SheetA")
2 Likes
How to read values from another sheet in Test data Excel sheet
#3

Hi there,

Still getting it as deprecated…

ExcelData TD1 = findTestData(“testdata(1)”)

changeSheet(“Sheet2”)

please help…

#4

Is there a working solution

#5

Yes this worked for me

#6