Excel 旧数据末尾写入新数据,不覆盖
WritableWorkbookwwb;
Stringpath....//存储路径
StringsheetName....//工作表名称
intoldRows....//文件中已存在记录条数sheet.getRows()
try{
FileresultFile=newFile(path);
if(!resultFile.isFile()){//不存在则创建文件
wwb=Workbook.createWorkbook(resultFile);
}else{//已存在则取出文件
Workbookrwb=Workbook.getWorkbook(resultFile);
wwb=Workbook.createWorkbook(resultFile,rwb);
}
WritableSheetsheet=wwb.getSheet(sheetName);//取出工作表
if(sheet==null){//如不存在,创建新的工作表
sheet=wwb.createSheet(sheetName,wwb.getNumberOfSheets());
}
for(循环行i){
for(循环列j){
label=newLabel(j,oldRows+i,数据,格式)
sheet.addCell(label);//添加数据
}
}
wwb.write();
wwb.close();
相关推荐
yangkang 2020-11-09
lbyd0 2020-11-17
sushuanglei 2020-11-12
85477104 2020-11-17
KANSYOUKYOU 2020-11-16
wushengyong 2020-10-28
lizhengjava 2020-11-13
星月情缘 2020-11-13
huangxiaoyun00 2020-11-13
luyong0 2020-11-08
腾讯soso团队 2020-11-06
Apsaravod 2020-11-05
PeterChangyb 2020-11-05
gaobudong 2020-11-04
wwwjun 2020-11-02
gyunwh 2020-11-02
EchoYY 2020-10-31
dingyahui 2020-10-30