java poi 读取excel内容
import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import java.io.File; import java.io.FileInputStream; import java.io.InputStream; public class MainTest { public static void main(String[] args) { String filePath="D:/home/读取测试.xls"; try { readExcel(filePath); } catch (Exception e) { e.printStackTrace(); } } /** * 读取excel内容 * @param filePath 文件路径 * @throws Exception */ public static void readExcel(String filePath) throws Exception{ InputStream is = new FileInputStream(new File(filePath)); Workbook hssfWorkbook = null; if (filePath.endsWith("xlsx")){ //Excel 2007 hssfWorkbook = new XSSFWorkbook(is); }else if (filePath.endsWith("xls")){ //Excel 2003 hssfWorkbook = new HSSFWorkbook(is); } // 循环工作表Sheet for (int numSheet = 0; numSheet <hssfWorkbook.getNumberOfSheets(); numSheet++) { Sheet hssfSheet = hssfWorkbook.getSheetAt(numSheet); if (hssfSheet == null) { continue; } // 循环行Row for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) { Row hssfRow = hssfSheet.getRow(rowNum); if (hssfRow != null) { //第一列内容 System.out.println(hssfRow.getCell(0)); //第一列内容 System.out.println(hssfRow.getCell(1)); } } } } }