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]