Excel Plugin Unable to resolve class issue


#1

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.

image

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)