public void getStockTaskInfoExcel(String moldNo, String formNo)
throws Exception {
//開發始寫Excel
File sourceFile = new File(StockConstants.stockUrl + StockConstants.stockUrlFileNameTarget);
File targetFile = new File(StockConstants.stockUrl + StockConstants.stockUrlFileName);
//創建Excel
jxl.Workbook rw = jxl.Workbook.getWorkbook(sourceFile);
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(targetFile, rw);
//設置格式
jxl.write.WritableFont wf = new jxl.write.WritableFont(
WritableFont.COURIER, 18, WritableFont.BOLD, false);
jxl.write.WritableCellFormat wcf = new jxl.write.WritableCellFormat();
wcf.setBorder(jxl.format.Border.RIGHT, jxl.format.BorderLineStyle.MEDIUM);
wcf.setBorder(jxl.format.Border.BOTTOM,jxl.format.BorderLineStyle.MEDIUM);
wcf.setAlignment(jxl.format.Alignment.CENTRE);
jxl.write.WritableCellFormat wcfF = new jxl.write.WritableCellFormat(wf);
wcfF.setAlignment(jxl.format.Alignment.CENTRE);
wcfF.setBorder(jxl.format.Border.RIGHT, jxl.format.BorderLineStyle.MEDIUM);
wcfF.setBorder(jxl.format.Border.BOTTOM,jxl.format.BorderLineStyle.MEDIUM);
jxl.write.WritableFont wfb = new jxl.write.WritableFont(
WritableFont.COURIER, 12, WritableFont.BOLD, false);
jxl.write.WritableCellFormat wcfa = new jxl.write.WritableCellFormat(wfb);
wcfa.setAlignment(jxl.format.Alignment.CENTRE);
jxl.write.WritableCellFormat wcfb = new jxl.write.WritableCellFormat();
wcfb.setBorder(jxl.format.Border.LEFT, jxl.format.BorderLineStyle.MEDIUM);
wcfb.setBorder(jxl.format.Border.RIGHT, jxl.format.BorderLineStyle.MEDIUM);
wcfb.setBorder(jxl.format.Border.BOTTOM,jxl.format.BorderLineStyle.MEDIUM);
wcfb.setAlignment(jxl.format.Alignment.CENTRE);
jxl.write.WritableSheet ws = wwb.getSheet(0);
jxl.write.Label label1 = null;
//ws.addCell(label1);
//查找並寫EXCEL
List<UnStandardBean> stockInfo = this.getStockTaskInfo();
int row = 7;
String factoryChineseName = "";
String factoryEnglishName = "";
factoryChineseName = StockConstants.factoryChineseNameLh;
factoryEnglishName = StockConstants.factoryEnglishNameLh;
label1 = new jxl.write.Label(5, 2, factoryChineseName, wcfa);
ws.addCell(label1);
label1 = new jxl.write.Label(5, 3, factoryEnglishName, wcfa);
ws.addCell(label1);
if(stockInfo!=null && stockInfo.size() > 0){
for (UnStandardBean bean : stockInfo) {
label1 = new jxl.write.Label(1, row, String.valueOf(row-6), wcfb);
ws.addCell(label1);
label1 = new jxl.write.Label(2, row, bean.getMoldNo(), wcf);
ws.addCell(label1);
label1 = new jxl.write.Label(3, row, bean.getPartNo(), wcf);
ws.addCell(label1);
label1 = new jxl.write.Label(4, row, bean.getPartName(), wcf);
ws.addCell(label1);
label1 = new jxl.write.Label(5, row, String.valueOf(bean.getAcceptNum()), wcf);
ws.addCell(label1);
String nowStyle = "";
if(bean.getStyle() != null && bean.getStyle().length()<=0){
nowStyle = bean.getOrdNumber();
}else{
nowStyle = bean.getStyle();
}
label1 = new jxl.write.Label(6, row, nowStyle, wcf);
ws.addCell(label1);
label1 = new jxl.write.Label(7, row, bean.getNote(), wcf);
ws.addCell(label1);
row++;
}
}
//增加內部版權標識
String copyRight= StockConstants.copyRight;
label1 = new jxl.write.Label(5,row+2, copyRight, wcfa);
ws.addCell(label1);
wwb.write();
wwb.close();
}
分享到:
相关推荐
excel导出
java Excel导出 Excel数据处理
excel导出,支持前台和后台导出,并用struts2,简洁代码
java Excel 导出 导入java Excel 导出 导入java Excel 导出 导入java Excel 导出 导入java Excel 导出 导入java Excel 导出 导入java Excel 导出 导入java Excel 导出 导入
php excel导出 导入php excel导出 导入php excel导出 导入php excel导出 导入
需要使用JAVA 做EXCEL导出的同学,有问题尽管私信
Excel导出数据 Excel导出数据 Excel导出数据 Excel导出数据 Excel导出数据
Excel导出百万级数据
项目范围:纯前端; 项目内容:luckysheet在线编辑Excel导出,Excel文件导入; 项目运行:直接浏览器运行index.html
excel导出类,可以直接使用类来实现excel导出,不回出现excel扩展格式错误问题!
java excel导出数据
nio的excel导出
ASP excel导出/导入Access数据库(代码+实例下载)
ExtJS实现Excel导出,最常用的可以解决大部分问题
java复杂模板excel导出例子
POI技术实现Excel导出,支持自定义表头,2层标题,大数据量
自己写一个可直接导出List<Object>数据的Excel工具类,使用起来很方便。
excel导出lua和xml工具
根据已经配置好的Excel模板导出数据。资源是个完整项目导入就可使用(本人用的是jdk7)。