jxl导出excel并下载
我有这样一段代码，是要导出excel并下载，请高手帮我看看错在什么地方？public String excelExport() throws Exception{
HttpServletRequest request = ServletActionContext.getRequest();
HttpServletResponse response = ServletActionContext.getResponse();
Workbook workbook = Workbook.getWorkbook(new File("D:\\test1.xls"));
Sheet sheet = workbook.getSheet(0);
double rowTotal = 0;
double colTotal = 0;
List<String> rowTotalList = new ArrayList<String>();
String rowContent;
try{
int col = sheet.getColumns();
int row = sheet.getRows();
String result[][] = new String;
Cell cell;
for (int i = 0; i < col; i++) {
for (int j = 0; j < row; j++) {
try {
cell = sheet.getCell(i, j);
result = cell.getContents();
} catch (Exception e) {
}
}
}
for (int i = 0; i < col; i++) {
for (int j = 1; j < row; j++) {
try {
//System.out.println(result);
} catch (Exception e) {
e.printStackTrace();
}
}
}
for (int j = 1; j < row; j++) {
//System.out.println(testjobid);
TestPerson tp = new TestPerson();
tp.setTestname(result);
tp.setEmail(result);
tp.setTelephone(result);
tp.setTestjob(testjobManager.get(testjobid));
testPersonManager.save(tp);
rowContent = "<td><div align='center'>" + result
+ "</div></td><td><align='center'>" + result
+ "</div></td><td><align='center'>" + result
+ "</div></td>";
rowTotalList.add(rowContent);
rowTotal = 0;
rowContent = null;
}
request.setAttribute("rowTotal", rowTotalList);
request.setAttribute("colTotal", colTotal);
workbook.close();
OutputStream os = response.getOutputStream();
String filename = "D:\\test.xls";
response.reset();
response.setHeader("Content-disposition", "attachment; filename=test.xls");
response.setContentType("application/msexcel");
}catch(Exception ex){
ex.printStackTrace();
}
return null;
}
页:
[1]