java的poi技术读取Excel[2003-2007,2010]

发布时间：2020-12-14 06:30:43 所属栏目：Java 来源：网络整理

导读：这篇blog主要是讲述java中poi读取excel，而excel的版本包括：2003-2007和2010两个版本，即excel的后缀名为：xls和xlsx。读取excel和MySQL相关：? 你也可以在： ? 了解到写入Excel的方法信息使用JXL技术： java的jxl技术导入Excel? 2003-2007,2010都是一

这篇blog主要是讲述java中poi读取excel，而excel的版本包括：2003-2007和2010两个版本，即excel的后缀名为：xls和xlsx。

读取excel和MySQL相关：?

你也可以在：?了解到写入Excel的方法信息

使用JXL技术：java的jxl技术导入Excel?

2003-2007,2010都是一样的数据）

String OFFICE_EXCEL_2003_POSTFIX = "xls" String OFFICE_EXCEL_2010_POSTFIX = "xlsx" String EMPTY = "" String POINT = "." String LIB_PATH = "lib" String STUDENT_INFO_XLS_PATH = LIB_PATH + "/student_info" + POINT + String STUDENT_INFO_XLSX_PATH = LIB_PATH + "/student_info" + POINT + String NOT_EXCEL_FILE = " : Not the Excel file!" String PROCESSING = "Processing..." }

List readExcel(String path) (path == || } String postfix = (! } } System.out.println(path + List readXlsx(String path) System.out.println(Common.PROCESSING + InputStream is = XSSFWorkbook xssfWorkbook = Student student = List list = ArrayList ( numSheet = 0; numSheet < xssfWorkbook.getNumberOfSheets(); numSheet++ XSSFSheet xssfSheet = (xssfSheet == ( rowNum = 1; rowNum <= xssfSheet.getLastRowNum(); rowNum++ XSSFRow xssfRow = (xssfRow != student = XSSFCell no = xssfRow.getCell(0 XSSFCell name = xssfRow.getCell(1 XSSFCell age = xssfRow.getCell(2 XSSFCell score = xssfRow.getCell(3 List readXls(String path) System.out.println(Common.PROCESSING + InputStream is = HSSFWorkbook hssfWorkbook = Student student = List list = ArrayList ( numSheet = 0; numSheet < hssfWorkbook.getNumberOfSheets(); numSheet++ HSSFSheet hssfSheet = (hssfSheet == ( rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++ HSSFRow hssfRow = (hssfRow != student = HSSFCell no = hssfRow.getCell(0 HSSFCell name = hssfRow.getCell(1 HSSFCell age = hssfRow.getCell(2 HSSFCell score = hssfRow.getCell(3 @SuppressWarnings("static-access" (xssfRow.getCellType() == } (xssfRow.getCellType() == } @SuppressWarnings("static-access" (hssfCell.getCellType() == } (hssfCell.getCellType() ==

main(String[] args) String excel2003_2007 = String excel2010 = List list = (list != System.out.println("No. : " + student.getNo() + ",name : " + student.getName() + ",age : " + student.getAge() + ",score : " + System.out.println("======================================" List list1 = (list1 != System.out.println("No. : " + student.getNo() + ",score : " + }

(path == || path.substring(path.lastIndexOf(Common.POINT) + 1 }

.id = .no = .name = .age = setScore( .score = }