wsheet.addCell(new Label(3, 3, "DWDM",wcfFC));
wsheet.addCell(new Label(4, 3, "MSTP",wcfFC));
wsheet.addCell(new Label(5, 3, "SDH",wcfFC));
wsheet.addCell(new Label(6, 3, "以太网",wcfFC));
wsheet.addCell(new Label(12, 3, "光中继站",wcfFC));
wsheet.addCell(new Label(13, 3, "电中继站",wcfFC));
wsheet.addCell(new Label(17, 3, "最长",wcfFC));
wsheet.addCell(new Label(18, 3, "最短",wcfFC));
wsheet.addCell(new Label(19, 3, "最长",wcfFC));
wsheet.addCell(new Label(20, 3, "最短",wcfFC));
if(sgwlList.size()>0){ ////判断集合是否不为 0
Object[] sgwlObj=null;
for(int i=0;i<sgwlList.size();i++){
sgwlObj=(Object[])sgwlList.get(i);
wsheet.addCell(new Label(0, i+4, i+1+""));
for(int j=0;j<21;j++)
{
if(sgwlObj[j]==null) sgwlObj[j]="";
wsheet.addCell(new Label(j+1, i+4,
sgwlObj[j].toString()));
}
}
}
//
主体内容生成结束
wbook.write(); //
写入文件
wbook.close();
os.close(); // 关闭流
}
catch(Exception ex)
{
ex.printStackTrace();
}