81,094
社区成员
发帖
与我相关
我的任务
分享
package com.excel;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
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;
public class ReadExcel {
private static String path="D:/excel.xls";
public static void main(String[] args) throws Exception {
List<String> strUser=new ArrayList<String>();
File file=new File(path);
FileInputStream fs=new FileInputStream(file);
HSSFWorkbook wb=new HSSFWorkbook(fs);
HSSFSheet sheet=wb.getSheet("新生记录");
int lastRow=sheet.getLastRowNum();
StringBuffer values=null;
for(int i=1;i<lastRow+1;i++){
HSSFRow row=sheet.getRow(i);
short cellNum=row.getLastCellNum();
values=new StringBuffer();
for(int j=0;j<cellNum;j++){
HSSFCell cell=row.getCell(j);
if(j==0||j==2){
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
}
System.out.println(cell.getStringCellValue());
values.append(cell.getStringCellValue()+",");
}
values.delete(values.length()-1, values.length());
strUser.add(values.toString());
}
for(int i=0;i<strUser.size();i++){
String[] user=strUser.get(i).split(",");
System.out.println(new User(Integer.valueOf(user[0]),user[1],Integer.valueOf(user[2])));
}
}
}
package excel;
import java.io.File;
import java.io.FileInputStream;
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;
public class ReadExcel {
private static String path="F:\\stu.xls";
public static void main(String[] args) throws Exception {
List<String> strUser=new ArrayList<String>();
File file=new File(path);
FileInputStream fs=new FileInputStream(file);
HSSFWorkbook wb=new HSSFWorkbook(fs);
HSSFSheet sheet=wb.getSheet("新生记录");
int lastRow=sheet.getLastRowNum();
StringBuffer values=null;
for(int i=1;i<lastRow+1;i++){
HSSFRow row=sheet.getRow(i);
short cellNum=row.getLastCellNum();
values=new StringBuffer();
for(int j=0;j<cellNum;j++){
HSSFCell cell=row.getCell((short) j);
if(j==0||j==2){
//cell.setCellType(HSSFCell.CELL_TYPE_STRING);
}
if(cell.getCellType()==HSSFCell.CELL_TYPE_STRING){
values.append(cell.getStringCellValue()+",");
}
else if(cell.getCellType()==HSSFCell.CELL_TYPE_NUMERIC){
values.append(cell.getNumericCellValue()+",");
}
else{
//todo
}
}
values.delete(values.length()-1, values.length());
strUser.add(values.toString());
}
System.out.println(strUser);
/*for(int i=0;i<strUser.size();i++){
String[] user=strUser.get(i).split(",");
System.out.println(new User(Integer.valueOf(user[0]),user[1],Integer.valueOf(user[2])));
}*/
}
}
for(int i=1;i<lastRow+1;i++){
已经去掉了第一行,就是从第二行开始读的,是对的