java读取excel文件的两种方法

本文实例为大家分享了java读取excel文件的具体代码，供大家参考，具体内容如下

方式一：

借用

package com.ij34.util;

import java.io.File; 
import java.io.IOException; 
import jxl.Cell; 
import jxl.Sheet; 
import jxl.Workbook; 
import jxl.read.biff.BiffException; 
 
public class Test05 { 
public static void main(String args[]){ 
 File f=new File("table01.xls"); 
 try { 
 Workbook book=Workbook.getWorkbook(f);// 
 Sheet sheet=book.getSheet(0); //获得第一个工作表对象 
 for(int i=0;i


 方式二：

package com.ij34.util;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.ss.usermodel.Row;


public class Test02 {
 public static void main(String[] args) throws FileNotFoundException, IOException {
 File excelFile = new File("table01.xls");
 HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(excelFile));
 HSSFSheet sheet = wb.getSheetAt(0);
 
 for (Row row : sheet) {
  for (Cell cell : row) {
  switch (cell.getCellType()) {
  case Cell.CELL_TYPE_STRING://字符串
   System.out.print(cell.getRichStringCellValue().getString());
   System.out.print(" ");
   break;
  case Cell.CELL_TYPE_NUMERIC://数值与日期
   if (DateUtil.isCellDateFormatted(cell)) {
   System.out.print(String.valueOf(cell.getDateCellValue()));
   } else {
   System.out.print(cell.getNumericCellValue());
   }
   System.out.print(" ");
   break;
  case Cell.CELL_TYPE_BOOLEAN://boolean类型
   System.out.print(cell.getBooleanCellValue());
   System.out.print(" ");
   break;
  default:
  }
  }
  System.out.println();
 }
}
}



附jar包

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持考高分网。