java web项目中编译正常,用was或者jenkins打包编译出错
티나 2018-12-10 10:46:26 InputStream is = null;
OutputStream os = null;
HSSFWorkbook workbook = null;
boolean flag = true;
SOURCE_EXCEL_FILE_PATH=path;
// SOURCE_EXCEL_FILE_PATH = CommonTools.convertListToStr(CacheTools.getSysParmArrayInfor("AAAAAA", "EXCELADDRESS"), ";");
String isfile=SOURCE_EXCEL_FILE_PATH+"nbreport_template.xls";
try {
is = new FileInputStream(new File(isfile));
workbook = new HSSFWorkbook(is);
is.close();//后续需要对此文件进行操作,先close输入流
System.out.println("SOURCE_EXCEL_FILE_PATH============:"+SOURCE_EXCEL_FILE_PATH);
//取日期时分防止文件被占用无法继续
resultExcelFile = SOURCE_EXCEL_FILE_PATH+"data_" + getToday() + ".xls";
os = new FileOutputStream(new File(resultExcelFile));
HSSFSheet sheet = workbook.getSheet("Summary");
//公式自动计算 打开前计算
workbook.getCreationHelper().createFormulaEvaluator().evaluateAll();
// //公式自动计算 打开excel的时候再计算
// sheet.setForceFormulaRecalculation(true);
workbook.write(os);
os.flush();
os.close();
} catch(Exception e) {
e.printStackTrace();
flag = false;
} finally{
if(is != null) {
try {
is.close();
} catch (IOException e) {
e.printStackTrace();
flag = false;
}
}
if(os!= null){
try {
os.close();
} catch (IOException e) {
e.printStackTrace();
flag = false;
}
}
}
编译报错
[exec] [javac]D:\JENKINS_HOME\workspace\nbsoasis-base\rtcfile\nbsoasis_build\rtcfile\NBSOA_COMP\nbsoa_COMP\Source\JavaSource\aia\cn\integration\nba\commonService\newCaseQuery\service\ReportQueryList.java:400: error:cannot find symbol
[exec] [javac] workbook.getCreationHelper().createFormulaEvaluator().evaluateAll();
[exec] [javac] symbole: method getCreationHelper()
[exec] [javac] location: variable workbook of type HSSFWorkbook
在线急等,请各位大牛帮帮忙