java 判断函数是否存在_java操作excl中有没有哪个函数是判断用来判断是否存在该名字的工作表。...

HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(""/*输入路径*/));//获得Xls实例 workbook

for (int numSheets = 0; numSheets < workbook.getNumberOfSheets(); numSheets++) {

if (null != workbook.getSheetAt(numSheets)) {

HSSFSheet aSheet = workbook.getSheetAt(numSheets);// 获得一个sheet

//String sheetName = aSheet.getSheetName();

for (int rowNumOfSheet = 1; rowNumOfSheet <= aSheet.getLastRowNum(); rowNumOfSheet++) {

if (null != aSheet.getRow(rowNumOfSheet)) {

HSSFRow aRow = aSheet.getRow(rowNumOfSheet);

for (int cellNumOfRow = 0; cellNumOfRow <= aRow.getLastCellNum(); cellNumOfRow++) {

HSSFCell aCell = aRow.getCell(cellNumOfRow);

int cellType = aCell.getCellType();

HSSFCellStyle style = aCell.getCellStyle();

String strCell = null;

switch (cellType) {

case 0:// Numeric

strCell = df.format(aCell.getNumericCellValue());

break;

case 1:// String

strCell = aCell.getStringCellValue();

break;

}

}

}

}

}

}

其中引用poi-3.7-20101029.jar

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;