jxl怎么导出excel设置顶端对齐verticalalignment

答案:2 悬赏:10

解决时间 2021-02-02 11:53

提问者网友：纹身骑士
2021-02-01 13:08

最佳答案

二级知识专家网友：花一样艳美的陌生人
2021-02-01 14:09

//分页导出Excel ---song public void WriteExecel_Old(ResultSet rs, String filename,String tilte,String[] colunames,String[] columns) { try { int columncount = columns.length; String sfilename ="c:\\output.xls"; if (filename!=null) { if (!filename.equals("")) { sfilename = filename; } } WritableWorkbook workbook = Workbook.createWorkbook(new File(sfilename)); WritableSheet sheet = workbook.createSheet(tilte, 0); WritableSheet sheet2 = workbook.createSheet("sheet2", 1); WritableSheet sheet3 = workbook.createSheet("sheet3", 2); WritableSheet sheet4 = workbook.createSheet("sheet4", 3); sheet.mergeCells(0,0,columncount-1,0);//合并单元格 sheet2.mergeCells(0,0,columncount-1,0);//合并单元格 sheet3.mergeCells(0,0,columncount-1,0);//合并单元格 sheet4.mergeCells(0,0,columncount-1,0);//合并单元格 WritableFont times16font = new WritableFont(WritableFont.TIMES, 16, WritableFont.BOLD, true); WritableCellFormat times16format = new WritableCellFormat (times16font); times16format.setAlignment(jxl.format.Alignment.CENTRE);// //把水平对齐方式指定为居中 times16format.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE); //把垂直对齐方式指定为居中 //标题头 Label label = new Label(0, 0, tilte,times16format); Label label2 = new Label(0, 0, tilte,times16format); Label label3 = new Label(0, 0, tilte,times16format); Label label4 = new Label(0, 0, tilte,times16format); sheet.setRowView(0, 800); sheet.addCell(label); sheet2.setRowView(0, 800); sheet2.addCell(label2); sheet3.setRowView(0, 800); sheet3.addCell(label3); sheet4.setRowView(0, 800); sheet4.addCell(label4); int row = 1; WritableCellFormat titielformat = new WritableCellFormat(); titielformat.setBackground(jxl.format.Colour.GREY_25_PERCENT); titielformat.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN); //写表头 for (int i=0;i<columncount;i++) { Label labeltmp = new Label(i,row,colunames[i],titielformat); Label labeltmp2 = new Label(i,row,colunames[i],titielformat); Label labeltmp3 = new Label(i,row,colunames[i],titielformat); Label labeltmp4 = new Label(i,row,colunames[i],titielformat); sheet.addCell(labeltmp); sheet2.addCell(labeltmp2); sheet3.addCell(labeltmp3); sheet4.addCell(labeltmp4); //Number number = new Number(5, 6, 3.1459); //sheet.addCell(number); } row = 2; int myRow1 = 1; int myRow2 = 1; int myRow3 = 1; if (rs!=null) { WritableCellFormat tformat = new WritableCellFormat(); tformat.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN); rs.beforeFirst(); // System.out.println("---------------"); while (rs.next()) { if(row<=60000){ for (int i=0;i<columncount;i++) { Label labeltmp = new Label(i,row,rs.getString(i+1),tformat); sheet.addCell(labeltmp); } } else if(row>60000 && row <=120000) { for (int i=0;i<columncount;i++) { Label labeltmp = new Label(i, myRow1, rs.getString(i+1), tformat); sheet2.addCell(labeltmp); } myRow1++; } else if(row>120000 && row <=180000) { for (int i=0;i<columncount;i++) { Label labeltmp = new Label(i, myRow2, rs.getString(i+1), tformat); sheet3.addCell(labeltmp); } myRow2++; } else { for (int i=0;i<columncount;i++) { Label labeltmp = new Label(i, myRow3, rs.getString(i+1), tformat); sheet4.addCell(labeltmp); } myRow3++; } row = row +1; } } workbook.write(); workbook.close(); } catch (Exception ex) { System.out.println(ex.toString()); } }

全部回答

1楼网友：随心随缘不随便
2021-02-01 15:05

//分页导出excel ---song public void writeexecel_old(resultset rs, string filename,string tilte,string[] colunames,string[] columns) { try { int columncount = columns.length; string sfilename ="c:\\output.xls"; if (filename!=null) { if (!filename.equals("")) { sfilename = filename; } } writableworkbook workbook = workbook.createworkbook(new file(sfilename)); writablesheet sheet = workbook.createsheet(tilte, 0); writablesheet sheet2 = workbook.createsheet("sheet2", 1); writablesheet sheet3 = workbook.createsheet("sheet3", 2); writablesheet sheet4 = workbook.createsheet("sheet4", 3); sheet.mergecells(0,0,columncount-1,0);//合并单元格 sheet2.mergecells(0,0,columncount-1,0);//合并单元格 ...//分页导出excel ---song public void writeexecel_old(resultset rs, string filename,string tilte,string[] colunames,string[] columns) { try { int columncount = columns.length; string sfilename ="c:\\output.xls"; if (filename!=null) { if (!filename.equals("")) { sfilename = filename; } } writableworkbook workbook = workbook.createworkbook(new file(sfilename)); writablesheet sheet = workbook.createsheet(tilte, 0); writablesheet sheet2 = workbook.createsheet("sheet2", 1); writablesheet sheet3 = workbook.createsheet("sheet3", 2); writablesheet sheet4 = workbook.createsheet("sheet4", 3); sheet.mergecells(0,0,columncount-1,0);//合并单元格 sheet2.mergecells(0,0,columncount-1,0);//合并单元格 sheet3.mergecells(0,0,columncount-1,0);//合并单元格 sheet4.mergecells(0,0,columncount-1,0);//合并单元格 writablefont times16font = new writablefont(writablefont.times, 16, writablefont.bold, true); writablecellformat times16format = new writablecellformat (times16font); times16format.setalignment(jxl.format.alignment.centre);// //把水平对齐方式指定为居中 times16format.setverticalalignment(jxl.format.verticalalignment.centre); //把垂直对齐方式指定为居中 //标题头 label label = new label(0, 0, tilte,times16format); label label2 = new label(0, 0, tilte,times16format); label label3 = new label(0, 0, tilte,times16format); label label4 = new label(0, 0, tilte,times16format); sheet.setrowview(0, 800); sheet.addcell(label); sheet2.setrowview(0, 800); sheet2.addcell(label2); sheet3.setrowview(0, 800); sheet3.addcell(label3); sheet4.setrowview(0, 800); sheet4.addcell(label4); int row = 1; writablecellformat titielformat = new writablecellformat(); titielformat.setbackground(jxl.format.colour.grey_25_percent); titielformat.setborder(jxl.format.border.all, jxl.format.borderlinestyle.thin); //写表头 for (int i=0;i60000 && row <=120000) { for (int i=0;i120000 && row <=180000) { for (int i=0;i

我要举报

如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！