Java导出Excel表合并行、合并列-CSDN博客

本文链接：https://blog.csdn.net/weixin_42553570/article/details/108213756

本文介绍了如何使用Java在导出Excel时实现行和列的合并，包括Controller层和服务层的代码示例，以及设置样式、列宽和编码的方法。前端部分仅涉及一个导出按钮和URL参数传递。

摘要由CSDN通过智能技术生成

Controller层代码

@RequestMapping(value = "/productExportExcel", method = RequestMethod.GET)
	public void productExportExcel(HttpServletRequest request,HttpServletResponse response) throws Exception {
   
		Record rd = this.getCurrentUser();
		try {
   
			List<Integer> columnWidthList = new ArrayList<Integer>();//列宽 用list比较方便在某处插入新字段和数数
			columnWidthList.add(20);columnWidthList.add(20);columnWidthList.add(20);
			columnWidthList.add(20);columnWidthList.add(20);columnWidthList.add(20);
			columnWidthList.add(15);
			String[] title = {
   "一级产品线","详细描述","二级产品线","详细描述","三级产品线","详细描述"};
			String[] key = {
   "NAME","DETAIL","Z_NAME","Z_DETAIL","ZZ_NAME","ZZ_DETAIL"};
			String fileName = "产品线信息表";
			exportExcel.productExport(request, response, columnWidthList, title, key, fileName);
			logService.showLog(fileName, "4",rd,request);
		} catch (Exception e) {
   
			// TODO: handle exception
			logger.error(e.getMessage());
			String fileName = "产品线信息表";
			logService.showLog(fileName, "5",rd,request);
		}
	}

Service层代码

public void productExport(HttpServletRequest request,HttpServletResponse response,List<Integer> columnWidthList,String[] title,String[] key,String fileName) throws Exception{
   
		/*
		 * 1.设置样式
		 */
		HSSFWorkbook workbook = new HSSFWorkbook(); 
		HSSFFont titleFont = workbook.createFont(); //属性字体
		HSSFFont valueFont = workbook.createFont(); //值字体
		HSSFCellStyle titleStyle = workbook.createCellStyle();//属性格式
		HSSFCellStyle valueStyle = workbook.createCellStyle();//值格式
		setStyle(titleFont,valueFont,titleStyle,valueStyle);
		
    	HSSFSheet sheet = workbook.createSheet(fileName);
    	for (int i = 0;