JAVA读取EXCEL

Question

用JAVA读取EXCEL格式的表格中的内容，然后写入到一个文本文件中。建议使用POI API。

Answer 1

EXCEL 中账号，密码，当密码的位数等于从键盘上读入的数时，将其写入到一个文本文件中。

Answer 2

/**
     * @param fileFullPath 文件路径           c:\\test.xml
     * @param sheetName    工作簿名称 例如Sheet1
     * @param rowFromNum   开始读取的行0表示第一行
     * @param cellFromNum  开始读取的列0表示第一列
     * @return
     */
    public List<List> readFromExcel(String fileFullPath, String sheetName, int rowFromNum, short cellFromNum) {
        List<List> lists = new ArrayList<List>();
        try {
            HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(fileFullPath));
            HSSFSheet sheet = workbook.getSheet(sheetName);
            int rows = sheet.getPhysicalNumberOfRows();
            for (int r = rowFromNum; r < rows; r++) {
                List list = new ArrayList();
                HSSFRow row = sheet.getRow(r);
                if (row != null) {
                    int cells = row.getPhysicalNumberOfCells();
                    //System.out.println(cells);
                    for (short c = cellFromNum; c < cells; c++) {
                        HSSFCell cell = row.getCell(c);
                        if (cell != null) {
                            switch (cell.getCellType()) {
                                case HSSFCell.CELL_TYPE_FORMULA:
                                    break;
                                case HSSFCell.CELL_TYPE_NUMERIC:
                                    list.add((long) cell.getNumericCellValue() + "");
                                    break;
                                case HSSFCell.CELL_TYPE_STRING:
                                    list.add(cell.getStringCellValue());
                                    break;
                                case HSSFCell.CELL_TYPE_BLANK://blank
                                    break;                            }
                        }
                    }
                    lists.add(list);
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return lists;
    }

Answer 3

可以参考一下 
http://download.csdn.net/user/lihan6415151528