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

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

导读：在上一篇blog：中介绍了关于java中的poi技术读取excel的相关操作读取excel和MySQL相关：你也可以在： ? 了解到写入Excel的方法信息使用JXL技术： java的jxl技术导入Excel? 本文主要讲的是java中poi读和写excel（版本是2003-2007,2010） Processing...l

在上一篇blog：中介绍了关于java中的poi技术读取excel的相关操作

读取excel和MySQL相关：

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

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

本文主要讲的是java中poi读和写excel（版本是2003-2007,2010）

Processing...lib/201401,name : Hongten,age : 22.0,score : 98.0201402,name : Hanyuan,age : 21.0,score : 96.0201403,name : Tom,age : 20.0,score : 94.0201404,name : HanKet,score : 90.0201405,name : Jone,score : 42.0201406,name : Kite,age : 23.0,score : 59.0201407,name : Lucy,age : 25.0,score : 60.0201408,name : Mark,score : 89.0201409,name : Jeson,age : 24.0,score : 79.0201410,name : Steven,score : 59.0201411,name : Tide,score : 88.0201412,name : Deli,score : 89.0201413,name : Goerme,score : 98.0201414,name : Som,score : 95.0 ======================================/201401,score : 95.0 ======================================/student_info_2003-2007/======================================/student_info_2003-2007201401,score : 95.0 ======================================/201401,score : 95.0

main(String[] args) String read_excel2003_2007_path = String read_excel2010_path = 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 : " + System.out.println("======================================" String write_excel2003_2007_path = String write_excel2010_path = System.out.println("======================================" List list2 = (list != System.out.println("No. : " + student.getNo() + ",score : " + System.out.println("======================================" List list3 = (list1 != System.out.println("No. : " + student.getNo() + ",score : " + }

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 STUDENT_INFO_XLS_OUT_PATH = "lib/student_info_2003-2007.xls" String STUDENT_INFO_XLSX_OUT_PATH = "lib/student_info_2010.xlsx" String NOT_EXCEL_FILE = " : Not the Excel file!" String PROCESSING = "Processing..." String WRITE_DATA = "write data to file : " }

writeExcel(List list,String path) (list == } (path == || } String postfix = (! } } System.out.println(path + 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

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

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

========================================================