- 论坛徽章:
- 0
|
谢谢!!
-
- 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());
- }
- }
- }
复制代码 |
|