java制作三线报表

采用的是开源的jxl组件进行开发。

具体的源代码如下：

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;

import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.VerticalAlignment;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
  
public class Demo {   
    public static void main(String[] args)throws IOException ,RowsExceededException, WriteException{   
    	String fileName = "exportExcel.xls";
        File file = new File(fileName);
        if(file.exists())
            file.delete();
        //创建一个excel文件
        jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File(fileName));
        //创建一个工作簿
        jxl.write.WritableSheet ws = wwb.createSheet("统计数据", 0);
        //定义excel的文本单元格
        jxl.write.Label label;      
        
        //=======================设置第一个单元格=========================
        //合并（0，0）和（0，1）单元格
        ws.mergeCells(0, 0, 0, 1);
        //字体为Arial格式，不是斜体
        WritableFont wf = new WritableFont(WritableFont.ARIAL, 10,WritableFont.NO_BOLD, false);
        //字体颜色为红色
        wf.setColour(jxl.format.Colour.BLAC