Poi的简单读取的使用

最新推荐文章于 2024-10-01 18:51:18 发布

董十二

最新推荐文章于 2024-10-01 18:51:18 发布

阅读量214

点赞数

文章标签： java 开发语言

本文链接：https://blog.csdn.net/m0_46556534/article/details/122353247

版权

package com.HZNU.Controller;

import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.DateUtil;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.swing.filechooser.FileSystemView;
import java.io.BufferedInputStream;
import java.io.FileInputStream;
import java.io.IOException;
import java.text.DateFormat;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

@RestController
@RequestMapping("POI") //这样过滤后，get和post请求都可以接收到
public class PoiController {
    @GetMapping("getXls")
    public void getXls() throws IOException {
        FileSystemView fsv = FileSystemView.getFileSystemView();
        String desktop = fsv.getHomeDirectory().getPath();//拿桌面路径
        String filepath = new String("src\\main\\resources\\xls\\"+"columns2.xls");//java中file读取路径是从项目包开始的
        FileInputStream fileInputStream = new FileInputStream(filepath);
        BufferedInputStream bufferedInputStream = new BufferedInputStream(fileInputStream);//输入流
        POIFSFileSystem fileSystem = new POIFSFileSystem(bufferedInputStream);
        HSSFWorkbook workbook = new HSSFWorkbook(fileSystem);
        HSSFSheet sheet = workbook.getSheetAt(0);
        int lastRowIndex = sheet.getLastRowNum();
        System.out.println(lastRowIndex);
        for (int i = 0; i <= lastRowIndex; i++) {
            HSSFRow row = sheet.getRow(i);
            if (row == null) { break; }
            short lastCellNum = row.getLastCellNum();
            for (int j = 0; j < lastCellNum; j++) {
                int type = row.getCell(j).getCellType();
                String cellValue = "";
                switch (type) {
                    case Cell.CELL_TYPE_NUMERIC:
                        if (DateUtil.isCellDateFormatted(row.getCell(j))) { //判断是否为日期类型
                            Date date = row.getCell(j).getDateCellValue();
                            DateFormat formater = new SimpleDateFormat("yyyy-MM-dd");
                            cellValue = formater.format(date);
                        } else {
                            DecimalFormat df = new DecimalFormat("####.####");
                            cellValue = df.format(row.getCell(j).getNumericCellValue());
                        }
                        break;
                    case Cell.CELL_TYPE_STRING:
                        cellValue = row.getCell(j).getStringCellValue();
                        break;
                    case Cell.CELL_TYPE_BOOLEAN:
                        cellValue = row.getCell(j).getBooleanCellValue() + "";
                        break;
                    case Cell.CELL_TYPE_BLANK: //空值
                        cellValue = "";
                    case Cell.CELL_TYPE_ERROR:
                        cellValue = "非法字符";
                        break;
                }
                System.out.println(cellValue);
            }
        }


    }
}