java 导出excel

导入gradle依赖,

 // https://mvnrepository.com/artifact/org.apache.poi/poi
    compile group: 'org.apache.poi', name: 'poi', version: '4.1.1'

maven同理

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

上代码

import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import java.io.FileOutputStream;
import java.io.IOException;

/**
 * @description:
 * @author: Blaze Jack
 * @create: 2019-11-26 16:45
 **/
public class CodeTest {

    public static void main(String[] args) throws IOException {
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet();
        //创建一行
        HSSFRow rows = sheet.createRow(0);
        //填充这行
        rows.createCell(0).setCellValue("第一列");
        rows.createCell(1).setCellValue("第二列");
        workbook.setSheetName(0, "toatl");
        FileOutputStream out = new FileOutputStream("D:\\test" + ".xls");
        workbook.write(out);
        out.close();
    }
}

本文已参与「新人创作礼」活动，一起开启掘金创作之路