java输出Excel文件

java使⽤easyexcel通过模板导出excel（基于若依）1.准备excel模板注：数据类型为map⽤{}，数据类型为List⽤{.}2.在项⽬中resource⽬录下新建⽬录static，然后把准备好的模板扔进去3.maven中添加相关依赖<dependency><groupId>com.alibaba</groupId><artifactId>easyexcel</artifactId><version>2.1.6</version><exclusions><exclusion><groupId>org.apache.poi</groupId><artifactId>poi</artifactId></exclusion><exclusion><groupId>org.apache.poi</groupId><artifactId>poi-ooxml</artifactId></exclusion><exclusion><groupId>org.ehcache</groupId><artifactId>ehcache</artifactId></exclusion></exclusions></dependency>4.导出excel并返回⽂件名称供前端下载public AjaxResult test(Map map,List list) throws IOException {InputStream inputStream = this.getClass().getClassLoader().getResourceAsStream("static/"+"test.xlsx");String fileName = UUID.randomUUID().toString() + "_" + "test.xlsx";String downloadPath = RuoYiConfig.getDownloadPath() + fileName;OutputStream out=new FileOutputStream(downloadPath);ExcelWriter excelWriter = EasyExcel.write(out).withTemplate(inputStream).build();WriteSheet writeSheet = EasyExcel.writerSheet().build();excelWriter.fill(list, writeSheet);excelWriter.fill(map, writeSheet);excelWriter.finish();return AjaxResult.success(fileName);}5.结果：。

java实现导出Excel（跨行跨列）在Java中，可以使用Apache POI库来实现导出Excel文件，并且可以实现跨行和跨列的功能。

Apache POI是一个开源的Java库，可以处理Microsoft Office格式的文档，包括Excel。

以下是使用Apache POI库实现导出Excel文件的步骤：1. 首先，需要引入Apache POI依赖。

可以在Maven或Gradle中添加以下依赖项：```xml<!-- Apache POI --><dependency><groupId>org.apache.poi</groupId><artifactId>poi</artifactId><version>4.1.2</version></dependency><dependency><groupId>org.apache.poi</groupId><artifactId>poi-ooxml</artifactId><version>4.1.2</version></dependency>2. 创建一个Workbook对象，该对象代表一个Excel文件：```javaWorkbook workbook = new XSSFWorkbook(;```3. 创建一个Sheet对象，该对象代表Excel文件中的一个工作表：```javaSheet sheet = workbook.createSheet("Sheet1");```4. 创建行和单元格，根据需要设置跨行和跨列的属性。

可以使用CellRangeAddress类来实现跨行和跨列的功能：```javaRow row = sheet.createRow(0);Cell cell = row.createCell(0);cell.setCellValue("跨行跨列");//合并单元格，从第1行到第3行，从第1列到第5列CellRangeAddress cellRangeAddress = new CellRangeAddress(0, 2, 0, 4);sheet.addMergedRegion(cellRangeAddress);5. 将数据写入Excel文件中的单元格：```javaRow row = sheet.createRow(0);Cell cell = row.createCell(0);cell.setCellValue("Hello");```6. 将Workbook对象写入到文件中：```javaFileOutputStream fileOutputStream = new FileOutputStream("output.xlsx");workbook.write(fileOutputStream);fileOutputStream.close(;```完整的示例代码如下所示：```javaimport ermodel.*;import org.apache.poi.ss.util.CellRangeAddress;import ermodel.XSSFWorkbook;import java.io.FileOutputStream;import java.io.IOException;public class ExcelExporterpublic static void main(String[] args) throws IOExceptionWorkbook workbook = new XSSFWorkbook(;Sheet sheet = workbook.createSheet("Sheet1");Row row = sheet.createRow(0);Cell cell = row.createCell(0);cell.setCellValue("跨行跨列");//合并单元格，从第1行到第3行，从第1列到第5列CellRangeAddress cellRangeAddress = new CellRangeAddress(0, 2, 0, 4);sheet.addMergedRegion(cellRangeAddress);FileOutputStream fileOutputStream = newFileOutputStream("output.xlsx");workbook.write(fileOutputStream);fileOutputStream.close(;System.out.println("Excel文件导出成功！");}```执行该代码后，会在项目的根目录下生成一个名为`output.xlsx`的Excel文件，其中包含一个跨行和跨列的单元格。

下面是本人使用java的poi实现使用模板到处excel，内容包含图片，使用两种不同的方式实现其到处excel。

但是使用jxl实现到处excel只能到处png格式。

package com.rxc.servlet;import java.awt.image.BufferedImage;import java.io.BufferedInputStream;import java.io.BufferedOutputStream;import java.io.ByteArrayOutputStream;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import javax.imageio.ImageIO;import javax.servlet.ServletException;import javax.servlet.ServletOutputStream;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import ermodel.HSSFCell;import ermodel.HSSFClientAnchor;import ermodel.HSSFPatriarch;import ermodel.HSSFRow;import ermodel.HSSFSheet;import ermodel.HSSFWorkbook;import org.apache.poi.poifs.filesystem.POIFSFileSystem;public class OutExcelServlet extends HttpServlet {private static final long serialVersionUID = 1L;public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {this.doPost(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {String accident_id = request.getParameter("accident_id");String OnputimagePath = null;/***********************************************使用poi实现excel模版导出excel********************/try {POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("d:\\设备异常分析报告.xls"));HSSFWorkbook wb = new HSSFWorkbook(fs);HSSFSheet sheet = wb.getSheet("设备异常分析报告");HSSFRow row = sheet.getRow(2);HSSFCell cell = row.getCell((short) 2);if (cell == null){cell = row.createCell((short) 2);}cell.setCellType(HSSFCell.CELL_TYPE_STRING);cell.setCellValue("12321212");ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();String InputimagePath = "d:\\1012051443548604211337adf6.jpg";BufferedImage bufferImg = ImageIO.read(new File(InputimagePath));ImageIO.write(bufferImg,"JPG",byteArrayOut);//设置图片大小，位置HSSFClientAnchor anchor = new HSSFClientAnchor(5,0,500,122,(short) 0, 5,(short)10,15);//创建HSSFPatriarch patri = sheet.createDrawingPatriarch();patri.createPicture(anchor ,wb.addPicture(byteArrayOut.toByteArra y(), HSSFWorkbook.PICTURE_TYPE_PNG));// 输出文件OnputimagePath = "d:\\test1.xls";FileOutputStream fileOut = new FileOutputStream(OnputimagePath);wb.write(fileOut);fileOut.close();} catch (Exception e) {e.printStackTrace();}// 检查文件是否存在File obj = new File(OnputimagePath);if (!obj.exists()) {r esponse.setContentType("text/html;charset=GBK");r esponse.getWriter().print("指定文件不存在！");return;}// 读取文件名：用于设置客户端保存时指定默认文件名int index = stIndexOf("\\"); // 前提：传入的path 字符串以“\”表示目录分隔符String fileName = OnputimagePath.substring(index + 1);// 写流文件到前端浏览器ServletOutputStream out = response.getOutputStream();response.setHeader("Content-disposition","attachment;filename=" + fileName);BufferedInputStream bis = null;BufferedOutputStream bos = null;try {bis = new BufferedInputStream(new FileInputStream(OnputimagePath));bos = new BufferedOutputStream(out);byte[] buff = new byte[2048];int bytesRead;while (-1 != (bytesRead = bis.read(buff, 0, buff.length))) { bos.write(buff, 0, bytesRead);}} catch (IOException e) {throw e;} finally {if (bis != null)bis.close();if (bos != null)bos.close();}}/*****************使用jxl实现excel模版导出excel 但导出图片仅支持png格式**************************************String realpath = "D:/test.xls";try {CopeDate data = new CopeDate();MapList mp = data.getdata(accident_id);//选择模板文件：Workbook wb = Workbook.getWorkbook(new File(realpath));//第二步：通过模板得到一个可写的Workbook：第一个参数是一个输出流对象,第二个参数代表了要读取的模板File targetFile = new File("D:/test1.xls");WritableWorkbook wwb = Workbook.createWorkbook(targetFile, wb);//第三步：选择模板中名称为设备异常的Sheet：WritableSheet wws = wwb.getSheet("JustCell");//第四步：选择单元格，写入动态值，根据单元格的不同类型转换成相应类型的单元格：Label A1 = new Label(0, 1,mp.getRow(0).get("accident_name"));wws.addCell(A1);//插入图片File imgFile = new File("D:/test.png");WritableImage image = new WritableImage(2, 1, 8, 20, imgFile);wws.addImage(image);wwb.write();wwb.close();wb.close();} catch (BiffException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (WriteException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}********************************************************************* *******/}。

javaexcel导出（可⾃定义导出列）import java.beans.PropertyDescriptor;import java.io.FileOutputStream;import java.io.IOException;import java.io.OutputStream;import ng.reflect.Field;import ng.reflect.Method;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Collection;import java.util.Date;import java.util.Iterator;import java.util.List;import java.util.regex.Matcher;import java.util.regex.Pattern;import ermodel.HSSFCell;import ermodel.HSSFCellStyle;import ermodel.HSSFClientAnchor;import ermodel.HSSFComment;import ermodel.HSSFFont;import ermodel.HSSFPatriarch;import ermodel.HSSFRichTextString;import ermodel.HSSFRow;import ermodel.HSSFSheet;import ermodel.HSSFWorkbook;import org.apache.poi.hssf.util.HSSFColor;public class ExportExcelUtil<T> {public String[] exportExcelHeader(Class<T> clz){Field fields[] = clz.getDeclaredFields();String[] name = new String[fields.length];try{Field.setAccessible(fields, true);for (int i = 1; i < fields.length; i++) {name[i] = fields[i].getName();System.out.println(name[i] + "-> ");}}catch(Exception e){e.printStackTrace();}return name;}public void exportExcel(Collection<T> dataset, OutputStream out) {exportExcel("导出EXCEL⽂档", null,null, dataset, out, "yyyy-MM-dd");}public void exportExcel(String[] headers, Collection<T> dataset,OutputStream out) {exportExcel("导出EXCEL⽂档", null,headers, dataset, out, "yyyy-MM-dd");}public void exportExcel(String title, String[] headers,Collection<T> dataset, OutputStream out) {exportExcel(title,null, headers, dataset, out, "yyyy-MM-dd");}public void exportExcel(String title,String[] headerTitle, String[] headers,Collection<T> dataset, OutputStream out) {exportExcel(title,headerTitle, headers, dataset, out, "yyyy-MM-dd");}public void exportExcel(String[] headerTitle,String[] headers, Collection<T> dataset,OutputStream out, String pattern) {exportExcel("导出EXCEL⽂档",headerTitle, headers, dataset, out, pattern);}/*** 这是⼀个通⽤的⽅法，利⽤了JAVA的反射机制，可以将放置在JAVA集合中并且符号⼀定条件的数据以EXCEL 的形式输出到指定IO设备上** @param title* 表格标题名* @param headerTitle* 表格属性列名数组（标题）若为null，默认显⽰headers* @param headers* 表格属性列名数组* @param dataset* 需要显⽰的数据集合,集合中⼀定要放置符合javabean风格的类的对象。