jxl 合并单元格

最新推荐文章于 2023-06-15 23:23:04 发布

chijiao0691

最新推荐文章于 2023-06-15 23:23:04 发布

阅读量181

点赞数

文章标签： java

原文链接：https://my.oschina.net/u/571427/blog/61383

版权

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());
                }
        }