版本问题
如果提示:
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");
}
}