java-poi处理excell

版本问题

如果提示:
classnotfoundexcepiont:org/apache/poi/ss.usermodel.Workbook

需要下载的包

dependencies {
        compile "org.apache.poi:poi:3.9"
        compile "org.apache.poi:poi-excelant:3.9"
        compile "org.apache.poi:poi-examples:3.9"
        compile "org.apache.poi:poi-ooxml:3.9"
        compile "org.apache.poi:poi-scratchpad:3.9"
        compile "org.apache.poi:poi-ooxml-schemas:3.9"
        compile "commons-io:commons-io:2.4"
        compile "net.sourceforge.jexcelapi:jxl:2.6.12"
        compile "dom4j:dom4j:1.6.1"
}

示例代码：

package web;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFHyperlink;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.util.CellRangeAddress;

import java.io.*;
import java.util.*;

public class ExcelUtil{
    public void fileInput() throws IOException {
        XSSFWorkbook hw = new XSSFWorkbook(new FileInputStream( "./poi.xls"));
        XSSFSheet hsheet = hw.getSheet("poi test");
        //行列
        XSSFRow hrow = hsheet.getRow(0);
        XSSFCell hcell = hrow.getCell(0);
        //单元格
        String cellValue = this.getCellValue(hcell);
        System.out.println(cellValue);

    }

    public static String getCellValue(XSSFCell cell) {
        String value = null;
        if (cell != null) {
            switch (cell.getCellType()) {
                //公式
                case XSSFCell.CELL_TYPE_FORMULA:
                    // cell.getCellFormula();
                    try {
                        value = String.valueOf(cell.getNumericCellValue());
                    } catch (IllegalStateException e) {
                        value = String.valueOf(cell.getRichStringCellValue());
                    }
                    break;
                    //数字
                case XSSFCell.CELL_TYPE_NUMERIC:
                    value = String.valueOf(cell.getNumericCellValue());
                    break;
                    //string
                case XSSFCell.CELL_TYPE_STRING:
                    value = String.valueOf(cell.getRichStringCellValue());
                    break;
                case XSSFCell.CELL_TYPE_BOOLEAN:
                    value = String.valueOf(cell.getBooleanCellValue());
                    break;
            }
        }

        return value;
    }
    public static void main(String[] args)throws Exception {
        //读取
        XSSFWorkbook workbook = new XSSFWorkbook(new FileInputStream("./a.xlsx")); 
        //创建
        //FileOutputStream out = new FileOutputStream( new File("createworkbook.xlsx"));
        //write operation workbook using file out object 
        // sheet,row,cell
        //HSSFSheet hsheet = workbook.getSheet("a");    
        XSSFSheet hsheet = workbook.getSheetAt(0);
        Iterator rows = hsheet.rowIterator();
        while(rows.hasNext()){
            XSSFRow hrow = (XSSFRow)rows.next();
            System.out.println("ROW:"+hrow.getRowNum());
            Iterator cells = hrow.cellIterator();
            while(cells.hasNext()){
                //HSSFCell hcell = hrow.getCell(0);
                XSSFCell hcell = (XSSFCell)cells.next();
                //System.out.println("cell:"+ hcell.getCellNum());
                String value = getCellValue(hcell);
                System.out.println(value);
            }
        }
        //workbook.write(out);
        //out.close();
        System.out.println(" createworkbook.xlsx written successfully");
    }
}