单机版导出excl表格工具包，复制就能用

这里复制过去，直接使用，数据是需要格式的

package com.zxxx.otlp.controller.util;

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.util.RegionUtil;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFCell;

import java.io.FileOutputStream;
import java.util.*;

public class ExcelUtil {
	

	public static void main(String[] args) {

		//存标头
		List<String> titleList = new ArrayList<>();
		for (int i=0;i<10;i++){
			titleList.add(i,"第"+(i+1)+"列表头");
		}

		List<Object> valueList = new ArrayList<>();
		for (int i=0;i<4;i++){
			List<String> valueOneList = new ArrayList<>();
			for (int j=0;j<10;j++){
				valueOneList.add(j,"第"+(i+1)+"行第"+(j+1)+"列数据");
			}
			valueList.add(valueOneList);
		}
		//长宽  长宽设置，有几列数据，就写几个数据
		List<Object> columnWidthList = new ArrayList<>();
		columnWidthList.add(0,15*256);
		columnWidthList.add(1,20*256);

        String firstTitleName = "第一行合并标题";
		String SheetName = "sheet1的名字";
        String fileUrl = "D://";
        exporExcel(titleList,valueList,firstTitleName,SheetName,fileUrl,columnWidthList);
    }

	public static String exporExcel(List<String> titleList, List<Object> valueList, String firstTitleName,String SheetName, String fileUrl,List<Object> columnWidthList){
		String saveFilePath = "";
        try {
	        SXSSFWorkbook workbook = new SXSSFWorkbook();
	        Sheet sheet = workbook.createSheet(firstTitleName);

			// 在索引0的位置创建行（最顶端的行）
			Row row = sheet.createRow(0);
			// 在索引0的位置创建单元格(左上端)
			Cell cell = row.createCell(0);
			// 定义单元格为字符串类型
			cell.setCellType(XSSFCell.CELL_TYPE_STRING);

			//合并单元格
			CellRangeAddress region = new CellRangeAddress(0, 0, 0, titleList.size()-1);
			RegionUtil.setBorderBottom(BorderStyle.THIN, region, sheet);
			RegionUtil.setBorderLeft(BorderStyle.THIN, region, sheet);
			RegionUtil.setBorderRight(BorderStyle.THIN, region, sheet);
			RegionUtil.setBorderTop(BorderStyle.THIN, region, sheet);
			sheet.addMergedRegion(region);
			// 在单元格中输入一些内容
			cell.setCellValue(SheetName);

			//设置列的宽度，第一个参数为列的序号，从0开始，第二参数为列宽，单位1/256个字节
			for (int i=0;i<columnWidthList.size();i++){
				sheet.setColumnWidth(i, (Integer) columnWidthList.get(i));
			}

			//设置表头
			int x = 0;//行计数器
			row = sheet.createRow(x + 1);
			x++;
			int fieidnum = 0;//列计数器
			for (int i=0;i<titleList.size();i++){
				cell = row.createCell(fieidnum);
				cell.setCellType(XSSFCell.CELL_TYPE_STRING);
				cell.setCellValue(titleList.get(i).toString());
				fieidnum++;
			}

			//填充数据
			for (Object ex : valueList) {
				row = sheet.createRow(x + 1);
				List<String> valueOneList = (List<String>) ex;
				for (int i=0;i<valueOneList.size();i++)
				{
					// 在索引0的位置创建单元格(左上端)
					cell = row.createCell(i);
					// 定义单元格为字符串类型
					cell.setCellType(XSSFCell.CELL_TYPE_STRING);
					// 在单元格中输入一些内容
					cell.setCellValue(valueOneList.get(i).toString());
				}
				x++;
			}

			String saveFileName =  UUID.randomUUID().toString()+".xlsx";
			saveFilePath = fileUrl+"/"+saveFileName;
			// 新建文件输出流
	        FileOutputStream fOut = new FileOutputStream(saveFilePath);
	        // 将数据写入Excel
	        workbook.write(fOut);
	        fOut.flush();
	        fOut.close();

			System.out.printf("saveFilePath--->"+saveFilePath);
		}catch (Exception e){
			System.out.printf("e.getMessage();--->"+e.getMessage());
		}
		return  saveFilePath;
	}



}