java怎么读取xlsx文件_java读取xlsx文件的所有数据

packagecom.test;importorg.apache.poi.hssf.usermodel.HSSFCell;importorg.apache.poi.hssf.usermodel.HSSFDataFormat;import org.apache.poi.ss.usermodel.*;importorg.apache.poi.xssf.usermodel.XSSFSheet;importorg.apache.poi.xssf.usermodel.XSSFWorkbook;importjava.io.File;importjava.io.FileInputStream;importjava.io.IOException;importjava.text.DecimalFormat;importjava.text.SimpleDateFormat;importjava.util.Date;/*** Created by wdnnccey on 17/2/27.

*

*

* 2017年02月27日21:27:26，

**/

public classTestXlsx2 {public static voidmain(String[] args) {

File excelFile= new File("/Users/wdnnccey/Desktop/test/test.xlsx"); //替换你文档地址

XSSFWorkbook wb= null;try{

wb= new XSSFWorkbook(newFileInputStream(excelFile));

}catch(IOException e) {

e.printStackTrace();

}int numberOfSheets =wb.getNumberOfSheets();

String str= &#