JXL API使用

OutputStream os = new FileOutputStream(new File("c:/test.xls"));
//创建小字体：Arial,大小为8号,非粗体，非斜体
WritableFont wf = new WritableFont(WritableFont.ARIAL, 8,WritableFont.NO_BOLD, false);
//创建单元格格式：设置水平对齐为居中对齐
jxl.write.WritableCellFormat CwcfF = new jxl.write.WritableCellFormat(wf);
//水平对齐
CwcfF.setAlignment(jxl.format.Alignment.CENTER);
//垂直对齐
CwcfF.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);
//创建工作簿对象
WritableWorkbook book = Workbook.createWorkbook(os);
//创建工作表对象
WritableSheet sheet=book.createSheet("退款证明", 0);

CellView middleView =new CellView();
middleView.setSize(17*256);
CellView shortView =new CellView();
shortView.setSize(15*256);

//设置列大小
sheet.setColumnView(0, shortView);
sheet.setColumnView(1, middleView);
sheet.setColumnView(2, middleView);
sheet.setColumnView(3, middleView);
int rowNum=0;//第一行
int j=0;//第一列
sheet.addCell(new Label(j++, rowNum, "第一列", CwcfF));
sheet.addCell(new Label(j++, rowNum, "第二列", CwcfF));
sheet.addCell(new Label(j++, rowNum, "第三列", CwcfF));

//设置行高度
sheet.setRowView(rowNum, 1000);
//合并第rowNun行，从0列到1列
sheet.mergeCells(0, rowNum, 1, rowNum);
rowNum=rowNum+1;//第二行
sheet.addCell(new Label(j++, rowNum, "第一列", CwcfF));
sheet.addCell(new Label(j++, rowNum, "第二列", CwcfF));
sheet.addCell(new Label(j++, rowNum, "第三列", CwcfF));

//将工作簿写入输出流
book.write();
//关闭工作簿
book.close();
//关闭输出流
os.close();
 

评论

1 楼 jasoncool 2010-08-17  

好！