poi操作Excel表,读取Excel表是实现了,可是怎么根据读到的数据,在写入另一个Excel文件中啊!各位,帮我在测试类中写下后半部分,多谢了!!
//实体类
public class Demo {
private String name;
private String rd;
private String project;
private String workTime;
public Demo() {
}
public Demo(String name, String rd, String project, String workTime) {
this.name = name;
this.rd = rd;
this.project = project;
this.workTime = workTime;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getRd() {
return rd;
}
public void setRd(String rd) {
this.rd = rd;
}
public String getProject() {
return project;
}
public void setProject(String project) {
this.project = project;
}
public String getWorkTime() {
return workTime;
}
public void setWorkTime(String workTime) {
this.workTime = workTime;
}
@Override
public boolean equals(Object o) {
if (this == o) return true;
if (o == null || getClass() != o.getClass()) return false;
Demo demo = (Demo) o;
return Objects.equals(name, demo.name) &&
Objects.equals(rd, demo.rd) &&
Objects.equals(project, demo.project) &&
Objects.equals(workTime, demo.workTime);
}
@Override
public int hashCode() {
return Objects.hash(name, rd, project, workTime);
}
@Override
public String toString() {
return "Demo{" +
"name='" + name + '\'' +
", rd='" + rd + '\'' +
", project='" + project + '\'' +
", workTime='" + workTime + '\'' +
'}';
}
}
//测试类
@Test
public void test3() throws IOException {
List<Demo> demoList = new ArrayList<>();
//1.获取工作薄
XSSFWorkbook workbook = new XSSFWorkbook("D:\\工作数据统计.xlsx");
//2.获取工作表
XSSFSheet sheet = workbook.getSheetAt(0);
int lastRowNum = sheet.getLastRowNum();//最后一行索引
for (int i =0;i<=lastRowNum;i++) {
XSSFRow row = sheet.getRow(i);
short cellNum = row.getLastCellNum();//获取最后一行单元格的索引
List<String> list = new ArrayList<>();
for (int j = 0; j <= cellNum; j++) {
XSSFCell cell = row.getCell(j, Row.MissingCellPolicy.CREATE_NULL_AS_BLANK);
cell.setCellType(CellType.STRING);
String value = cell.getStringCellValue();
list.add(value);
}
Demo demo = new Demo(list.get(0), list.get(1), list.get(2), (list.get(3)));
demoList.add(demo);
}