- import java.io.File;
- import java.io.FileInputStream;
- import org.apache.poi.hssf.usermodel.HSSFCell;
- import org.apache.poi.hssf.usermodel.HSSFRow;
- import org.apache.poi.hssf.usermodel.HSSFSheet;
- import org.apache.poi.hssf.usermodel.HSSFWorkbook;
- import org.apache.poi.poifs.filesystem.POIFSFileSystem;
- public class FileAnaly {
- public static void main(String[] args) {
- try {
- //获取文件流
- POIFSFileSystem pois = new POIFSFileSystem(new FileInputStream(new File("D:/codeimages/账户信息.xls")));
- //新建WorkBook
- HSSFWorkbook wb = new HSSFWorkbook(pois);
- //获取Sheet(工作薄)总个数
- int sheetNumber = wb.getNumberOfSheets();
- for (int i = 0; i < sheetNumber; i++) {
- //获取Sheet(工作薄)
- HSSFSheet sheet = wb.getSheetAt(i);
- //开始行数
- int firstRow = sheet.getFirstRowNum();
- //结束行数
- int lastRow = sheet.getLastRowNum();
- //判断该Sheet(工作薄)是否为空
- boolean isEmpty = false;
- if(firstRow == lastRow){
- isEmpty = true;
- }
- if(!isEmpty){
- for (int j = firstRow; j <= lastRow; j++) {
- //获取一行
- HSSFRow row = sheet.getRow(j);
- //开始列数
- int firstCell = row.getFirstCellNum();
- //结束列数
- int lastCell = row.getLastCellNum();
- //判断该行是否为空
- if(firstCell != lastCell){
- for (int k = firstCell; k < lastCell; k++) {
- //获取一个单元格
- HSSFCell cell = row.getCell(k);
- Object value = null;
- // 类型说明
- // CELL_TYPE_NUMERIC 数值型 0
- // CELL_TYPE_STRING 字符串型 1
- // CELL_TYPE_FORMULA 公式型 2
- // CELL_TYPE_BLANK 空值 3
- // CELL_TYPE_BOOLEAN 布尔型 4
- // CELL_TYPE_ERROR 错误 5
- //获取单元格,值的类型
- int cellType = cell.getCellType();
- if(cellType == 0){
- value = cell.getNumericCellValue();
- System.out.print(value+" ");
- }else if(cellType == 1){
- value = cell.getStringCellValue();
- System.out.print(value+" ");
- }else if(cellType == 2){
- System.out.print(cell.getCellFormula());
- }else if(cellType == 4){
- value = cell.getBooleanCellValue();
- System.out.print(value+" ");
- }
- }
- }
- System.out.print("\\n");
- }
- }
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/1102201511766.html
来源: http://www.codesnippet.cn/detail/1102201511766.html