我是使用的poi3.11,但导入二维数组时for循环遍历只能是数组或者list对象。不知道怎么写了。代码如下publicstaticString[][]readWorkbookToArray(Stringpath)throwsIOException{Input...
我是使用的poi3.11,但导入二维数组时for循环遍历只能是数组或者list对象。不知道怎么写了。代码如下public static String[][] readWorkbookToArray(String path) throws IOException {InputStream inp = null;Workbook workbook = null;String[][] sheetArray=null;try {inp = new FileInputStream(path);workbook = WorkbookFactory.create(inp);FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();Sheet sheet1=workbook.getSheetAt(0);//int lastNum=sheet1.getLastRowNum();int coloumNum=sheet1.getRow(0).getPhysicalNumberOfCells();int rowNumt=sheet1.getLastRowNum();//获得总行数//Row row2=sheet1.getRow(1);System.out.println(coloumNum+"**************"+rowNumt);sheetArray=new String[rowNumt][coloumNum];for (Sheet sheet : workbook) {//String[][] sheetArray=newfor (int i=0;i
就是这个遍历数组workbook问题,如何改一个方式写。意思,效果不变就行了- -
展开