请问用jxl的导出excel 时设置对齐方式时如何设置顶端对齐

答案:2 悬赏:50 手机版

解决时间 2021-02-15 07:07

提问者网友：骨子里的高雅
2021-02-15 01:48

我查了API没有看到啊，只有左右和垂直居中

最佳答案

五星知识达人网友：野慌
2021-02-15 02:27

选中单元格右键-设置单元格格式-对齐-垂直对齐-靠上

全部回答

1楼网友：蓝房子
2021-02-15 02:32

//分页导出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

我要举报

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

点此我要举报以上问答信息

请问用jxl的导出excel 时设置对齐方式时 如何设置顶端对齐

请问用jxl的导出excel 时设置对齐方式时如何设置顶端对齐