jxl导出EXCEL保存文件路径的问题,2000下没有问题,xp下面就存在问题
tcmis 2008-08-04 03:48:03 我的应用名是:amis
我现在想把导出的文件放到我的amis/exportFiles文件夹下面,用下面的方法,在2000下面是可以导出并放到exportFiles下面,但在xp环境下面就是不行,报下面的错误,请问高手怎么解决,谢谢
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: Servlet execution threw an exception
com.jrosion.common.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:72)
root cause
-----------------------------------------------------
try {
// 创建一个新的可写入的excel文件
String filepath = "../webapps/amis/exportFiles/" + filename;
WritableWorkbook newExcel = Workbook.createWorkbook(new File(
filepath));
WritableSheet sheet = newExcel.createSheet("sheet1", 0);
sheet.addCell(new Label(0, 0, "序号"));
sheet.addCell(new Label(1, 0, "姓名"));
sheet.addCell(new Label(2, 0, "部门"));
// 把List数据导出到Excel文件
for (int r = 0; r < data.size(); r++) {
AtEmployeeWages atEmployeeWages = (AtEmployeeWages) data.get(r);
sheet.addCell(new Label(0, r + 1, String.valueOf(r + 1)
.toString()));
sheet.addCell(new Label(1, r + 1, atEmployeeWages.getName()));
sheet
.addCell(new Label(2, r + 1, atEmployeeWages
.getDepName()));
}
// 写入Excel工作表
newExcel.write();
// 关闭Excel对象
newExcel.close();
System.out.println("Export file sucess!");
result = true;
} catch (Exception e) {
this.setErrorMsg(e.getMessage());
System.out.println("export file failure");
result = false;
}
return result;