package util;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class ExcelUtil {
/**
* 读取
* @param pathUrl
* @return
* @throws FileNotFoundException
* @throws IOException
*/
public static List<Object[]> getExcelXls(String pathUrl,int cellnum) throws FileNotFoundException, IOException{
List<Object[]> list = new ArrayList<>();
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(pathUrl));
for (int i = 0; i < workbook.getNumberOfSheets(); i++) {// 循环sheet
if(workbook.getSheetAt(i).getPhysicalNumberOfRows()>0){
HSSFSheet childSheet = workbook.getSheetAt(i);
int num = childSheet.getLastRow
Excel读取工具类(.xls)
最新推荐文章于 2024-07-24 20:55:11 发布