poi 导出excel

1、添加jar 

        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.16</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.16</version>
        </dependency>

2、编辑excel

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.File;
import java.io.FileOutputStream;

/**
 * Created by Steve on 2018/10/24 0024.
 */
public class XLSXFileWriter {

    public static void writer() throws Exception {
        Workbook workbook = new XSSFWorkbook();
        // 创建shell
        Sheet sheet = workbook.createSheet("南京英霸建材科技发展有限公司财务指标对比结果表");

        // 创建行
        Row row = sheet.createRow(0);
        // 创建列
        Cell cell = row.createCell(0);
        cell.setCellValue("南京英霸建材科技发展有限公司财务指标对比结果表");
        // 合并单元格(行，行，列，列)
        sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 2));
        // 设置单元格样式
        CellStyle cellStyle = workbook.createCellStyle();
        // 设置水平居中
        cellStyle.setAlignment(HorizontalAlignment.CENTER);
        // 设置垂直居中
        cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
        cell.setCellStyle(cellStyle);

        row = sheet.createRow(1);
        row.createCell(0).setCellValue("导出日期：2018-09-10");
        sheet.addMergedRegion(new CellRangeAddress(1, 1, 0, 1));
        row = sheet.createRow(2);
        // 设置字体加粗
        cellStyle = workbook.createCellStyle();
        // 设置水平居中
        cellStyle.setAlignment(HorizontalAlignment.CENTER);
        // 设置垂直居中
        cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
        Font font = workbook.createFont();
        font.setBold(true);
        cellStyle.setFont(font);
        cell = row.createCell(0);
        cell.setCellValue("指标值");
        cell.setCellStyle(cellStyle);
        cell = row.createCell(1);
        cell.setCellValue("南京英霸建材科技发展有限公司");
        cell.setCellStyle(cellStyle);
        cell = row.createCell(2);
        cell.setCellValue("陆特能源");
        cell.setCellStyle(cellStyle);

        // 设置自适应列宽
        for (int i = 0; i < 3; i++) {
            sheet.autoSizeColumn(i,true);
            sheet.setColumnWidth(i,sheet.getColumnWidth(i)*2);
        }

        File file = new File("F:/var/excel/test.xlsx");
        if (!file.getParentFile().exists())
            file.getParentFile().mkdirs();
        workbook.write(new FileOutputStream(file));
    }

    public static void main(String[] args) throws Exception {
        writer();
        System.out.println("完成");
    }
}