java 读取EXECL信息经典入门 - JAVA

Cell cell = row.getCell(0);
Cell cell2= row.getCell(1);
String c = cell.toString();
String c2 = cell2.toString();
if(isNotEmpty(c)&&isNotEmpty(c2)){
//读取单元格的数据
DecimalFormat df = new DecimalFormat("##");
switch (cell.getCellType()) {
case Cell.CELL_TYPE_STRING:
list.add(String.valueOf(cell.getRichStringCellValue()));
break;
case Cell.CELL_TYPE_NUMERIC:
list.add(df.format(cell.getNumericCellValue()));
break;
default:
break;
}
switch (cell2.getCellType()) {
case Cell.CELL_TYPE_STRING:
list.add(String.valueOf(cell2.getRichStringCellValue()));
break;
case Cell.CELL_TYPE_NUMERIC:
list.add(df.format(cell2.getNumericCellValue()));
break;
default:
break;
}
}
}
}

return list;
}
/**
*
* @author ZhuangZi
* @class hzdracom.test.EXCEL
* @method EXECLINFO
* @Directions 封装取到execl信息
* @date 2013-4-2下午05:29:27
* @return List
*/
public static List EXECLINFO( String path) {

List list = new ArrayList();
File file = new File(path);
ExeclBean bean = new ExeclBean();
List listbean = new ArrayList();
try {
list = readExcelList(file );
int j = 0;
for (int i = 0; i < list.size(); i++) {
if (j == 0) {
bean=new ExeclBean();
bean.setPhone(list.get(i).toString());
j++;
} else {
j = 0;
bean.setNum(list.get(i).toString());
listbean.add(bean);
}
}
} catch (IOException e1) {
}
return listbean;
}

public static boolean isNotEmpty(String string) {
return string != null && !string.equals("null")&& string.trim().length() > 0;
}
public static void main(String[] args) {
List listbean = EXECLINFO("C://3.xls");
for (int i = 0; i < listbean.size(); i++) {
System.out.println(listbean.get(i).getPhone()+"****"+listbean.get(i).getNum());
}
}
}
2.封装EXECL前两列的信息类

[java]
package hzdracom.test;
/*
* 封装EXECL前两列的信息
* @author ZhuangZi
* @version $Id: ExeclBean.java,v 0.1 2013-4-3 下午03:31:15 ZhuangZi Exp $
*/
public class ExeclBean {
private String phone;//假如第一列是手机号码
private String num;//第二例为通话次数
public String g

java 读取EXECL信息 经典入门 (四)

java 读取EXECL信息经典入门 (四)