使用poi将数据导出到excel中

最新推荐文章于 2024-01-09 09:51:36 发布

在知识的海洋中遨游

最新推荐文章于 2024-01-09 09:51:36 发布

阅读量231

点赞数

分类专栏：工具类

本文链接：https://blog.csdn.net/qq_33283652/article/details/80266933

版权

工具类专栏收录该内容

1 篇文章 0 订阅

订阅专栏

package com.liu.warehouse.commons.excel;

import java.io.FileOutputStream;
import java.sql.ResultSet;
import java.util.List;

import com.liu.warehouse.model.MenuExcel;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ReadExcelFromDB {

    public final static String outputFile = "D:/test.xlsx";

    public void ReadExcel(List<MenuExcel> menuExcels) {
        try {
            XSSFWorkbook workbook = new XSSFWorkbook();
            XSSFSheet sheet = workbook.createSheet("菜单");
            XSSFRow row = sheet.createRow((short) 0);
            XSSFCell cell = null;
            cell = row.createCell((short) 0);
            cell.setCellValue("菜名");
            cell = row.createCell((short) 1);
            cell.setCellValue("单价");
            cell = row.createCell((short) 2);
            cell.setCellValue("原材料名");
            cell = row.createCell((short) 3);
            cell.setCellValue("数量");

            int i = 1;
            for (MenuExcel menuExcel: menuExcels) {
                row = sheet.createRow(i);
                cell = row.createCell(0);
                cell.setCellValue(menuExcel.getDishName());
                cell = row.createCell(1);
                cell.setCellValue(menuExcel.getTotalPrice());
                cell = row.createCell(2);
                cell.setCellValue(menuExcel.getMaterialName());
                cell = row.createCell(3);
                cell.setCellValue(menuExcel.getAmount());
                i++;
            }
            FileOutputStream FOut = new FileOutputStream(outputFile);
            workbook.write(FOut);
            FOut.flush();
            FOut.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

使用XSSF将List<MenuExcel>中的数据导出到excel表中

导入依赖

<dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.15</version>
        </dependency>