S2SH+jxl.jar实现导出Excel文档
1.新建项目，搭好S2SH框架，导入jxl.jar包。
2.ExcelAction.java代码片段
private UserDAO userDAO;
//添加get,set方法，此处省略
public String exportUserExcel() throws Exception{
HttpServletResponse response = ServletActionContext.getResponse();
response.reset();//不知道是不是必须要写这一句，未测试
response.setCharacterEncoding("UTF-8");
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition","attachment;filename=DefaultFileName.xls");
OutputStream out = response.getOutputStream();
try{
WritableWorkbook workbook = Workbook.createWorkbook(out);//构建工作薄对象
WritableSheet ws = workbook.createSheet("SheetName",0);//构建工作
表
关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf
WritableFont wf = new WritableFont(WritableFont.TIMES,10,WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE,
jxl.format.Colour.BLACK);//设置字体格式
WritableCellFormat wcf = new WritableCellFormat(wf);//创建格式化对象实例
wcf.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//垂直居中
wcf.setAlignment(Alignment.CENTRE);//水平居中
//工作表标
题
快递公司问题件快递公司问题件货款处理关于圆的周长面积重点题型关于解方程组的题及答案关于南海问题
行(new Label(列,行,内容,格式))
ws.addCell(new Label(0,0,"ID",wcf));
ws.addCell(new Label(1,0,"用户名",wcf));
ws.addCell(new Label(2,0,"密码",wcf));
/*设置单元格宽度
ws.setColumnView(0,20);
ws.setColumnView(1,40);
ws.setColumnView(2,40);*/
//从数据库读取数据
List
dataList = new List();
List userList = userDAO.findAll();
for(User temp:userList){
Object[] user = {temp.getID(),temp.getUserName(),temp.getPassword()};
dataList.add(user);
}
//向工作表添加数据
for(int i=0;i
...
4.applicationContext.xml
...
浙公网安备 33021202002483