POI解析excel多个sheet
来源:互联网 发布:怎么取消淘宝介入 编辑:程序博客网 时间:2024/05/17 04:06
package test;
import java.io.FileInputStream;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class Test {
public static void main(String[] args) throws Exception {
/*File file = new File(Test.class.getClassLoader().getResource("baidu.xlsx").getFile());
FileInputStream in = new FileInputStream(file);*/
FileInputStream in = new FileInputStream("tongji.xlsx");
XSSFWorkbook wb = new XSSFWorkbook(in);
for(int sheetIndex=0;sheetIndex<wb.getNumberOfSheets();sheetIndex++){
XSSFSheet sheet = wb.getSheetAt(sheetIndex);
System.out.println("//"+sheet.getSheetName()+"------------");
for(int rowNum=1;rowNum<=sheet.getLastRowNum();rowNum++){
XSSFRow row = sheet.getRow(rowNum);
XSSFCell cell1 = row.getCell(1);
XSSFCell cell = row.getCell(2);
if(cell == null){
continue;
}
String str1 = cell1.toString();
String str = cell.toString();
if(str.trim().isEmpty()){
continue;
}
//System.out.println("StatService.onEvent(mContext, \"SharedConst."+""+str.toUpperCase()+"\", \""+str+"\", 1)");
System.out.println(" StatServiceUtil.statService(mContext, AppConst."+""+str.toUpperCase()+", \""+str1+"\");");
// StatServiceUtil.statService(mContext, SharedConst.USER_CHECK_IN_CONTINUE_CNT_REFIX,"");
}
}
in.close();
}
}
import java.io.FileInputStream;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class Test {
public static void main(String[] args) throws Exception {
/*File file = new File(Test.class.getClassLoader().getResource("baidu.xlsx").getFile());
FileInputStream in = new FileInputStream(file);*/
FileInputStream in = new FileInputStream("tongji.xlsx");
XSSFWorkbook wb = new XSSFWorkbook(in);
for(int sheetIndex=0;sheetIndex<wb.getNumberOfSheets();sheetIndex++){
XSSFSheet sheet = wb.getSheetAt(sheetIndex);
System.out.println("//"+sheet.getSheetName()+"------------");
for(int rowNum=1;rowNum<=sheet.getLastRowNum();rowNum++){
XSSFRow row = sheet.getRow(rowNum);
XSSFCell cell1 = row.getCell(1);
XSSFCell cell = row.getCell(2);
if(cell == null){
continue;
}
String str1 = cell1.toString();
String str = cell.toString();
if(str.trim().isEmpty()){
continue;
}
//System.out.println("StatService.onEvent(mContext, \"SharedConst."+""+str.toUpperCase()+"\", \""+str+"\", 1)");
System.out.println(" StatServiceUtil.statService(mContext, AppConst."+""+str.toUpperCase()+", \""+str1+"\");");
// StatServiceUtil.statService(mContext, SharedConst.USER_CHECK_IN_CONTINUE_CNT_REFIX,"");
}
}
in.close();
}
}
阅读全文