Thanks Eric...
I have tried with the above script, and got the below error. Can you please help me on this.
===========================================================================
| Error in Script
============================================================================
| Step: Write to an Excel
----------------------------------------------------------------------------
| Message: Sourced file: inline evaluation of: ``File excel = new File("C:/Users/Desktop/CreditCardExpense.xlsx"); . . . '' : Typed variable declaration : Class: XSSFWorkbook not found in namespace : at Line: 4 : in file: inline evaluation of: ``File excel = new File("C:/Users/1518408/Desktop/CreditCardExpense.xlsx"); . . . '' : XSSFWorkbook
----------------------------------------------------------------------------
| Trapped Exception: Sourced file: inline evaluation of: ``File excel = new File("C:/Users/Desktop/CreditCardExpense.xlsx"); . . . '' : Typed variable declaration : Class: XSSFWorkbook not found in namespace : at Line: 4 : in file: inline evaluation of: ``File excel = new File("C:/Users/1518408/Desktop/CreditCardExpense.xlsx"); . . . '' : XSSFWorkbook
| Trapped Message: bsh.EvalError: Sourced file: inline evaluation of: ``File excel = new File("C:/Users/Desktop/CreditCardExpense.xlsx"); . . . '' : Typed variable declaration : Class: XSSFWorkbook not found in namespace : at Line: 4 : in file: inline evaluation of: ``File excel = new File("C:/Users/1518408/Desktop/CreditCardExpense.xlsx"); . . . '' : XSSFWorkbook
----------------------------------------------------------------------------
STACK TRACE
bsh.EvalError: Sourced file: inline evaluation of: ``File excel = new File("C:/Users/Desktop/CreditCardExpense.xlsx"); . . . '' : Typed variable declaration : Class: XSSFWorkbook not found in namespace : at Line: 4 : in file: inline evaluation of: ``File excel = new File("C:/Users/1518408/Desktop/CreditCardExpense.xlsx"); . . . '' : XSSFWorkbook
at bsh.BSHAmbiguousName.toClass(BSHAmbiguousName.java:73)
at bsh.BSHType.getType(BSHType.java:154)
at bsh.BSHTypedVariableDeclaration.eval(BSHTypedVariableDeclaration.java:75)
at bsh.Interpreter.eval(Interpreter.java:664)
at bsh.Interpreter.eval(Interpreter.java:758)
at bsh.Interpreter.eval(Interpreter.java:747)
at com.itko.lisa.test.ScriptExecHandler.executeScript(ScriptExecHandler.java:636)
at com.itko.lisa.test.ScriptExecHandler.executeScriptOld(ScriptExecHandler.java:528)
at com.itko.lisa.test.ScriptNode._execute(ScriptNode.java:126)
at com.itko.lisa.test.ScriptNode.execute(ScriptNode.java:103)
at com.itko.lisa.test.TestNode.executeNode(TestNode.java:981)
at com.itko.lisa.test.TestCase.execute(TestCase.java:1283)
at com.itko.lisa.test.TestCase.execute(TestCase.java:1198)
at com.itko.lisa.test.TestCase.executeNextNode(TestCase.java:1183)
at com.itko.lisa.editor.WalkThruPanel.prepAndExecNode(WalkThruPanel.java:1050)
at com.itko.lisa.editor.WalkThruPanel.access$900(WalkThruPanel.java:70)
at com.itko.lisa.editor.WalkThruPanel$10.doCallback(WalkThruPanel.java:963)
at com.itko.util.swing.panels.ProcessingDialog$2.run(ProcessingDialog.java:194)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: Class: XSSFWorkbook not found in namespace
at bsh.Name.toClass(Name.java:664)
at bsh.BSHAmbiguousName.toClass(BSHAmbiguousName.java:71)
... 18 more
============================================================================