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

.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());
}
}
}

package hzdracom.test;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;

import java.io.InputStream;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.List;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
/*
* 说明：本demo读取本地EXECL的前两列内容
* 需要下面两个架包
*1.poi-3.6-20091214.jar *
*
* @author ZhuangZi
* @version $Id: EXCEL.java,v 0.1 2013-4-3 下午03:30:39 ZhuangZi Exp $
*/
@SuppressWarnings( { "unchecked", })
public class EXCEL {
/***
*
* @author ZhuangZi
* @class hzdracom.test.EXCEL
* @method readExcelList
* @Directions 读execl文件的前两列
* @date 2013-4-2下午05:15:25
* @param file
* @param args
* @return
* @throws IOException List
*/
public static List readExcelList(File filepath ) throws IOException{
List list = new ArrayList();
Workbook rwb = null;

//创建输入流
InputStream stream = new FileInputStream(filepath);

try {
rwb = WorkbookFactory.create(stream);
} catch (InvalidFormatException e) {
e.printStackTrace();
}

Sheet sheet=null;
if (rwb!=null&&rwb.getSheetAt(0)!=null) {
sheet = rwb.getSheetAt(0);
}

//行数(表头的目录不需要，从1开始)
int rowCount = sheet.getLastRowNum();

for(int i=0; i<=rowCount; i++){
Row row = sheet.getRow(i);
if(row!=null){

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

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