Workbook wb = Workbook.getWorkbook(new File(strFileName));
ByteArrayOutputStream targetFile = new ByteArrayOutputStream();
WritableWorkbook wwb = Workbook.createWorkbook(targetFile, wb);
WritableSheet wws = wwb.getSheet(0);
for (int r=3;r <=26;r++)
{
for (int c=4;c <=7;c++)
{
WritableCell wc1 = wws.getWritableCell(c,r);
Label sex = (Label)wc1;
sex.setString( "a ");
}
}
到Label sex = (Label)wc1; 报错,因为模板这个单元格是空的,把这个单元格填上数据就没错了,想知道,单元格为空的时候怎么写
ByteArrayOutputStream targetFile = new ByteArrayOutputStream();
WritableWorkbook wwb = Workbook.createWorkbook(targetFile, wb);
WritableSheet wws = wwb.getSheet(0);
for (int r=3;r <=26;r++)
{
for (int c=4;c <=7;c++)
{
WritableCell wc1 = wws.getWritableCell(c,r);
Label sex = (Label)wc1;
sex.setString( "a ");
}
}
到Label sex = (Label)wc1; 报错,因为模板这个单元格是空的,把这个单元格填上数据就没错了,想知道,单元格为空的时候怎么写
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货