Hello all,
I am trying to Write one value from TC A to excel and that value is used by my TC B
I have done the excel plugin installation.
But while implementing the same in code i am getting below error for unable to resolve shhet and Workbook classes.
import org.apache.poi.ss.usermodel.Sheet
import org.apache.poi.ss.usermodel.Workbook
Added external jar file and tried with open declaration but its unable to resolve the class. please suggest on this…
06-26-2019 12:03:08 PM Test Cases/Emma_AddNewClient/Add_New_client
Elapsed time: 0.868s
Test Cases/Emma_AddNewClient/Add_New_client FAILED.
Reason:
org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:
file:/C:/Users/SShanmugam/Katalon%20Studio/Emma/Scripts/Emma_AddNewClient/Add_New_client/Script1561467628469.groovy: 153: unable to resolve class Workbook
@ line 153, column 10.
Workbook workbookXLS = ExcelKeywords.getWorkbook("D:\\Test Data\\ADDCDD.xls")
^
file:/C:/Users/SShanmugam/Katalon%20Studio/Emma/Scripts/Emma_AddNewClient/Add_New_client/Script1561467628469.groovy: 155: unable to resolve class Sheet
@ line 155, column 7.
Sheet sheet1 = workbookXLS.getSheet("ClientDetails")
^
2 errors
at com.kms.katalon.core.main.ScriptEngine.getScript(ScriptEngine.java:199)
at com.kms.katalon.core.main.ScriptEngine.run(ScriptEngine.java:194)
at com.kms.katalon.core.main.ScriptEngine.runScriptAsRawText(ScriptEngine.java:119)
at com.kms.katalon.core.main.TestCaseExecutor.runScript(TestCaseExecutor.java:337)
at com.kms.katalon.core.main.TestCaseExecutor.doExecute(TestCaseExecutor.java:328)
at com.kms.katalon.core.main.TestCaseExecutor.processExecutionPhase(TestCaseExecutor.java:307)
at com.kms.katalon.core.main.TestCaseExecutor.accessMainPhase(TestCaseExecutor.java:299)
at com.kms.katalon.core.main.TestCaseExecutor.execute(TestCaseExecutor.java:233)
at com.kms.katalon.core.main.TestSuiteExecutor.accessTestCaseMainPhase(TestSuiteExecutor.java:133)
at com.kms.katalon.core.main.TestSuiteExecutor.accessTestSuiteMainPhase(TestSuiteExecutor.java:116)
at com.kms.katalon.core.main.TestSuiteExecutor.execute(TestSuiteExecutor.java:83)
at com.kms.katalon.core.main.TestCaseMain.startTestSuite(TestCaseMain.java:157)
at com.kms.katalon.core.main.TestCaseMain$startTestSuite$0.call(Unknown Source)
at TempTestSuite1561546986455.run(TempTestSuite1561546986455.groovy:35)