我就直接上代码 就很少一部分的代码
代码如下:
package com.excel;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
/**
* 读取Excel
* @author 16314
*
*/
public class ReadMain {
public static List<AforbSupplyOff> readXls() throws IOException{
InputStream is=new FileInputStream(Common.EXCEL_PATH);
//创建一个excel文件
HSSFWorkbook hssfWorkbook = new HSSFWorkbook(is);
//循环工作表sheet
for(int numSheet=0;numSheet<hssfWorkbook.getNumberOfSheets();numSheet++){
HSSFSheet hssSheet=hssfWorkbook.getSheetAt(numSheet);
if(null==hssSheet){
continue;
}
//循环读取每行数据
for(int row=1;row<=hssSheet.getLastRowNum();row++){
HSSFRow hssRow=hssSheet.getRow(row);
if(null!=hssRow){
HSSFCell hssFCellOne = hssRow.getCell(0);
HSSFCell hssFCellTwo = hssRow.getCell(1);
String parentIds=getValue(hssFCellOne);
String goodsIds=getValue(hssFCellTwo);
}
}
}
return null;
}
/**
* 获取表格中的值
* @param hssFCell
* @return
*/
public static String getValue(HSSFCell hssFCell){
if(hssFCell.getCellType()==hssFCell.CELL_TYPE_BOOLEAN){
//返回布尔类型
return String.valueOf(hssFCell.getBooleanCellValue());
}else if(hssFCell.getCellType()==hssFCell.CELL_TYPE_NUMERIC){
//返回数值类型
return String.valueOf(hssFCell.getNumericCellValue());
}else{
//返回String类型
return String.valueOf(hssFCell.getStringCellValue());
}
}
}
就是这么简单