JXL导出
来源:互联网 发布:二娃网络erwayun 编辑:程序博客网 时间:2024/05/20 16:43
@SuppressWarnings("unchecked")
public int writeExcelBo(java.util.List ve){
HttpServletResponse response=ServletActionContext.getResponse();
jxl.write.WritableWorkbook wwb=null;
try{
OutputStream os = response.getOutputStream();// 取得输出流
response.reset();
response.setHeader("Content-disposition", "attachment; filename="+new String("采集".getBytes("GB2312"),"8859_1")+".xls");// 设定输出文件头
response.setContentType("application/msexcel");// 定义输出类型
wwb=Workbook.createWorkbook(os);
int SIZE=ve.size();//总数
jxl.write.WritableSheet ws=null;
News book=null;
ws=wwb.createSheet("第1页",1);
int k=1;//页数
int j=0;//每页循环次数
for (int i = 0; i <SIZE; i++) {//循环总数
if (i<Constant.excelcount) {
j=i;
}else{
if (i>0&&i%Constant.excelcount==0) {//是否建立新页面
k=k+1;//页数加1
ws=wwb.createSheet("第"+k+"页",k);
}
if (i>=Constant.excelcount*(k-1)) {
j=i-Constant.excelcount*(k-1);//重新开始循环
}
}
book=new News();
book=(News) ve.get(i);
ws.addCell(new jxl.write.Label(0,0,"序号"));
ws.addCell(new jxl.write.Label(1,0,"标题"));
ws.addCell(new jxl.write.Label(2,0,"发布时间"));
ws.addCell(new jxl.write.Label(3,0,"来源网站"));
ws.addCell(new jxl.write.Label(4,0,"采集时间"));
//ws.addCell(new jxl.write.Label(5,0,"集合位置"));
ws.addCell(new jxl.write.Label(0,j+1,Integer.toString(j+1)));
ws.addCell(new jxl.write.Label(1,j+1,book.getTitle()));
ws.addCell(new jxl.write.Label(2,j+1,book.getPubdate().toString().substring(0, 10)));
ws.addCell(new jxl.write.Label(3,j+1,book.getWebsitename()));
ws.addCell(new jxl.write.Label(4,j+1,book.getCollentTime().toString().substring(0, 19)));
//ws.addCell(new jxl.write.Label(5,j+1,String.valueOf(i)));
}
wwb.write();
wwb.close();
return 1;
}catch(IOException e){
}catch(RowsExceededException e){
}catch(WriteException e){
}
return 0;
}
public int writeExcelBo(java.util.List ve){
HttpServletResponse response=ServletActionContext.getResponse();
jxl.write.WritableWorkbook wwb=null;
try{
OutputStream os = response.getOutputStream();// 取得输出流
response.reset();
response.setHeader("Content-disposition", "attachment; filename="+new String("采集".getBytes("GB2312"),"8859_1")+".xls");// 设定输出文件头
response.setContentType("application/msexcel");// 定义输出类型
wwb=Workbook.createWorkbook(os);
int SIZE=ve.size();//总数
jxl.write.WritableSheet ws=null;
News book=null;
ws=wwb.createSheet("第1页",1);
int k=1;//页数
int j=0;//每页循环次数
for (int i = 0; i <SIZE; i++) {//循环总数
if (i<Constant.excelcount) {
j=i;
}else{
if (i>0&&i%Constant.excelcount==0) {//是否建立新页面
k=k+1;//页数加1
ws=wwb.createSheet("第"+k+"页",k);
}
if (i>=Constant.excelcount*(k-1)) {
j=i-Constant.excelcount*(k-1);//重新开始循环
}
}
book=new News();
book=(News) ve.get(i);
ws.addCell(new jxl.write.Label(0,0,"序号"));
ws.addCell(new jxl.write.Label(1,0,"标题"));
ws.addCell(new jxl.write.Label(2,0,"发布时间"));
ws.addCell(new jxl.write.Label(3,0,"来源网站"));
ws.addCell(new jxl.write.Label(4,0,"采集时间"));
//ws.addCell(new jxl.write.Label(5,0,"集合位置"));
ws.addCell(new jxl.write.Label(0,j+1,Integer.toString(j+1)));
ws.addCell(new jxl.write.Label(1,j+1,book.getTitle()));
ws.addCell(new jxl.write.Label(2,j+1,book.getPubdate().toString().substring(0, 10)));
ws.addCell(new jxl.write.Label(3,j+1,book.getWebsitename()));
ws.addCell(new jxl.write.Label(4,j+1,book.getCollentTime().toString().substring(0, 19)));
//ws.addCell(new jxl.write.Label(5,j+1,String.valueOf(i)));
}
wwb.write();
wwb.close();
return 1;
}catch(IOException e){
}catch(RowsExceededException e){
}catch(WriteException e){
}
return 0;
}
0 0
- JXL导出
- jxl 导出excel
- 使用jxl导出excel
- jxl导出excel
- Java jxl导出excel
- jxl导出exl
- jxl实现导出excel
- Jxl导出Excel实现
- jxl导出Excel
- jxl 导出Excel
- jxl导出Excel
- jxl导出EXCEL
- 使用JXL导出excel
- JXL导入导出EXCEL
- jxl 方式导出excel
- jxl导出excel
- jxl 实现导出excel
- jxl导出excel
- 管理网络
- 导出Excel自主选择存放路径—输出流 OutputStream
- 理解RESTful架构(转载)
- JavaScript学习总结(十五)——Function类
- Lightoj1019——Brush (V)(最短路)
- JXL导出
- JavaScript学习总结(十七)——Javascript原型链的原理
- 【Python】 大规模电影推荐
- 使用Edge模式通知Internet Explorer以最高级别的可用模式显示内容
- JXL操作Excel的网上例子
- JavaWeb学习总结(一)——JavaWeb开发入门
- Redis的持久化
- jxl操作excel --API
- MySQL解决乱码问题