关键词搜索

源码搜索 ×
×

Java使用Apache POI导出-注意前端不要使用Ajax异步请求

发布2017-06-27浏览3034次

详情内容

Java使用Apache POI导出-注意前端不要使用Ajax异步请求，如果你想弹出文件下载框，请勿使用异步下载。

Apahce POI pom配置

  1. <!--EXCEL导入导出 -->
  2. 		<dependency>
  3. 			<groupId>org.apache.poi</groupId>
  4. 			<artifactId>poi</artifactId>
  5. 			<version>3.9</version>
  6. 		</dependency>
  7.  
  8. 		<dependency>
  9. 			<groupId>org.apache.poi</groupId>
  10. 			<artifactId>poi-ooxml</artifactId>
  11. 			<version>3.9</version>
  12. 		</dependency>
  13.  
  14. 		<dependency>
  15. 			<groupId>org.apache.poi</groupId>
  16. 			<artifactId>poi-ooxml-schemas</artifactId>
  17. 			<version>3.9</version>
  18. 		</dependency>

 

ExoportExcelUtil

  1. package com.boonya.common.utils.excel;
  2.  
  3. import java.io.ByteArrayInputStream;
  4. import java.io.ByteArrayOutputStream;
  5. import java.io.InputStream;
  6. import java.lang.reflect.InvocationTargetException;
  7. import java.lang.reflect.Method;
  8. import java.util.ArrayList;
  9. import java.util.Arrays;
  10. import java.util.Date;
  11. import java.util.List;
  12. import java.util.Map;
  13. import javax.servlet.http.HttpServletResponse;
  14. import org.apache.poi.hssf.usermodel.HSSFCell;
  15. import org.apache.poi.hssf.usermodel.HSSFCellStyle;
  16. import org.apache.poi.hssf.usermodel.HSSFRichTextString;
  17. import org.apache.poi.hssf.usermodel.HSSFRow;
  18. import org.apache.poi.hssf.usermodel.HSSFSheet;
  19. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
  20. import org.apache.poi.hssf.util.CellRangeAddress;
  21. import org.apache.poi.xssf.usermodel.XSSFCell;
  22. import org.apache.poi.xssf.usermodel.XSSFCellStyle;
  23. import org.apache.poi.xssf.usermodel.XSSFRichTextString;
  24. import org.apache.poi.xssf.usermodel.XSSFRow;
  25. import org.apache.poi.xssf.usermodel.XSSFSheet;
  26. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  27. import com.cvnavi.common.utils.DateUtil;
  28.  
  29. @SuppressWarnings("deprecation")
  30. public class ExportExcelUtil {
  31.  
  32. 	public static String getFileName() {
  33. 		return DateUtil.toString(new Date(), "yyyyMMdd-HHmmss");
  34. 	}
  35.  
  36. 	public static XSSFWorkbook getWorkbook(List<?> resultList, String[] showName, String[] resourceField,
  37. 			Class<?> resultObj, Map<String, Map<String, String>> formatMap) throws SecurityException,
  38. 			NoSuchMethodException, IllegalArgumentException, IllegalAccessException, InvocationTargetException {
  39. 		XSSFWorkbook workbook = new XSSFWorkbook();
  40. 		XSSFSheet sheet = workbook.createSheet("sheet1");
  41. 		sheet.setDefaultColumnWidth((short) 20);
  42. 		XSSFCellStyle centerStyle = workbook.createCellStyle();// 设置为水平居中
  43. 		centerStyle.setAlignment(XSSFCellStyle.ALIGN_CENTER);
  44. 		centerStyle.setVerticalAlignment(XSSFCellStyle.VERTICAL_CENTER);
  45. 		XSSFRow row;
  46. 		XSSFCell cell;
  47. 		createTitle(showName, sheet);
  48. 		// 下面是输出各行的数据 下面是输出各行的数据 下面是输出各行的
  49. 		for (int i = 0, len = resultList.size(); i < len; i++) {
  50. 			Object result = resultList.get(i);
  51. 			row = sheet.createRow(i + 1);
  52. 			// 创建第 i+1 行
  53. 			for (int j = 0; j < resourceField.length; j++) {
  54. 				cell = row.createCell(j);// 创建第 j 列
  55. 				Method method;
  56. 				method = resultObj.getMethod(resourceField[j]);
  57. 				// 这里用到了反射机制，通 这里用到了反射机制， 这里用到了反射机制 过方法名来取得对应方法返回的结果对象
  58. 				Object obj = method.invoke(result);
  59. 				if (obj != null) {
  60. 					if (formatMap != null && formatMap.containsKey(resourceField)) {
  61. 						cell.setCellValue(formatMap.get(resourceField).get(obj.toString()));
  62. 					} else {
  63. 						cell.setCellValue(obj.toString());
  64. 					}
  65. 				}
  66. 			}
  67. 		}
  68. 		return workbook;
  69. 	}
  70.  
  71. 	/**
  72. 	 * 
  73. 	 * @Title: getWorkbook2 @Description: TODO(创建HSSFWorkbook) @param
  74. 	 * resultList @param showName @param resourceField @param resultObj @param
  75. 	 * formatMap @return @throws SecurityException @throws
  76. 	 * NoSuchMethodException @throws IllegalArgumentException @throws
  77. 	 * IllegalAccessException @throws InvocationTargetException 设定文件 @return
  78. 	 * HSSFWorkbook 返回类型 @author: pengjl @date 2017年6月27日 下午3:22:51 @throws
  79. 	 */
  80. 	public static HSSFWorkbook getWorkbook2(List<?> resultList, String[] showName, String[] resourceField,
  81. 			Class<?> resultObj, Map<String, Map<String, String>> formatMap) throws SecurityException,
  82. 			NoSuchMethodException, IllegalArgumentException, IllegalAccessException, InvocationTargetException {
  83. 		HSSFWorkbook workbook = new HSSFWorkbook();
  84. 		HSSFSheet sheet = workbook.createSheet("sheet1");
  85. 		sheet.setDefaultColumnWidth((short) 20);
  86. 		HSSFCellStyle centerStyle = workbook.createCellStyle();// 设置为水平居中
  87. 		centerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
  88. 		centerStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
  89. 		HSSFRow row;
  90. 		HSSFCell cell;
  91. 		createTitle2(showName, sheet);
  92. 		// 下面是输出各行的数据 下面是输出各行的数据 下面是输出各行的
  93. 		for (int i = 0; i < resultList.size(); i++) {
  94. 			Object result = resultList.get(i);
  95. 			row = sheet.createRow(i + 1);
  96. 			// 创建第 i+1 行
  97. 			for (int j = 0; j < resourceField.length; j++) {
  98. 				cell = row.createCell(j);// 创建第 j 列
  99. 				Method method;
  100. 				method = resultObj.getMethod(resourceField[j]);
  101. 				// 这里用到了反射机制，通 这里用到了反射机制， 这里用到了反射机制 过方法名来取得对应方法返回的结果对象
  102. 				Object obj = method.invoke(result);
  103. 				if (obj != null) {
  104. 					if (formatMap != null && formatMap.containsKey(resourceField)) {
  105. 						cell.setCellValue(formatMap.get(resourceField).get(obj.toString()));
  106. 					} else {
  107. 						cell.setCellValue(obj.toString());
  108. 					}
  109. 				}
  110. 			}
  111. 		}
  112. 		return workbook;
  113. 	}
  114.  
  115. 	/**
  116. 	 * @Title: createTitle2 @Description: TODO(多行表头) @param showName @param
  117. 	 * sheet 设定文件 @return void 返回类型 @author: pengjl @date 2017年6月27日
  118. 	 * 下午3:23:30 @throws
  119. 	 */
  120. 	private static void createTitle2(String[] showName, HSSFSheet sheet) {
  121. 		HSSFRow row = sheet.createRow(0); // 创建第 1 行，也就是输出表头 创建第
  122. 		HSSFCell cell;
  123. 		for (int i = 0; i < showName.length; i++) {
  124. 			cell = row.createCell(i);
  125. 			// 创建第 i 列 创建第
  126. 			cell.setCellValue(new HSSFRichTextString(showName[i]));
  127. 		}
  128. 	}
  129.  
  130. 	private static void createTitle(String[] showName, XSSFSheet sheet) {
  131. 		XSSFRow row = sheet.createRow(0); // 创建第 1 行，也就是输出表头 创建第
  132. 		XSSFCell cell;
  133. 		for (int i = 0; i < showName.length; i++) {
  134. 			cell = row.createCell(i);
  135. 			// 创建第 i 列 创建第
  136. 			cell.setCellValue(new XSSFRichTextString(showName[i]));
  137. 		}
  138. 	}
  139.  
  140. 	/**
  141. 	 * @Title: createWorkbook @Description: TODO(创建HSSFWorkbook) @param
  142. 	 * resultList @param showName @return 设定文件 @return HSSFWorkbook
  143. 	 * 返回类型 @author: pengjl @date 2017年6月27日 下午3:23:41 @throws
  144. 	 */
  145. 	public static HSSFWorkbook createWorkbook(List<List<Cell>> resultList, String[] showName) {
  146. 		HSSFWorkbook workbook = new HSSFWorkbook();
  147. 		HSSFSheet sheet = workbook.createSheet("sheet1");
  148. 		HSSFCellStyle centerStyle = workbook.createCellStyle();// 设置为水平居中
  149. 		centerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
  150. 		centerStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
  151. 		createTitle2(showName, sheet);
  152. 		HSSFRow row = null;
  153. 		HSSFCell cell = null;
  154. 		int[][] arraSort;
  155. 		if (resultList.size() == 0) {
  156. 			arraSort = new int[0][0];
  157. 		} else {
  158. 			arraSort = new int[resultList.get(0).size()][resultList.size()];
  159. 		}
  160. 		for (int i = 0; i < resultList.size(); i++) {
  161. 			row = sheet.createRow(i + 1);
  162. 			// sheet.setColumnWidth(i + 1, 15);
  163. 			List<Cell> cellList = resultList.get(i);
  164. 			for (int j = 0; j < cellList.size(); j++) {
  165. 				cell = row.createCell(j);// 创建第 j 列
  166. 				cell.setCellValue(cellList.get(j).getValue());
  167. 				int b = cell.getStringCellValue().getBytes().length;
  168. 				arraSort[j][i] = b;
  169. 				if (cellList.get(j).getStyle() != null) {
  170. 					cell.setCellStyle(cellList.get(j).getStyle());
  171. 				}
  172. 			}
  173. 		}
  174. 		// 列的最大列宽值（不包括标题）
  175. 		int widthInfo[] = TwoMaxInfo(arraSort);
  176. 		// 与标题在比较列宽
  177. 		for (int i = 0; i < showName.length; i++) {
  178. 			// sheet.autoSizeColumn(i);
  179. 			// 算出列（包括标题的最大列宽）
  180. 			int maxWidthInfo = showName[i].getBytes().length > widthInfo[i] ? showName[i].getBytes().length
  181. 					: widthInfo[i];
  182. 			sheet.setColumnWidth(i, maxWidthInfo * 256);
  183. 		}
  184. 		return workbook;
  185. 	}
  186.  
  187. 	public static int[] TwoMaxInfo(int[][] arraSort) {
  188. 		int[] arraySortInfo = null;
  189. 		arraySortInfo = new int[arraSort.length];
  190. 		int count = 0;
  191. 		for (int[] is : arraSort) {
  192. 			int[] arraInfo = is;
  193. 			Arrays.sort(arraInfo);
  194. 			arraySortInfo[count] = arraInfo[arraInfo.length - 1];
  195. 			count++;
  196. 		}
  197. 		return arraySortInfo;
  198. 	}
  199.  
  200. 	/**
  201. 	 * @Title: createWorkbookAll @Description: TODO(创建HSSFWorkbook) @param
  202. 	 * vMap @param showName @return 设定文件 @return HSSFWorkbook 返回类型 @author:
  203. 	 * pengjl @date 2017年6月27日 下午3:20:04 @throws
  204. 	 */
  205. 	public static HSSFWorkbook createWorkbookAll(Map<String, List<List<Cell>>> vMap, String[] showName) {
  206. 		HSSFWorkbook workbook = new HSSFWorkbook();
  207. 		for (Map.Entry<String, List<List<Cell>>> entry : vMap.entrySet()) {
  208. 			HSSFSheet sheet = workbook.createSheet(entry.getKey());
  209. 			sheet.setDefaultColumnWidth((short) 15);
  210. 			HSSFCellStyle centerStyle = workbook.createCellStyle();// 设置为水平居中
  211. 			centerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
  212. 			centerStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
  213. 			createTitle2(showName, sheet);
  214. 			HSSFRow row;
  215. 			HSSFCell cell;
  216. 			for (int i = 0; i < entry.getValue().size(); i++) {
  217. 				row = sheet.createRow(i + 1);
  218. 				List<Cell> cellList = entry.getValue().get(i);
  219. 				for (int j = 0; j < cellList.size(); j++) {
  220. 					cell = row.createCell(j);// 创建第 j 列
  221. 					cell.setCellValue(cellList.get(j).getValue());
  222. 					if (cellList.get(j).getStyle() != null) {
  223. 						cell.setCellStyle(cellList.get(j).getStyle());
  224. 					}
  225. 				}
  226. 			}
  227. 			for (int i = 0; i < showName.length; i++) {
  228. 				sheet.autoSizeColumn(i);
  229. 			}
  230. 		}
  231. 		return workbook;
  232. 	}
  233.  
  234. 	/**
  235. 	 * @Title: workbook2InputStream @Description: TODO(导出Excel文件) @param
  236. 	 * workbook @param fileName @param response @return @throws Exception
  237. 	 * 设定文件 @return InputStream 返回类型 @author: pengjl @date 2017年6月27日
  238. 	 * 下午3:20:21 @throws
  239. 	 */
  240. 	public static InputStream workbook2InputStream(HSSFWorkbook workbook, String fileName, HttpServletResponse response)
  241. 			throws Exception {
  242. 		ByteArrayOutputStream baos = new ByteArrayOutputStream();
  243. 		workbook.write(baos);
  244. 		baos.flush();
  245. 		byte[] aa = baos.toByteArray();
  246. 		InputStream excelStream = new ByteArrayInputStream(aa, 0, aa.length);
  247. 		response.setContentType("application/vnd.ms-excel;charset=UTF-8");
  248. 		response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls");
  249. 		response.getOutputStream().write(aa);
  250. 		response.setContentLength(aa.length);
  251. 		response.getOutputStream().flush();
  252. 		baos.close();
  253. 		return excelStream;
  254.  
  255. 	}
  256.  
  257. 	/**
  258. 	 * 
  259. 	 * @Title: workbook2InputStream @Description: TODO(导出Excel文件) @param
  260. 	 * workbook @param fileName @param response @return @throws Exception
  261. 	 * 设定文件 @return InputStream 返回类型 @author: pengjl @date 2017年6月27日
  262. 	 * 下午3:20:49 @throws
  263. 	 */
  264. 	public static InputStream workbook2InputStream(XSSFWorkbook workbook, String fileName, HttpServletResponse response)
  265. 			throws Exception {
  266. 		ByteArrayOutputStream baos = new ByteArrayOutputStream();
  267. 		workbook.write(baos);
  268. 		baos.flush();
  269. 		byte[] aa = baos.toByteArray();
  270. 		InputStream excelStream = new ByteArrayInputStream(aa, 0, aa.length);
  271. 		response.setContentType("application/vnd.ms-excel;charset=UTF-8");
  272. 		response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xlsx");
  273. 		response.getOutputStream().write(aa);
  274. 		response.setContentLength(aa.length);
  275. 		response.getOutputStream().flush();
  276. 		baos.close();
  277. 		return excelStream;
  278.  
  279. 	}
  280.  
  281. 	/**
  282. 	 * @Title: createWorkbookVarietyParam @Description:
  283. 	 * TODO(创建HSSFWorkbook) @param resultList @param showName @param
  284. 	 * headerName @return 设定文件 @return HSSFWorkbook 返回类型 @author: pengjl @date
  285. 	 * 2017年6月27日 下午3:21:22 @throws
  286. 	 */
  287. 	public static HSSFWorkbook createWorkbookVarietyParam(ArrayList<ArrayList<String>> resultList, String[] showName,
  288. 			ArrayList<String> headerName) {
  289. 		HSSFWorkbook workbook = new HSSFWorkbook();
  290. 		HSSFSheet sheet = workbook.createSheet("sheet1");
  291. 		sheet.setDefaultColumnWidth((short) 15);
  292. 		HSSFCellStyle centerStyle = workbook.createCellStyle();// 设置为水平居中
  293. 		centerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
  294. 		centerStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
  295. 		/**
  296. 		 * 设置表头的样式
  297. 		 */
  298. 		HSSFCellStyle titylStyle = workbook.createCellStyle();
  299. 		createTitleVariety(showName, headerName, sheet, titylStyle);
  300. 		HSSFRow row;
  301. 		HSSFCell cell;
  302. 		if (resultList != null && resultList.size() > 0) {
  303. 			for (int i = 0; i < resultList.size(); i++) {
  304. 				ArrayList<String> rowResultList = resultList.get(i);
  305. 				if (headerName != null && headerName.size() > 0) {
  306. 					row = sheet.createRow((short) (i + 1 + headerName.size()));
  307. 				} else {
  308. 					row = sheet.createRow((short) (i + 1));
  309. 				}
  310. 				if (rowResultList != null && rowResultList.size() > 0) {
  311.  
  312. 					for (int n = 0; n <= rowResultList.size(); n++) {
  313. 						cell = row.createCell(n);// 创建第 j 列
  314. 						cell.setCellStyle(centerStyle);
  315. 						if (n == 0) {
  316. 							// 为Excel表的第一列添加编号，表头为：序号；eg:1,2,3,4……
  317. 							cell.setCellValue(i + 1);
  318. 						} else if (rowResultList.get(n - 1) != null) {
  319. 							cell.setCellValue(rowResultList.get(n - 1).toString());
  320. 						} else {
  321. 							cell.setCellValue("");
  322. 						}
  323. 					}
  324.  
  325. 				}
  326. 			}
  327. 		}
  328.  
  329. 		return workbook;
  330. 	}
  331.  
  332. 	/**
  333. 	 * @Title: createTitleVariety @Description: TODO(多行表头) @param
  334. 	 * showName @param headerName @param sheet @param titylStyle 设定文件 @return
  335. 	 * void 返回类型 @author: pengjl @date 2017年6月27日 下午3:24:24 @throws
  336. 	 */
  337. 	private static void createTitleVariety(String[] showName, ArrayList<String> headerName, HSSFSheet sheet,
  338. 			HSSFCellStyle titylStyle) {
  339. 		HSSFRow row;
  340. 		HSSFCell cell;
  341. 		titylStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
  342. 		titylStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
  343. 		if (headerName != null && headerName.size() > 0) {
  344. 			for (int i = 0; i < headerName.size(); i++) {
  345. 				row = sheet.createRow((short) i);
  346. 				if (i == 0) {
  347. 					cell = row.createCell(i);
  348. 					sheet.addMergedRegion(new CellRangeAddress(i, i, (short) 0, (short) showName.length));
  349. 					cell.setCellStyle(titylStyle);
  350. 					if (headerName.get(i) != null) {
  351. 						cell.setCellValue(new HSSFRichTextString(headerName.get(i).toString()));
  352. 					} else {
  353. 						cell.setCellValue(new HSSFRichTextString(""));
  354. 					}
  355. 				} else {
  356. 					cell = row.createCell(i - 1);
  357. 					sheet.addMergedRegion(new CellRangeAddress(i, i, (short) 0, (short) showName.length));
  358. 					if (headerName.get(i) != null) {
  359. 						cell.setCellValue(new HSSFRichTextString(headerName.get(i).toString()));
  360. 					} else {
  361. 						cell.setCellValue(new HSSFRichTextString(""));
  362. 					}
  363. 				}
  364. 			}
  365. 		}
  366. 		// 设置Excel字段
  367. 		if (headerName != null && headerName.size() > 0) {
  368. 			row = sheet.createRow((short) headerName.size());
  369. 		} else {
  370. 			row = sheet.createRow(0);
  371. 		}
  372. 		for (int n = 0; n <= showName.length; n++) {
  373. 			if (n == 0) {
  374. 				cell = row.createCell(n);
  375. 				cell.setCellStyle(titylStyle);
  376. 				cell.setCellValue(new HSSFRichTextString("序号"));
  377. 			} else {
  378. 				cell = row.createCell(n);
  379. 				cell.setCellStyle(titylStyle);
  380. 				cell.setCellValue(new HSSFRichTextString(showName[n - 1]));
  381. 			}
  382. 		}
  383. 	}
  384. }

 

 

 

使用方式

 

  1. /**
  2. 	* @Title: export
  3. 	* @Description: TODO(单车导出&&导出前端Ajax请求不会弹出下载文件)
  4. 	* @param request
  5. 	* @param response
  6. 	* @param temperatureBean
  7. 	* @return    设定文件
  8. 	* @return String    返回类型
  9. 	* @author: pengjl
  10. 	* @date 2017年6月22日 下午8:38:43
  11. 	* @throws
  12. 	 */
  13. 	@RequestMapping("/export")
  14. 	public void export(HttpServletRequest request,HttpServletResponse response,TemperatureBean temperatureBean){
  15. 	    int mapType = Integer.parseInt(request.getParameter("mapType"));
  16.         try {
  17.             List<TemperatureView> viewList= iTemperatureService.queryTrack(temperatureBean, mapType,true);
  18.             String[] showName = {"车牌号","GPS时间","速度(公里/时)","海拔(米)","位置","温度"};
  19.             List<List<Cell>> dataList = new ArrayList<List<Cell>>();
  20.             List<Cell> cellList = new ArrayList<Cell>();
  21.             if(viewList.size()>0){
  22. 	            for (TemperatureView view : viewList) {
  23. 	                cellList = new ArrayList<Cell>();
  24. 	                cellList.add(new Cell(view.getTemperatureList().get(0).getPlateCode()));
  25. 	                cellList.add(new Cell(view.getGpsTime()));
  26. 	                cellList.add(new Cell(Double.parseDouble(view.getTemperatureList().get(0).getSpeed()+"")/10 + ""));
  27. 	                cellList.add(new Cell(view.getTemperatureList().get(0).getHigh()+""));
  28. 	                cellList.add(new Cell(view.getTemperatureList().get(0).getLocation()));
  29. 	                String temp = "" ;
  30. 	                for(TemperatureBean bean: view.getTemperatureList()){
  31. 	                    temp += bean.getAppendName()+":" + bean.getTemperature() + bean.getUnit() + "," ;
  32. 	                }
  33. 	                if(!temp.equals(""))
  34. 	                    temp = temp.substring(0,temp.length()-1);
  35. 	                cellList.add(new Cell(temp));
  36. 	                dataList.add(cellList);
  37. 	            }
  38.             }
  39.             String fileName = ExportExcel.getFileName();
  40.             ExportExcel.workbook2InputStream(ExportExcel.createWorkbook(dataList, showName), fileName,response);
  41.         } catch (Exception e) {
  42.             e.printStackTrace();
  43.         }
  44. 	}

 

 

 

测试URL

在浏览器中输入导出地址：http://127.0.0.1:8081/cvnavi-monitoryt/temperature/export.do?tokenStr=A2E4CE20DBC8A4EDAC0EC5B2AD25D022&startTime=2017-06-27%2000:00:00&endTime=2017-06-27%2023:59:59&plateCode=%E6%B2%AAAWG102&mapType=2&vehicleId=4427355843467897

通过直接访问可以下载，故推测前端反映的无法导出是因为其使用了Ajax，文件本身是异步方式，所以浏览器不会弹出下载框。

设置文字样式：https://blog.csdn.net/sinat_34093604/article/details/53432545

弹出下载文件：使用超链接或者form表单提交（form表单提交在submit时不想浏览器地址提交需要添加返回return ；空返回）

  1.  <button class="mini-fs-export-button zs-btn" id="btn_export">导出</button>
  2.  <form id="form_export" style="color: white;display: none;"  action="../export/zzjgglExport.do" ></form>
  1.    $("#form_export").on("submit",function(e){
  2.            return ;
  3.    });
  4.             
  5.    $("#btn_export").on("click",function(e){
  6.           $("#form_export").submit();
  7.    });

前端传值给POI导出可参考：https://blog.csdn.net/hhzzcc_/article/details/80419396

相关技术文章

最新源码

下载排行榜
点击QQ咨询
开通会员
返回顶部
×
微信扫码支付 元
微信扫码支付
确定支付下载
请使用微信描二维码支付
×

提示信息

×

选择支付方式

  • 微信支付
  • 支付宝付款
确定支付下载