poi组件导入excel表格 疑问

Question

private void importExcel(String fileName) throws Exception {

        InputStream myxls = new FileInputStream(fileName);

        HSSFWorkbook book = new HSSFWorkbook(myxls);

        FormulaEvaluator eval = book.getCreationHelper().createFormulaEvaluator();

//

提示  The method getCreationHelper() is undefined for the type HSSFWorkbook

        HSSFSheet sheet = book.getSheetAt(0);

        if (importInputForm.isHeaderSelected()) {

            sheet.removeRow(sheet.getRow(0));

        }

        for (Row row : sheet) {        //

提示 sheet 那里出错Can only iterate over an array or an instance of java.lang.Iterable

            String[] line = new String[16];

            int i = 0;

            for (Cell cell : row) {

                line[i] = getCellContent(cell, eval);

                i++;

            }

            insertData(line);

        }

        myxls.close();

    }

求解答！！！！

Answer 1

汗，那里不应该是sheet.getRows()?