AnsweredAssumed Answered

Filter Value - Writing to an Excel file using Javascript

Question asked by Ram2010mech on May 4, 2017
Latest reply on May 9, 2017 by Ram2010mech

Hi All,

 

I have tried the below code in Javascript to write a value in Excel file, but am below mentioned error while executing. Please help me on this.

When i execute the same script in eclipse , it is working fine.

 

Java script: 

 

String FILE_NAME = "C:/Users/Desktop/Test Data.xlsx";
XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.createSheet("Datatypes in Java");
Object[][] datatypes = {
{"Datatype", "Type", "Size(in bytes)"},
{"int", "Primitive", 2},
{"float", "Primitive", 4},
{"double", "Primitive", 8},
{"char", "Primitive", 1},
{"String", "Non-Primitive", "No fixed size"}
};

int rowNum = 0;

for (Object[] datatype : datatypes) {
Row row = sheet.createRow(rowNum++);
int colNum = 0;
for (Object field : datatype) {
Cell cell = row.createCell(colNum++);
if (field instanceof String) {
cell.setCellValue((String) field);
} else if (field instanceof Integer) {
cell.setCellValue((Integer) field);
}
}
}

FileOutputStream outputStream = new FileOutputStream(FILE_NAME);
workbook.write(outputStream);
workbook.close();

 

Error Message:

 


============================================================================
| Error in Script
============================================================================
| Step: Write to an Excel
----------------------------------------------------------------------------
| Message: Sourced file: inline evaluation of: ``String FILE_NAME = "/C:/Users/Desktop/Test Data.xlsx"; XSSF . . . '' : Typed variable declaration : Class: XSSFWorkbook not found in namespace : at Line: 2 : in file: inline evaluation of: ``String FILE_NAME = "/C:/Users/Desktop/Test Data.xlsx"; XSSF . . . '' : XSSFWorkbook

----------------------------------------------------------------------------
| Trapped Exception: Sourced file: inline evaluation of: ``String FILE_NAME = "/C:/Users/Desktop/Test Data.xlsx"; XSSF . . . '' : Typed variable declaration : Class: XSSFWorkbook not found in namespace : at Line: 2 : in file: inline evaluation of: ``String FILE_NAME = "/C:/Users/Desktop/Test Data.xlsx"; XSSF . . . '' : XSSFWorkbook

| Trapped Message: bsh.EvalError: Sourced file: inline evaluation of: ``String FILE_NAME = "/C:/Users/Desktop/Test Data.xlsx"; XSSF . . . '' : Typed variable declaration : Class: XSSFWorkbook not found in namespace : at Line: 2 : in file: inline evaluation of: ``String FILE_NAME = "/C:/Users/Desktop/Test Data.xlsx"; XSSF . . . '' : XSSFWorkbook

----------------------------------------------------------------------------
STACK TRACE
bsh.EvalError: Sourced file: inline evaluation of: ``String FILE_NAME = "/C:/Users/Desktop/Test Data.xlsx"; XSSF . . . '' : Typed variable declaration : Class: XSSFWorkbook not found in namespace : at Line: 2 : in file: inline evaluation of: ``String FILE_NAME = "/C:/Users/Desktop/Test Data.xlsx"; XSSF . . . '' : 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
============================================================================

 

Please guide me on this.

 

Thanks in Advance

Ram

Outcomes