package com.wondersgroup;
import java.io.FileInputStream;
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 user
*
*/
public class ReadExcel {
static String path=”G:\***\***\**(20160218).xls”;
/**
* 读取excel中的数据
* @param path
*/
public void readexcel(String path) {
try {
InputStream in=new FileInputStream(path);
HSSFWorkbook hb=new HSSFWorkbook(in);//创建excel表格的对象
//获取excel中的第一个工作表
HSSFSheet hs=hb.getSheetAt(0);
//循环读取excel表中的行
List<Pojo> list=new ArrayList<Pojo>();
for(int row=1;row<=hs.getLastRowNum();row++){
HSSFRow hr=hs.getRow(row);
if(hr==null){
continue;
}
//获取excel的列的值
HSSFCell hCell1=hr.getCell(0);
HSSFCell hCell2=hr.getCell(1);
Pojo p=new Pojo();
p.setName(hCell1.toString());
p.setValue(hCell2.toString());
list.add(p);
}
for(Pojo p: list){
System.out.println(p.getName()+"-----"+p.getValue());
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
*
* @param path
*/
public void WriteExcel(String path) {
}
public static void main(String[] args) {
new ReadExcel().readexcel(path);
}
}