WorkbookSettings setting = new WorkbookSettings();
WritableWorkbook workbook = Workbook.createWorkbook(new File( "C:/ABC.XLS"), setting);
WritableSheet ws = workbook.createSheet("Trending Report", 0);
//styles
WritableCellFormat titleStyle = new WritableCellFormat(new WritableFont(WritableFont.ARIAL, 12, WritableFont.BOLD));
WritableCellFormat propertyStyle = new WritableCellFormat(new WritableFont(WritableFont.ARIAL, 10, WritableFont.BOLD));
//write title
Label l1 = new Label(1, 0, r.getTitle(),titleStyle);
ws.addCell(l1);
//write properties
Label l2 = new Label(1, 2, "Target:",propertyStyle);
ws.addCell(l2);
Label v2 = new Label(3, 2, r.getTargetName());
ws.addCell(v2);
Label l3 = new Label(1, 3, "Data Item:",propertyStyle);
ws.addCell(l3);
Label v3 = new Label(3, 3, r.getDataItemName());
ws.addCell(v3);
Label l4 = new Label(1, 4, "Unit:",propertyStyle);
ws.addCell(l4);
Label v4 = new Label(3, 4, r.getUnitName());
ws.addCell(v4);
//write image
WritableImage wi = new WritableImage(0, 8, 8, 14, new File(r.getImgPath()));
ws.addImage(wi);
//write values
Label titleT = new Label(1, 26, "Time",propertyStyle);ws.addCell(titleT);
Label titleV = new Label(4, 26, "Value",propertyStyle);ws.addCell(titleV);
Series tmp;
for(int i=0,l=r.getSeries().size();i<l;i++){
tmp=r.getSeries().get(i);
Label t = new Label(1, 27+i, tmp.getTime()); ws.addCell(t);
Label v = new Label(4, 27+i, tmp.getValue()); ws.addCell(v);
}
workbook.write();
workbook.close();
JXL : write images and... into excel
最新推荐文章于 2024-10-17 11:42:02 发布