Hi Team,
I am trying to create CustomScript to create excel sheet in existing excel file.
But I am facing unable to resolve class org.apache.poi.xssf.usermodel.XSSFWorkbook error.
Can anyone give me suggestion.
I have download jar file of apache.poi and stored under in tomcat\lib
Script :
import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFSheet;
"
@CustomScriptAction(
input = [‘str_input_file_path’,‘sheet_name_filtered_employee’]
)
def CustomScriptAction(){
FileInputStream inFile = new FileInputStream(str_input_file_path);
XSSFWorkbook excelWorkBook = New XSSFWorkbook(file);
XSSFSheet excelSheet = excelWorkBook.createSheet(“sheet_name_filtered_employee”)
FileOutputStream outFile = New FileOutputStream(str_input_file_path);
excelWorkBook.write(outFile);
outFile.close()
}
"
Error :
Caused by: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:
Script4.groovy: 11: unable to resolve class org.apache.poi.xssf.usermodel.XSSFSheet
@ line 11, column 1.
import org.apache.poi.xssf.usermodel.XSSFSheet;
^
Script4.groovy: 12: unable to resolve class org.apache.poi.xssf.usermodel.XSSFWorkbook
@ line 12, column 1.
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
^
2 errors
Jar file :