| | |
| | | writer.clearHeaderAlias(); |
| | | |
| | | // 设置表头别名(中文列名) |
| | | writer.addHeaderAlias("daa001", "工单号"); |
| | | writer.addHeaderAlias("itemNo", "物料编码"); |
| | | writer.addHeaderAlias("itemName", "物料名称"); |
| | | writer.addHeaderAlias("departmentname", "车间名称"); |
| | | writer.addHeaderAlias("departmentname", "车间"); |
| | | writer.addHeaderAlias("lineName", "线体名称"); |
| | | writer.addHeaderAlias("departmentcode", "车间编码"); |
| | | writer.addHeaderAlias("lineNo", "线体编码"); |
| | | writer.addHeaderAlias("daa008", "工单数量"); |
| | | writer.addHeaderAlias("yjkg", "预计开工"); |
| | | writer.addHeaderAlias("sjkg", "实际开工"); |
| | | writer.addHeaderAlias("sq", "申请入库数"); |
| | | writer.addHeaderAlias("itemNo", "产品编码"); |
| | | writer.addHeaderAlias("itemName", "产品名称"); |
| | | writer.addHeaderAlias("daa001", "工单号"); |
| | | writer.addHeaderAlias("daa008", "工单数"); |
| | | writer.addHeaderAlias("sq", "申请数"); |
| | | writer.addHeaderAlias("rk", "入库数"); |
| | | writer.addHeaderAlias("sqwwg", "申请未完工数"); |
| | | writer.addHeaderAlias("rkwwg", "入库未完工"); |
| | | writer.addHeaderAlias("sqwrk", "申请未入库"); |
| | | writer.addHeaderAlias("yjkg", "预计开工"); |
| | | writer.addHeaderAlias("sjkg", "实际开工"); |
| | | |
| | | // 合并单元格作为标题行 |
| | | writer.merge(14, title); |
| | |
| | | writer.clearHeaderAlias(); |
| | | |
| | | // 设置表头别名(中文列名) |
| | | writer.addHeaderAlias("daa001", "工单号"); |
| | | writer.addHeaderAlias("itemNo", "物料编码"); |
| | | writer.addHeaderAlias("itemName", "物料名称"); |
| | | writer.addHeaderAlias("departmentname", "车间名称"); |
| | | writer.addHeaderAlias("departmentname", "车间"); |
| | | writer.addHeaderAlias("lineName", "线体名称"); |
| | | writer.addHeaderAlias("departmentcode", "车间编码"); |
| | | writer.addHeaderAlias("lineNo", "线体编码"); |
| | | writer.addHeaderAlias("daa008", "工单数量"); |
| | | writer.addHeaderAlias("yjkg", "预计开工"); |
| | | writer.addHeaderAlias("sjkg", "实际开工"); |
| | | writer.addHeaderAlias("sq", "申请入库数"); |
| | | writer.addHeaderAlias("itemNo", "产品编码"); |
| | | writer.addHeaderAlias("itemName", "产品名称"); |
| | | writer.addHeaderAlias("daa001", "工单号"); |
| | | writer.addHeaderAlias("daa008", "工单数"); |
| | | writer.addHeaderAlias("sq", "申请数"); |
| | | writer.addHeaderAlias("rk", "入库数"); |
| | | writer.addHeaderAlias("sqwwg", "申请未完工数"); |
| | | writer.addHeaderAlias("rkwwg", "入库未完工"); |
| | | writer.addHeaderAlias("sqwrk", "申请未入库"); |
| | | writer.addHeaderAlias("yjkg", "预计开工"); |
| | | writer.addHeaderAlias("sjkg", "实际开工"); |
| | | |
| | | // 合并单元格作为标题行 |
| | | writer.merge(14, title); |