java 导出excel

最新推荐文章于 2024-07-03 14:13:18 发布

Blaze Jack

最新推荐文章于 2024-07-03 14:13:18 发布

阅读量203

点赞数

分类专栏： JAVA

本文链接：https://blog.csdn.net/qq_37325947/article/details/103260749

版权

JAVA 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

导入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();
    }
}