javapoi处理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"
}

示例代码&＃xff1a;

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 &＃61; new XSSFWorkbook(new FileInputStream( "./poi.xls"));XSSFSheet hsheet &＃61; hw.getSheet("poi test");//行列XSSFRow hrow &＃61; hsheet.getRow(0);XSSFCell hcell &＃61; hrow.getCell(0);//单元格String cellValue &＃61; this.getCellValue(hcell);System.out.println(cellValue);}public static String getCellValue(XSSFCell cell) {String value &＃61; null;if (cell !&＃61; null) {switch (cell.getCellType()) {//公式case XSSFCell.CELL_TYPE_FORMULA:// cell.getCellFormula();try {value &＃61; String.valueOf(cell.getNumericCellValue());} catch (IllegalStateException e) {value &＃61; String.valueOf(cell.getRichStringCellValue());}break;//数字case XSSFCell.CELL_TYPE_NUMERIC:value &＃61; String.valueOf(cell.getNumericCellValue());break;//stringcase XSSFCell.CELL_TYPE_STRING:value &＃61; String.valueOf(cell.getRichStringCellValue());break;case XSSFCell.CELL_TYPE_BOOLEAN:value &＃61; String.valueOf(cell.getBooleanCellValue());break;}}return value;}public static void main(String[] args)throws Exception {//读取XSSFWorkbook workbook &＃61; new XSSFWorkbook(new FileInputStream("./a.xlsx")); //创建//FileOutputStream out &＃61; new FileOutputStream( new File("createworkbook.xlsx"));//write operation workbook using file out object // sheet,row,cell//HSSFSheet hsheet &＃61; workbook.getSheet("a"); XSSFSheet hsheet &＃61; workbook.getSheetAt(0);Iterator rows &＃61; hsheet.rowIterator();while(rows.hasNext()){XSSFRow hrow &＃61; (XSSFRow)rows.next();System.out.println("ROW:"&＃43;hrow.getRowNum());Iterator cells &＃61; hrow.cellIterator();while(cells.hasNext()){//HSSFCell hcell &＃61; hrow.getCell(0);XSSFCell hcell &＃61; (XSSFCell)cells.next();//System.out.println("cell:"&＃43; hcell.getCellNum());String value &＃61; getCellValue(hcell);System.out.println(value);}}//workbook.write(out);//out.close();System.out.println(" createworkbook.xlsx written successfully");}
}