javaExcel的导出（简单方法，不用代码写表头）

已于 2023-05-26 17:21:09 修改
阅读量938 收藏 1
点赞数 1
文章标签： java excel导出
于 2023-05-26 17:15:25 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/rngigskt/article/details/130890151
版权

目录

一.java代码

1.controller层(/exportTradeCreditData)

2.service代码

3.将设计好的excel模板放到指定位置

4.ExcelWriter.write()方法

二.前端Vue代码

1.接口

2.代码

三.Excel模板

1.将对应的字段也就是list中的key放到你想放在的位置（${contract.CITY_NAME}）

2.加入批注

表头批注（jx:area(lastCell = "BB5")）

字段批注（jx:each(items="contracts" var="contract" lastCell="BB5")）

模板需要遍历的最后一行最后一列

一.java代码

1.controller层(/exportTradeCreditData)

package com.rhxt.irrmanage.build.control;

import java.io.IOException;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.tomcat.util.http.fileupload.servlet.ServletFileUpload;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.util.WebUtils;

import com.rhxt.common.swagger.ApiJsonObject;
import com.rhxt.common.swagger.ApiJsonProperty;
import com.rhxt.irrmanage.build.pojo.PmTbFiles;
import com.rhxt.irrmanage.build.service.ExportFileService;
import com.rhxt.util.G4Utils;
import com.rhxt.util.ResponseEnum;
import com.rhxt.util.Result;
import com.rhxt.util.file.FileUploadUtils;

import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;

@RestController
@Api(value = "附件上传及导出",tags = {"附件上传及导出"})
@RequestMapping("/exportFile")
public class ExportFileController {
	
	private static final Logger log = LoggerFactory.getLogger(ExportFileController.class);
	
	@Autowired
	ExportFileService exportFileService;
	
	@Value("${file.upload.filePath}")
    private String path;
	
	//文件服务器地址
	@Value("${file.url}")
    private String localIp;
	
	@ApiOperation(value = "导出", notes = "导出")
	@PostMapping("/exportTradeCreditData")
	public Result apiExport(@ApiJsonObject(name = "exportTradeCreditData", value = {
			@ApiJsonProperty(key = "regionId", example = "", description = "灌区编码", type = "string", required = true),
			@ApiJsonProperty(key = "year", example = "", description = "年份", type = "string", required = true),
			@ApiJsonProperty(key = "state", example = "", description = "灌区类型", type = "string", required = true),
			@ApiJsonProperty(key = "irrName", example = "", description = "灌区名称", type = "string", required = true),
			@ApiJsonProperty(key = "planName", example = "", description = "规划名称", type = "string", required = true),
			@ApiJsonProperty(key = "tableName", example = "", description = "对应文件名", type = "string", required = true),
			@ApiJsonProperty(key = "superRegionId", example = "", description = "上级所属行政区划", type = "string", required = true),
			@ApiJsonProperty(key = "regionType", example = "", description = "用户级别", type = "string", required = true),
			@ApiJsonProperty(key = "selRegionId", example = "", description = "灌区编码", type = "string", required = true),
			})
	HttpServletResponse response, @RequestBody Map<String, Object> map ) throws IOException{
    	if (G4Utils.checkParams(map, "tableName")) {
    		String regionId = G4Utils.getMapValue2String(map, "regionId");
			String year = G4Utils.getMapValue2String(map, "year");
			String state = G4Utils.getMapValue2String(map, "state");
			String irrName = G4Utils.getMapValue2String(map, "irrName");
			String planName = G4Utils.getMapValue2String(map, "planName");
    		String tableName = G4Utils.getMapValue2String(map, "tableName");
    		String superRegionId = G4Utils.getMapValue2String(map, "superRegionId");
    		String regionType = G4Utils.getMapValue2String(map, "regionType");
    		String selRegionId = G4Utils.getMapValue2String(map, "selRegionId");
    		exportFileService.exportTradeCreditData(tableName, response, regionId, year, state, irrName, planName,superRegionId,regionType,selRegionId);
		}
		return null;		
	}
	
	@ApiOperation(value = "附件上传", notes = "附件上传")
	@PostMapping("/uploadFile")
	public Result uploadFile(@ApiJsonObject(name = "queryData", value = {
			@ApiJsonProperty(key = "file", example = "", description = "文件", type = "", required = true),
			@ApiJsonProperty(key = "regionId", example = "", description = "行政区划编码", type = "string", required = true),
			@ApiJsonProperty(key = "objId", example = "", description = "附件关联对象id", type = "string", required = true),
			@ApiJsonProperty(key = "userId", example = "", description = "用户id", type = "string", required = true),
			@ApiJsonProperty(key = "remark", example = "", description = "备注", type = "string", required = true),
			})@RequestParam Map<String, Object> map, HttpServletRequest request) throws IOException{	
		Result result = new Result();
		boolean isMultipart = ServletFileUpload.isMultipartContent(request);
		List<MultipartFile> file = null;
		List<PmTbFiles> insertPmFiles = null;
		if (G4Utils.checkParams(map, "regionId", "objId", "userId")) {
			if (isMultipart) {
				String regionId = G4Utils.getMapValue2String(map, "regionId");
				String objId = G4Utils.getMapValue2String(map, "objId");
				String userId = G4Utils.getMapValue2String(map, "userId");
				String remark = G4Utils.getMapValue2String(map, "remark");
				MultipartHttpServletRequest multipartRequest = WebUtils.getNativeRequest(request, MultipartHttpServletRequest.class);
				file = multipartRequest.getFiles("file");
				if (G4Utils.isNotEmpty(file)) {
					try {
						insertPmFiles = FileUploadUtils.insertPmFiles(file, regionId, objId, userId, path, remark);
					} catch (Throwable e) {
						e.printStackTrace();
						log.info("附件上传异常，异常位置：ExportFileController.uploadFile：异常原因：", e);
					}
					if (G4Utils.isNotEmpty(insertPmFiles)) {
						result.setObj(insertPmFiles);
						result.setCode(ResponseEnum.FILE_UPLOAD_SUCCESS.getCode());
						result.setMsg(ResponseEnum.FILE_UPLOAD_SUCCESS.getMsg());
					}else {
						result.setCode(ResponseEnum.FILE_UPLOAD_ERROR.getCode());
						result.setMsg(ResponseEnum.FILE_UPLOAD_ERROR.getMsg());
					}
					
				}
			}
		}else {
			result.setCode(ResponseEnum.PARAM_LOSE_EXCEPTION.getCode());
			result.setMsg(ResponseEnum.PARAM_LOSE_EXCEPTION.getMsg());
		}
		
		return result;		
	}
	
	@ApiOperation(value = "附件删除", notes = "附件删除")
	@PostMapping("/deleteFileById")
	public Result deleteFileById(@ApiJsonObject(name = "deleteFileById", value = {
			@ApiJsonProperty(key = "id", example = "", description = "文件id", type = "", required = true)
	})@RequestBody Map<String, Object> map) throws IOException{	
		Result result = new Result();
		if (G4Utils.checkParams(map, "id")) {
			String id = G4Utils.getMapValue2String(map, "id");
			result.setObj(exportFileService.deleteFile(id));
			result.setCode(ResponseEnum.DELETE_SUCCESS.getCode());
			result.setMsg(ResponseEnum.DELETE_SUCCESS.getMsg());
		}else {
			result.setCode(ResponseEnum.PARAM_LOSE_EXCEPTION.getCode());
			result.setMsg(ResponseEnum.PARAM_LOSE_EXCEPTION.getMsg());
		}
		
		return result;		
	}
	
	@ApiOperation(value = "附件查看", notes = "附件查看")
	@PostMapping("/selectFileById")
	public Result selectFileById(@ApiJsonObject(name = "selectFileById", value = {
			@ApiJsonProperty(key = "id", example = "", description = "附件关联对象id", type = "", required = true)
	})@RequestBody Map<String, Object> map) throws IOException{	
		Result result = new Result();
		if (G4Utils.checkParams(map, "id")) {
			String id = G4Utils.getMapValue2String(map, "id");
			result.setObj(exportFileService.selectFileById(id, localIp));
		}else {
			result.setCode(ResponseEnum.PARAM_LOSE_EXCEPTION.getCode());
			result.setMsg(ResponseEnum.PARAM_LOSE_EXCEPTION.getMsg());
		}
		
		return result;		
	}
}

2.service代码

package com.rhxt.irrmanage.build.service.impl;

import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletResponse;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.rhxt.irrmanage.build.dao.PmTbFilesMapper;
import com.rhxt.irrmanage.build.service.ExportFileService;
import com.rhxt.irrmanage.build.service.IPmTbBiddingInfoService;
import com.rhxt.irrmanage.build.service.IPmTbFeasibilityPlanService;
import com.rhxt.irrmanage.build.service.IPmTbInvestPlanReleaseService;
import com.rhxt.irrmanage.build.service.IPmTbProjectAcceptanceService;
import com.rhxt.irrmanage.build.service.IPmTbProjectPlanService;
import com.rhxt.irrmanage.build.service.IPmTbProjectProgressService;
import com.rhxt.irrmanage.build.service.IPmTbProjectProposalService;
import com.rhxt.irrmanage.build.service.IPmTbReplyBuildService;
import com.rhxt.irrmanage.build.service.IPmTbReplyDesignService;
import com.rhxt.irrmanage.build.service.PmTbProjectStartService;
import com.rhxt.util.ExcelWriter;
import com.rhxt.util.G4Utils;

@Service
public class ExportFileServiceImpl implements ExportFileService {

	private static final Logger log = LoggerFactory.getLogger(ExportFileServiceImpl.class);
	
	@Autowired
	IPmTbProjectProposalService IPmTbProjectProposalService;
	
	@Autowired
	IPmTbProjectPlanService iPmTbProjectPlanService;
	
	@Autowired
	IPmTbBiddingInfoService iPmTbBiddingInfoService;
	
	@Autowired
	IPmTbFeasibilityPlanService iPmTbFeasibilityPlanService;
	
	@Autowired
	IPmTbInvestPlanReleaseService iPmTbInvestPlanReleaseService;
	
	@Autowired
	IPmTbProjectAcceptanceService iPmTbProjectAcceptanceService;
	
	@Autowired
	IPmTbProjectProgressService iPmTbProjectProgressService;
	
	@Autowired
	PmTbProjectStartService pmTbProjectStartService;
	
	@Autowired
	IPmTbReplyBuildService iPmTbReplyBuildService;
	
	@Autowired
	IPmTbReplyDesignService iPmTbReplyDesignService;
	
	@Autowired
	PmTbFilesMapper pmTbFilesMapper;
	
	@Override
	public void exportTradeCreditData(String tableName, HttpServletResponse response, String regionId, String year,
		String state, String irrName, String planName, String superRegionId, String regionType,String selRegionId) {
		Map<String, Object> data = new HashMap<>();
		String fn = "";
		switch (tableName) {
		case "pmTbProjectProposal": //项目建议书 √
			fn = "pmTbProjectProposal";
			List<Map<String, Object>> proposalList = IPmTbProjectProposalService.queryData(regionId, year, state, irrName,superRegionId,regionType, selRegionId);
			data.put("contracts", proposalList);
			break;
		case "pmTbProjectPlan": //规划报告 √
			fn = "pmTbProjectPlan";
			List<Map<String, Object>> proPlanList = iPmTbProjectPlanService.queryData(regionId, year, state, irrName, planName,superRegionId,regionType,"", selRegionId);
			data.put("contracts", proPlanList);
			break;
		case "pmTbFeasibilityPlan":  //可行性研究 √
			fn = "pmTbFeasibilityPlan";
			List<Map<String, Object>> feaPlanList = iPmTbFeasibilityPlanService.queryData(regionId, year, state, irrName,superRegionId,regionType,"", selRegionId);
			data.put("contracts", feaPlanList);
			break;
		case "pmTbReplyDesign": //初步设计 √
			fn = "pmTbReplyDesign";
			List<Map<String, Object>> replyDesList = iPmTbReplyDesignService.queryData(regionId, year, state, irrName,superRegionId,regionType,"", selRegionId);
			data.put("contracts", replyDesList);
			break;
		case "pmTbReplyBuild": //年度实施方案 √
			fn = "pmTbReplyBuild";
			List<Map<String, Object>> replyBuildList = iPmTbReplyBuildService.queryData(regionId, year, state, irrName,superRegionId,regionType,"", selRegionId);
			data.put("contracts", replyBuildList);
			break;
		case "pmTbInvestPlanRelease": //年度投资计划下达 √
			fn = "pmTbInvestPlanRelease";
			List<Map<String, Object>> invPlanList = iPmTbInvestPlanReleaseService.queryData(regionId, year, state, irrName,superRegionId,regionType, selRegionId);
			data.put("contracts", invPlanList);
			break;
		case "pmTbBiddingInfo": //招投标  √
			fn = "pmTbBiddingInfo";
			List<Map<String, Object>> biddingList = iPmTbBiddingInfoService.queryData(regionId, year, state, irrName,superRegionId,regionType, selRegionId);
			data.put("contracts", biddingList);
			break;
		case "pmTbProjectStart": //开工报验 √
			fn = "pmTbProjectStart";
			List<Map<String, Object>> proStartList = pmTbProjectStartService.queryData(regionId, year, state, irrName,superRegionId,regionType, selRegionId);
			data.put("contracts", proStartList);
			break;
		case "pmTbProjectProgress": //建设进度 √
			fn = "pmTbProjectProgress";
			List<Map<String, Object>> progressList = iPmTbProjectProgressService.queryData(regionId, year, state, irrName,superRegionId,regionType, selRegionId);
			data.put("contracts", progressList);
			break;
		case "pmTbProjectAcceptance": //验收管理 √
			fn = "pmTbProjectAcceptance";
			List<Map<String, Object>> proAccList = iPmTbProjectAcceptanceService.queryData(regionId, year, state, irrName,superRegionId,regionType, selRegionId);
			data.put("contracts", proAccList);
			break;
		
		default:
			break;
		}
		
		 try {		
			 response.setContentType("application/vnd.ms-excel");
			 response.setHeader("Content-disposition", "attachment;filename="+new String(("测试导出信息_"+ new SimpleDateFormat("yyyy-MM-dd").format(new Date()).toString() +".xlsx").getBytes(), "iso-8859-1"));
			 OutputStream out = response.getOutputStream();
			 
			//重点 工具类
			ExcelWriter.write(this.getClass().getClassLoader().getResourceAsStream("export/build/"+fn+".xlsx"), out, data);
		} catch (Exception e) {
//			log.warning(e.getMessage());
			e.printStackTrace();
		}
	}

	@Override
	public int deleteFile(String id) {
		int count = 0;
		try {
			count = pmTbFilesMapper.deleteByPrimaryKey(id);
		} catch (Exception e) {
			log.info("删除附件异常，异常位置：ExportFileServiceImpl.deleteFile：异常原因：", e);
		}
		
		return count;
	}

	@Override
	public List<Map<String, Object>> selectFileById(String id, String localIp) {
		List<Map<String, Object>> fileList= pmTbFilesMapper.selectFileById(id);
		for (Map<String, Object> map : fileList) {
			map.put("url", localIp + G4Utils.getMapValue2String(map, "filePath"));
		}
		return fileList;
	}
		

	
}

3.将设计好的excel模板放到指定位置

4.ExcelWriter.write()方法

package com.rhxt.util;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.Map;

import org.jxls.common.Context;
import org.jxls.util.JxlsHelper;

/**
 * 通过模板导出Excel的工具
 * @author Dylan
 *
 */
public class ExcelWriter {
	
	/**
	 * 根据模板输出Excel文件
	 * @param templateInputStream 模板输入流
	 * @param out 要写入的流，一般为文件流或网络流
	 * @param vars 上下文变量
	 * @throws IOException
	 */
	public static void write(InputStream templateInputStream, OutputStream out, Map<String, ? super Object> vars) throws IOException {
		Context context = new Context(vars);		
		JxlsHelper.getInstance().processTemplate(templateInputStream, out, context);
	}
	
	/**
	 * 根据模板输出Excel文件
	 * @param templateFile 模板文件
	 * @param out 要写入的流，一般为文件流或网络流
	 * @param vars 上下文变量
	 * @throws FileNotFoundException
	 * @throws IOException
	 */
	public static void write(File templateFile, OutputStream out, Map<String, ? super Object> vars) throws FileNotFoundException, IOException {
		try (InputStream templateInputStream = new FileInputStream(templateFile)) {
			write(templateInputStream, out, vars);
		}
		
	}
	
	/**
	 * 根据模板输出Excel文件
	 * @param templateFileName 模板文件全名，包含路径
	 * @param out 要写入的流，一般为文件流或网络流
	 * @param vars 上下文变量
	 * @throws FileNotFoundException
	 * @throws IOException
	 */
	public static void write(String templateFileName, OutputStream out, Map<String, ? super Object> vars) throws FileNotFoundException, IOException {
		try (InputStream templateInputStream = new FileInputStream(templateFileName)) {
			write(templateInputStream, out, vars);
		}
		
	}

}

二.前端Vue代码

1.接口

//项目管理表格导出 
    post_XMJYS_exportData:(data) => axios.post(`${proHost}/GDXXH/exportFile/exportTradeCreditData`,data,{
        responseType:'blob',
        headers: {'Content-Type': 'application/json'},
    }),

2.代码

//项目管理 表格导出
async handleExportData({commit}, option){
        let data = {
            ...option,
        }
        let res = await api.post_XMJYS_exportData(data);
        exportDown(res, option.fileName);
    },
// 文件下载
const exportDown = (data, name) =>{
    const blob = new Blob([data], { type: "application/xls" });
    const elink = document.createElement("a");
    elink.download = name + ".xls";
    elink.style.display = "none";
    elink.href = URL.createObjectURL(blob);
    document.body.appendChild(elink);
    elink.click();
    URL.revokeObjectURL(elink.href); // 释放URL对象
    document.body.removeChild(elink);
}

三.Excel模板

1.将对应的字段也就是list中的key放到你想放在的位置（${contract.CITY_NAME}）

 2.加入批注

表头批注（jx:area(lastCell = "BB5")）

字段批注（jx:each(items="contracts" var="contract" lastCell="BB5")）

模板需要遍历的最后一行最后一列

赵书正
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
java导入导出表格功能
weixin_61849521的博客
02-21 408
拿到数据后导入操作就是向数据库里插入数据了，需要注意的就是在做导入的时候要考虑其他功能会不会受到影响，在后续写业务的时候经常会有因为之前导入没有做好而出现的bug。做导出表格功能的时候需要将数据反馈到表格里，所以先获取到需要的数据后。表数据 导出的数据是一行一行插入进去的，所以先创建一个List用来存放一行的数据。在工作中有很多导入导出功能，之前没有接触过，所以刚开始做的时候很费时间，看不懂代码，现在熟悉了，来总结一下。到这步数据的处理已经完成了，接下来就是处理导出表格部分了。
java导出excel框架_java代码实现导出Excel表格、工具ssm框架、maven、idea
weixin_29468871的博客
02-13 204
第一步、导入依赖org.apache.poipoi3.9org.apache.poipoi-examples3.9org.apache.poipoi-excelant3.9org.apache.poipoi-ooxml3.9org.apache.poipoi-ooxml-schemas3.9org.apache.poipoi-scratchpad3.9第二步，编写实体类public class Z...
java excel框架_java 导出 excel 最佳实践，大文件 excel 避免OOM(内存溢出) 框架-02-API...
weixin_31111015的博客
02-24 245
项目简介IExcel 用于优雅地读取和写入 excel。避免大 excel 出现 oom，简约而不简单。。特性OO 的方式操作 excel，编程更加方便优雅。sax 模式读取，SXSS 模式写入。避免 excel 大文件 OOM。基于注解，编程更加灵活。写入可以基于对象列表，也可以基于 Map，实际使用更加方便。设计简单，注释完整。方便大家学习改造。变更日志v0.0.4 主要变化引入 ExcelB...
java导出excel框架_Java SpringMVC框架开发之数据导出Excel文件格式实例详解
weixin_39552179的博客
02-13 165
在平时的开发中，我们会经常遇到这样一个需求，要在页面通过一个『导出』按钮把查询出的数据导出到 Excel 表格中。本文即为实现上述需求的一个小实例。环境配置jar包poi.jarjdk 1.6tomcat 7.0eclipse 4.4.0本 Demo 是在 SpringMVC框架中实现。页面export.jsp 很简单，就只有一个超链接。pageEncoding="UTF-8"%>数据导出E...
基于poi封装的导出Excel文件框架（Java实现）
一火的专栏
04-15 1196
最近把数据导出为Excel文件并保存到本地，由于有很多功能都会用到导出功能，所以就简单封装了一个导出框架，分享给大家。 导出框架思路： 1.一个Map对应一条数据记录 2.多条数据存放在List对象中 3.为了简化导出框架，该框架是基于HttpServlet+Web项目实现，如果在SpringBoot或者SpringMVC框架中使用，就把Servlet中代码写到Service业务逻辑...
Java导出数据到Excel文件中（支持多表头）
08-17
支持从数据库中查询到数据，以多级表头形式导入到Excel文件中。比如：一级表头：学号、姓名、各科成绩。二级表头：语文、数学、英语（二级表头在各科成绩下面）。
Java实现生成Excel树形表头完整代码示例
08-28
Java实现生成Excel树形表头完整代码示例 Java实现生成Excel树形表头完整代码示例是指使用Java语言编写程序来生成Excel树形表头的完整代码示例。下面将详细介绍该示例中的知识点。 首先，需要了解的是树形表头的...
java导出excel复杂表头
02-20
java工程，源代码，可直接运行，需自己改造成web下载方式。
java实现导出Excel多行表头复杂模板
12-20
java实现导出Excel多行表头复杂模板 一般我们都会选择poi来导出，选择一个比较好的ExcelUtils 但是对于初学者而言不了解poi的，还需从poi API文档去学习，如果是自学的话更好，如果是公司安排的任务，没有接触过有...
java导出excel复合表头简单实例
05-10
本资源实现了Excel的简单导出实例，同时也实现了导出Excel复合表头的简单实例，适合一些需要用到导出Excel技术的初学者。
java根据模板使用框架生成Excel
05-31
使用jxls框架生成Excel，简单易懂。内含所使用的引用jar包版本。
Java中excel文件导入和导出POI框架
伟哥
01-22 801
导入代码： /** * 导入 * @param msg * @return * @throws IOException */ @AuthExclude(internetForbidden = false) public String importData(Message msg) throws IOException { QueryRole queryRole =...
Java实现Excel导出
Amaranth__的博客
02-20 660
Java实现Excel导出 设置相应头中的下载头 设置文本类型为Excel类型 个别有跨域问题 可以添加跨域头 HSSFWorkbook workbook = getWorkbook(mettingMainInfo); try { response.reset(); response.setHeader(&amp;quot;Content-Type&amp;quot;, &amp;quot;applic...
使用java实现excel的导出（超级简单）
航仔的博客
08-31 148
Excel导出
Java 手写，导出Excel文件
Finegrill的博客
08-02 311
导出EXCEL
java 导出excel (通过map传参)
qq_38198180的博客
06-02 3107
@RequestMapping("/exportExcel") public void exportExcel(Map<String,String> map, HttpServletResponse response){ List<Map<String,String>> mapList = userService.getUserList(map);//通过...
Java 解析 /生成 Excel文件
热门推荐
wan25110712的博客
07-17 1万+
在程序的开发过程中，通常会使用Excel文件来进行数据的导入和导出，在使用Java实现此类需求时也要经理Excel文件的解析或生成在Java技术中，能实现此类需求的技术主要有ApachePOI,AlibabaEasyExcel和JXL。其中，JXL只支持Excel2003以下版本，所以现在不太常见，那简单学习一下另外两种技术吧。...
java poi excel 大文件名,java poi导出excel response.setHeader设置导出文件名抓包不合法及处理导出文件名为action方法名...
weixin_42320493的博客
03-19 763
问题出现1：spring MVC 框架下使用poi导出excel，设置导出文件名：response.setHeader("Content-Disposition", "attachment;filename="+sourceId+"_"+dateString+".xls");该方法进行抓包测试时，显示BUG url不合法。解决办法：对"attachment;filename="+source...
Java导出Excel文件 数据源为List
玻璃渣渣瓶的随笔记录
08-31 2363
一个Java导出Excel的通用类for List&lt;Map&lt;String,Object&gt;&gt; 因为自己需要用，所以照着entity数据源改成了List&lt;Map&lt;String,Object&gt;&gt; 记录一下 传入本方法指定的参数直接调用就可以了 import java.io.OutputStream; import java.text.Simp...
javaexcel导出方法如何写
最新发布
06-03
Java中实现Excel导出主要是通过POI类库来实现的，具体步骤如下： 1. 创建工作簿和工作表 ```java Workbook workbook = new HSSFWorkbook(); // 创建工作簿 Sheet sheet = workbook.createSheet("Sheet1"); // 创建...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值