java excel读取操作,Java读取Excel并操作

valueList = new ArrayList();

FileInputStream fis = null;

try {

fis = new FileInputStream(filePath);

XSSFWorkbook xwb = new XSSFWorkbook(fis); // 构造 XSSFWorkbook

// 对象，strPath 传入文件路径

XSSFSheet sheet = xwb.getSheetAt(0); // 读取第一章表格内容

// 定义 row、cell

XSSFRow row;

// 循环输出表格中的第一行内容 表头

Object[] titles = new Object[num];

row = sheet.getRow(0);

if (row != null) {

for (int j = row.getFirstCellNum(); j < num; j++) {

// 通过 row.getCell(j).toString() 获取单元格内容，

if (row.getCell(j) != null) {

if (!row.getCell(j).toString().isEmpty()) {

titles[j] = row.getCell(j).toString();

}

} else {

// titles[j]="";

}

}

}

// 循环输出表格中的从第二行开始内容

for (int i = sheet.getFirstRowNum() + 1; i <= sheet

.getPhysicalNumberOfRows(); i++) {

row = sheet.getRow(i);

if (row != null) {

boolean isValidRow = false;

Object[] content = new Object[num];

for (int j = row.getFirstCellNum(); j < num; j++) {

XSSFCell cell = row.getCell(j);

if (cell != null) {

String cellValue = cell.toString();

if (cellValue != null

&& cellValue.trim().length() <= 0) {

cellValue = null;

}

content[j] = cellValue;

if (!isValidRow && cellValue != null

&& cellValue.trim().length() > 0) {

isValidRow = true;

}

}

}

// 第I行所有的列数据读取完毕，放入valuelist

if (isValidRow) {

valueList.add(content);

}

}

}

} catch (IOException e) {

e.printStackTrace();

} finally {

fis.close();

}

return valueList;

}

}