From b4e0446bc68ebbdbccc45aa63d406068e525677d Mon Sep 17 00:00:00 2001
From: E1ED922C1E9526DD63272D7EC5C6CB77 <E1ED922C1E9526DD63272D7EC5C6CB77@i-search.com.cn>
Date: 星期三, 20 一月 2021 20:41:00 +0800
Subject: [PATCH] Merge branch 'master' of https://gitee.com/huoxiong/hx_common
---
src/main/java/com/hx/util/ExcelUtil.java | 85 ++++++++++++++++++++++++++++++++++++++++++
1 files changed, 85 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/hx/util/ExcelUtil.java b/src/main/java/com/hx/util/ExcelUtil.java
index c549a08..1191dcd 100644
--- a/src/main/java/com/hx/util/ExcelUtil.java
+++ b/src/main/java/com/hx/util/ExcelUtil.java
@@ -162,6 +162,91 @@
return file;
}
+ /**鐢熸垚涓存椂鏂囦欢
+ * @param headList
+ * Excel鏂囦欢Head鏍囬闆嗗悎
+ * @param fieldList
+ * Excel鏂囦欢Field鏍囬闆嗗悎 鏍规嵁field鏉ュ鎵句綅缃～鍏呰〃鏍�
+ * @param dataList
+ * Excel鏂囦欢鏁版嵁鍐呭閮ㄥ垎
+ * @throws Exception
+ */
+ public static File createExcel(String[] headList, String[] fieldList, List<Map<String, Object>> dataList
+ ,Integer height,Integer width) throws Exception {
+ File file = File.createTempFile("temp", ".xls");
+ try{
+
+ if(height == null){
+ height = 450;
+ }
+ if(width == null){
+ width = 5000;
+ }
+ // 鍒涘缓鏂扮殑Excel 宸ヤ綔绨�
+ HSSFWorkbook workbook = new HSSFWorkbook();
+
+ //鍚堝苟鐨勫崟鍏冩牸鏍峰紡
+ HSSFCellStyle boderStyle = workbook.createCellStyle();
+ //鍨傜洿灞呬腑
+ boderStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
+ boderStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 鍒涘缓涓�涓眳涓牸寮�
+
+ // 鍦‥xcel宸ヤ綔绨夸腑寤轰竴宸ヤ綔琛紝鍏跺悕涓虹己鐪佸��
+ // 濡傝鏂板缓涓�鍚嶄负"鏁堢泭鎸囨爣"鐨勫伐浣滆〃锛屽叾璇彞涓猴細
+ // HSSFSheet sheet = workbook.createSheet("鏁堢泭鎸囨爣");
+ HSSFSheet sheet = workbook.createSheet();
+ // 鍦ㄧ储寮�0鐨勪綅缃垱寤鸿锛堟渶椤剁鐨勮锛�
+ HSSFRow row = sheet.createRow(0);
+ // ===============================================================
+ for (int i = 0; i < headList.length; i++) {
+ //楂樺害
+ row.setHeight(height.shortValue());
+ sheet.setColumnWidth(i,width);
+ // 鍦ㄧ储寮�0鐨勪綅缃垱寤哄崟鍏冩牸锛堝乏涓婄锛�
+ HSSFCell cell = row.createCell(i);
+ // 瀹氫箟鍗曞厓鏍间负瀛楃涓茬被鍨�
+ cell.setCellType(HSSFCell.CELL_TYPE_STRING);
+ // 鍦ㄥ崟鍏冩牸涓緭鍏ヤ竴浜涘唴瀹�
+ cell.setCellValue(headList[i]);
+ cell.setCellStyle(boderStyle);
+ }
+ // ===============================================================
+ if (dataList != null) {
+ for (int n = 0; n < dataList.size(); n++) {
+ // 鍦ㄧ储寮�1鐨勪綅缃垱寤鸿
+ HSSFRow row_value = sheet.createRow(n + 1);
+ row_value.setHeight(height.shortValue());
+ Map<String, Object> dataMap = dataList.get(n);
+ // ===============================================================
+ for (int i = 0; i < fieldList.length; i++) {
+ // 鍦ㄧ储寮�0鐨勪綅缃垱寤哄崟鍏冩牸锛堝乏涓婄锛�
+ sheet.setColumnWidth(i,width);
+ HSSFCell cell = row_value.createCell(i);
+ // 瀹氫箟鍗曞厓鏍间负瀛楃涓茬被鍨�
+ cell.setCellType(HSSFCell.CELL_TYPE_STRING);
+ // 鍦ㄥ崟鍏冩牸涓緭鍏ヤ竴浜涘唴瀹�
+ cell.setCellValue(objToString(dataMap.get(fieldList[i])));
+ cell.setCellStyle(boderStyle);
+ }
+ // ===============================================================
+ }
+ }
+
+ // 鏂板缓涓�杈撳嚭鏂囦欢娴�
+ FileOutputStream fOut = new FileOutputStream(file);
+ // 鎶婄浉搴旂殑Excel 宸ヤ綔绨垮瓨鐩�
+ workbook.write(fOut);
+ fOut.flush();
+ // 鎿嶄綔缁撴潫锛屽叧闂枃浠�
+ fOut.close();
+ }catch (Exception e){
+
+ }finally {
+ file.deleteOnExit();
+ }
+ return file;
+ }
+
private static String objToString(Object obj) {
if (obj == null) {
--
Gitblit v1.8.0