From b1d2829ea27d3c8d4e4779d7ee5fe21bfe8f132c Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期四, 11 八月 2022 10:47:42 +0800
Subject: [PATCH] 产品下载excel信息修改
---
src/main/java/com/whyc/service/ProductBomService.java | 9 ++++++++-
1 files changed, 8 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/whyc/service/ProductBomService.java b/src/main/java/com/whyc/service/ProductBomService.java
index f1591b1..1883964 100644
--- a/src/main/java/com/whyc/service/ProductBomService.java
+++ b/src/main/java/com/whyc/service/ProductBomService.java
@@ -251,7 +251,13 @@
String excelName="";
//鍒涘缓鍗曚釜sheet
HSSFSheet sheet = wb.createSheet("bom淇℃伅");
- sheet.setDefaultColumnWidth(3000);
+ sheet.setColumnWidth(1,5000);
+ sheet.setColumnWidth(2,5000);
+ sheet.setColumnWidth(3,5000);
+ sheet.setColumnWidth(4,5000);
+ sheet.setColumnWidth(6,5000);
+ sheet.setColumnWidth(7,5000);
+ sheet.setColumnWidth(8,5000);
sheet.setColumnWidth(16,6000);
sheet.setDefaultRowHeight((short)(1000));
//鍥剧墖鍏冪礌
@@ -274,6 +280,7 @@
sheet.getRow(rownum).createCell(14).setCellValue("琛ㄩ潰澶勭悊/鐗╂枡璇︽儏");
sheet.getRow(rownum).createCell(15).setCellValue("澶囨敞");
sheet.getRow(rownum).createCell(16).setCellValue("鍥剧墖");
+
//灏嗛�変腑鐨勬枃浠跺瓨鍏ユ寚瀹氱洰褰曚笅鎵撳寘涓嬭浇
if(list!=null&&list.size()>0){
for (int i=0;i<list.size();i++) {
--
Gitblit v1.9.1