poj读取excel文档工具类

参数说明：
path：文件路径
sheetindex：工作表索引
rowindex：起始行索引
len:行长

package com.lzcu.utils;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

/**
 * Created by linzai520 2020/3/21
 */
public class ReadUtils {


	public static List<String[]> read(String path,int sheetindex,int rowindex,int len) throws IOException {

		List<String[]> data = new ArrayList<String[]>();
		//1.获取工作簿
		XSSFWorkbook workbook = new XSSFWorkbook(path);
		//2.获取工作表
		XSSFSheet sheet = workbook.getSheetAt(sheetindex);

		for (int i = rowindex; i < sheet.getLastRowNum(); i++) {
			XSSFRow row = sheet.getRow(i);
			if (row!=null){
			//	List<String> list=new ArrayList<String>();
				String[] list =new String[len];
				int j = 0;
				for (Cell cell : row) {
					if (cell!=null){
						cell.setCellType(Cell.CELL_TYPE_STRING);
						String value = cell.getStringCellValue();
						if (value!=null&&!value.equals("")){
							list[j++]=value;
						}
					}
				}
				data.add(list);
			}

		}

		return data;
	}
}