// 创建工作流
OutputStream os = null;
try {
// 设置弹出对话框
response.setContentType("application/DOWLOAD");
response.setCharacterEncoding("UTF-8");
// 设置工作表的标题
// response.setHeader("Content-Disposition",
// "attachment; filename=Norecord_Social_Credit_Code.xls");
// 设置生成的文件名字
response.addHeader("Content-Disposition", "inline; filename="
+ new String(name.getBytes("GB2312"), "ISO8859_1") + ".xls");
os = response.getOutputStream();
// 初始化工作表
book = Workbook.createWorkbook(os);
} catch (IOException e1) {
//logger.error("导出excel出现IO异常", e1);
throw new ServiceException("导出失败", e1);
}
try {
// 设置日期格式
SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");//日期格式1
SimpleDateFormat sf2 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//日期格式1
Timestamp appDate = order_scrk.getB_createTime();
String appDateStr = sf.format(appDate);//建表日期
//String product_date=sf2.format(order_cgtl_dts.getProduct_date());
// 以下为excel表格内容
// int nCount = list.size();
WritableSheet sheet = book.createSheet(name, 0);// 设置sheet名称
sheet.getSettings().setAutomaticFormulaCalculation(true);
// 设置默认列宽
sheet.getSettings().setDefaultColumnWidth(14);
// 设置默认行高
// sheet.getSettings().setDefaultRowHeight(300);
// 生成名工作表,参数0表示这是第一页
// int nI = 1;
// 表字段名
sheet.mergeCells(0, 0, 11, 0);// 1-k合并
sheet.setRowView(0, 800); // 设置第1行行高
sheet.addCell(new jxl.write.Label(0, 0, name, wcfF14));
// 合并备注那里单元格
sheet.mergeCells(1, 27, 11, 27);//备注那里
sheet.setRowView(27, 1000); // 设置第27行行高
// sheet.setc
sheet.mergeCells(0, 1, 11, 1);// 第二行合并
sheet.addCell(new jxl.write.Label(0, 1, "单据编号:"
+ order_scrk.getNumber() + " 日期:" + appDateStr + " 单据状态:"
+ order_status.getOrder_status_name(), wcfF12));
sheet.mergeCells(1, 2, 11, 2);// 第3行合并
sheet.addCell(new jxl.write.Label(0, 2, "质检员:", wcfF12));
sheet.addCell(new jxl.write.Label(1, 2, user1.getUser_name(),wcfF11));
sheet.mergeCells(1, 3, 11, 3);// 第4行合并
sheet.addCell(new jxl.write.Label(0, 3, "项目:", wcfF12));
sheet.addCell(new jxl.write.Label(1, 3, project.getProject_name(),wcfF11));//项目名称
//sheet.addCell(new jxl.write.Label(1, 2, "原材料仓", wcfF12));
sheet.addCell(new jxl.write.Label(0, 4, "物料编码", wcfF12));
sheet.addCell(new jxl.write.Label(1, 4, "物料名称", wcfF12));
sheet.addCell(new jxl.write.Label(2, 4, "规格", wcfF12));
sheet.addCell(new jxl.write.Label(3, 4, "型号", wcfF12));
sheet.addCell(new jxl.write.Label(4, 4, "单位", wcfF12));
sheet.addCell(new jxl.write.Label(5, 4, "应收数量", wcfF12));
sheet.addCell(new jxl.write.Label(6, 4, "序列号", wcfF12));
sheet.addCell(new jxl.write.Label(7, 4, "实收数量", wcfF12));
sheet.addCell(new jxl.write.Label(8, 4, "批号", wcfF12));
sheet.addCell(new jxl.write.Label(9, 4, "仓库", wcfF12));
sheet.addCell(new jxl.write.Label(10, 4, "仓位", wcfF12));
sheet.addCell(new jxl.write.Label(11, 4, "库存状态", wcfF12));
for (int i = 0; i < list.size(); i++) {
Order_scrk_dts order_scrk_dts= list.get(i).getOrder_scrk_dts();
String sql="SELECT f.ser_number from finished_p_sernum f"
+" LEFT JOIN order_zj_dts o ON f.order_cskc_dts_id=o.order_zj_dts_id"
+" LEFT JOIN order_scrk_dts s ON o.order_zj_dts_id=s.order_scrk_dts_id"
+" where s.order_scrk_id=?1";
Map
maps.put(1, order_scrk_dts.getOrder_zj_dts_id());
List
以上是关于java中使用jxl实现表格导出的主要内容,如果未能解决你的问题,请参考以下文章