poi读取XLSX

package com.gi.cyw.util;

import com.alibaba.druid.util.StringUtils;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.io.FileInputStream;
import java.io.IOException;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.LinkedList;
import java.util.List;

/**

• Created by Lola on 2019/7/16 18:52.
  */

public class IOUtil {在这里插入代码片

private static Logger logger = LoggerFactory.getLogger(IOUtil.class);
private static Workbook wb = null;

private static DecimalFormat df = new DecimalFormat("0");
private static SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
private static DecimalFormat nf = new DecimalFormat("0.00");

public static List<List<Object>> readExcel(Workbook wb, Integer t) throws IOException {
        List<List<Object>> list = new LinkedList<List<Object>>();
        Sheet sheet = wb.getSheetAt(0);//为第一页
        Object value = null;
        Row row = null;
        Cell cell = null;
        int counter = 0;
        int cellNum = 0;
        int f = 1;
        if (t != null && t == 1) {
            f = 0;
        }
        for (int i = sheet.getFirstRowNum(), e = sheet.getPhysicalNumberOfRows(); counter < e; i++) {
            row = sheet.getRow(i);
            int cellNo = 0;
            if (row != null) {
                cellNo = row.getPhysicalNumberOfCells();
            }
            if (row == null) {
                continue;
            } else if (cellNo <= f) {
                counter++;
                continue;
            } else {
                counter++;
            }
            if (i == 0) {
                cellNum = row.getLastCellNum();
            }

            List<Object> linked = new LinkedList<Object>();
            for (int j = 0; j < cellNum; j++) {
                cell = row.getCell(j);
                if (cell == null) {
                    linked.add(null);
                    continue;
                }

                switch (cell.getCellType()) {
                    case Cell.CELL_TYPE_STRING:
                        value = cell.getStringCellValue();
                        break;

                    case Cell.CELL_TYPE_BOOLEAN:
                        value = cell.getBooleanCellValue();
                        break;
                    case Cell.CELL_TYPE_BLANK:
                        value = "";
                        break;
                    default:
                        value = cell.toString();
                }
                if (j == 0 && StringUtils.isEmpty(value == null ? null : value.toString())) {
                    break;
                }
                linked.add(value);
            }
            if (linked.size() == 0) break;
            list.add(linked);
        }
        if (list == null || list.size() <= 0) {
            return null;
        }
        return list;
    }

public List mainList() throws IOException {
    wb= new HSSFWorkbook(new FileInputStream("F:\\设备信息1563254976769(2)(1).xls"));
    List<List<Object>> lists = readExcel(wb, null);
    lists.remove(0);
    List<String> list = new ArrayList<>();
    for (List<Object> l:lists) {
        String remove = l.remove(1).toString();
        list.add(remove);
    }

    return list;
}

}