| | |
|---|
| | | ExcelWriter writer = FastExcelFactory.write(response.getOutputStream()).autoCloseStream(false).build(); |
|---|
| | | try { |
|---|
| | | writer.write(Collections.emptyList(), FastExcelFactory.writerSheet(0, "路线") |
|---|
| | | .head(MesProRouteCompleteImportWorkbook.RouteRow.class).build()); |
|---|
| | | .head(MesProRouteCompleteImportWorkbook.RouteRow.class) |
|---|
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.ColumnWidthMatchStyleStrategy()) |
|---|
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.RequiredHeaderWriteHandler()).build()); |
|---|
| | | writer.write(Collections.emptyList(), FastExcelFactory.writerSheet(1, "产品") |
|---|
| | | .head(MesProRouteCompleteImportWorkbook.ProductRow.class).build()); |
|---|
| | | .head(MesProRouteCompleteImportWorkbook.ProductRow.class) |
|---|
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.ColumnWidthMatchStyleStrategy()) |
|---|
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.RequiredHeaderWriteHandler()).build()); |
|---|
| | | writer.write(Collections.emptyList(), FastExcelFactory.writerSheet(2, "工序") |
|---|
| | | .head(MesProRouteCompleteImportWorkbook.ProcessRow.class).build()); |
|---|
| | | .head(MesProRouteCompleteImportWorkbook.ProcessRow.class) |
|---|
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.ColumnWidthMatchStyleStrategy()) |
|---|
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.RequiredHeaderWriteHandler()).build()); |
|---|
| | | writer.write(Collections.emptyList(), FastExcelFactory.writerSheet(3, "工序产出") |
|---|
| | | .head(MesProRouteCompleteImportWorkbook.OutputRow.class).build()); |
|---|
| | | .head(MesProRouteCompleteImportWorkbook.OutputRow.class) |
|---|
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.ColumnWidthMatchStyleStrategy()) |
|---|
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.RequiredHeaderWriteHandler()).build()); |
|---|
| | | writer.write(Collections.emptyList(), FastExcelFactory.writerSheet(4, "工序投料") |
|---|
| | | .head(MesProRouteCompleteImportWorkbook.InputRow.class).build()); |
|---|
| | | .head(MesProRouteCompleteImportWorkbook.InputRow.class) |
|---|
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.ColumnWidthMatchStyleStrategy()) |
|---|
| | | .registerWriteHandler(new cn.iocoder.yudao.framework.excel.core.handler.RequiredHeaderWriteHandler()).build()); |
|---|
| | | writer.write(List.of( |
|---|
| | | new MesProRouteCompleteImportWorkbook.GuideRow("路线", "每行一条路线；路线编码唯一。完整导入仅新增，已有编码会报错，导入后默认停用。"), |
|---|
| | | new MesProRouteCompleteImportWorkbook.GuideRow("产品", "路线编码与路线表一致；每条路线至少一个产品。物料、仓库、库区、库位填写已有业务编码；时间单位填 MINUTE/HOUR/DAY。"), |
|---|
