解析excel03 and excel07 文件--poi

来源：互联网发布：java undefined 判断编辑：程序博客网时间：2024/05/17 23:37

import java.io.File;
import java.io.FileInputStream;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ParseExcel07 {

/**
* @param args
* @throws Exception
*/
public static void main(String[] args) {
  System.out.println("hello");
  String path = "C:/Users/pengpanting/Desktop/templateNew.xls";
//  String path = "C:/Users/pengpanting/Desktop/templateNew07.xlsx";
  File file = new File(path);
  FileInputStream fis = null;

  Workbook workbook = null;
  //excel2003
  try {
   fis = new FileInputStream(file);
   workbook = new HSSFWorkbook(fis);
  } catch(Exception e) {
   e.printStackTrace();
  }

  //excel2007
  if(workbook == null) {
   try {
    fis = new FileInputStream(file);
    workbook = new XSSFWorkbook(fis);
   } catch (Exception e) {
    e.printStackTrace();
   }
  }
  Sheet sheet = workbook.getSheetAt(0);
  System.out.println(sheet.getLastRowNum());




}

}