FileInputStream fs=new FileInputStream( dir );
//使用POI提供的方法得到excel的信息
POIFSFileSystem ps=new POIFSFileSystem(fs);
// 获取excel对象
HSSFWorkbook wb=new HSSFWorkbook(ps);
// 获取sheet页
HSSFSheet sheet = wb.getSheetAt(0);
// 获取行
HSSFRow row_1=sheet.getRow(0);
// 获取 格
HSSFCell row_1_cell_13 = row_1.getCell(13);
row_1_cell_13.setCellValue("设置的值")
。。。。。编辑excel内容
//下载
OutputStream output = null;
try {
HttpServletResponse response = getRequestContext().getRes();
response.setContentType("application/vnd.ms-excel");
response.setHeader("Expires", "0");
response.setHeader("Cache-Control", "must-revalidate, post-check=0, pre-check=0");
response.setHeader("Pragma", "public");
// 设置头时如果有中文需要用UrlEncode编码一下
response.setCharacterEncoding("UTF-8");
response.setHeader("Content-disposition","attachment;");
output = response.getOutputStream();
wb.write(output);
output.flush();
requestContext.setRequestComplete(true);
}
catch (Exception e) {
e.printStackTrace();
AlertAjaxMessage(e.getMessage());
}
finally {
if (output != null) {
try {
wb.close();
output.close();
}
catch (IOException e) {
e.printStackTrace();
}
}
}