java jxl合并单元格,jxl 合并单元格 - JavaLoveNet的个人空间 - OSCHINA - 中文开源技术交流社区...

WritableSheet sheet.mergeCells(int a,int b,int c,int d);

a:最左上的列，b最左上的行，c最右下的列，d最右下的行

import java.io.*;

import jxl.*;

import jxl.write.*;

import jxl.format.*;

import java.util.*;

public class Test

{

public static void writeExcel(OutputStream os )throws Exception

{

try

{

jxl.write.WritableWorkbook wwb=Workbook.createWorkbook(os);

//                jxl.write.WritableSheet ws = wwb.createSheet("TestSheet1", 0);

jxl.write.WritableSheet ws =wwb.createSheet("testsheet1",0);

jxl.write.Label labelC =new jxl.write.Label(0,0,"我爱中国");

ws.addCell(labelC);

labelC =new jxl.write.Label(1,2,"我爱中国1,2");

ws.addCell(labelC);

jxl.write.WritableFont wfc =new jxl.write.WritableFont(WritableFont.ARIAL,20,

WritableFont.BOLD,false,

UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.GREEN);

jxl.write.WritableCellFormat wcfFc =new jxl.write.WritableCellFormat(wfc);

labelC =new jxl.write.Label(6,0,"中国我爱",wcfFc);

ws.addCell(labelC);

WritableFont wf_merge = new WritableFont(WritableFont.ARIAL,10,WritableFont.NO_BOLD,

false,UnderlineStyle.DOUBLE_ACCOUNTING,jxl.format.Colour.GREEN);

WritableCellFormat wff_merge = new WritableCellFormat(wf_merge);

// wff_merge.setBackground(jxl.format.Colour.BLACK);

jxl.write.Label label30 = new Label(3,0,"Label30",wff_merge);

ws.addCell(label30);

//合并单元格

ws.mergeCells(3,0,4,0);

wwb.write();

wwb.close();

}

catch (Exception e )

{

throw e;

}

}

public static void main(String[] args)

{

try

{

System.out.println("Hello World!");

File f=new File("a.xls");

writeExcel(new FileOutputStream(f));

}

catch (Exception e)

{

System.out.println(e.getMessage());

}

}