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.BLACK);
        //创建单元格格式：
        jxl.write.WritableCellFormat RwcfF = new jxl.write.WritableCellFormat(wf);
        //设置水平对齐为居中对齐
        RwcfF.setAlignment(Alignment.CENTRE);
        //设置垂直居中对齐
        RwcfF.setVerticalAlignment(VerticalAlignment.CENTRE);
        //设置底部边框线为实线(默认是黑色－－也可以设置其他颜色)
        RwcfF.setBorder(Border.BOTTOM, BorderLineStyle.THIN);
        
        //从0开始，设置列标题
        label = new jxl.write.Label(0,0, "地区名称",RwcfF);
        ws.addCell(label);
        //=======================标题列1=========================
        ws.mergeCells(1, 0, 8, 0);     
        wf = new WritableFont(WritableFont.ARIAL, 10,WritableFont.NO_BOLD, false);
        //字体颜色为红色
        wf.setColour(jxl.format.Colour.BLACK);
        //创建单元格格式：
        RwcfF = new jxl.write.WritableCellFormat(wf);
        //设置水平对齐为居中对齐
        RwcfF.setAlignment(Alignment.CENTRE);
        
        //设置底部边框线为实线(默认是黑色－－也可以设置其他颜色)
        RwcfF.setBorder(Border.BOTTOM, BorderLineStyle.THIN);
        RwcfF.setLocked(true);
        label = new jxl.write.Label(1,0, "发病数",RwcfF);
        ws.addCell(label);
      //=======================标题列2=========================
        ws.mergeCells(9, 0, 16, 0); 
        label = new jxl.write.Label(9,0, "死亡数",RwcfF);
        ws.addCell(label);        
        label = new jxl.write.Label(1,1, "本月",RwcfF);
        ws.addCell(label);        
        label = new jxl.write.Label(2,1, "上月",RwcfF);
        ws.addCell(label);
        label = new jxl.write.Label(3,1, "与上月比(%)",RwcfF);
        ws.addCell(label);
        label = new jxl.write.Label(4,1, "去年同月",RwcfF);
        ws.addCell(label);        
        label = new jxl.write.Label(5,1, "与去年同月比(%)",RwcfF);
        ws.addCell(label);
        label = new jxl.write.Label(6,1, "本年累计",RwcfF);
        ws.addCell(label);
        label = new jxl.write.Label(7,1, "去年累计",RwcfF);
        ws.addCell(label);
        label = new jxl.write.Label(8,1, "与去年累计比(%)",RwcfF);
        ws.addCell(label);
        label = new jxl.write.Label(9,1, "本月",RwcfF);
        ws.addCell(label);        
        label = new jxl.write.Label(10,1, "上月",RwcfF);
        ws.addCell(label);
        label = new jxl.write.Label(11,1, "与上月比(%)",RwcfF);
        ws.addCell(label);
        label = new jxl.write.Label(12,1, "去年同月",RwcfF);
        ws.addCell(label);        
        label = new jxl.write.Label(13,1, "与去年同月比(%)",RwcfF);
        ws.addCell(label);
        label = new jxl.write.Label(14,1, "本年累计",RwcfF);
        ws.addCell(label);
        label = new jxl.write.Label(15,1, "去年累计",RwcfF);
        ws.addCell(label);
        label = new jxl.write.Label(16,1, "与去年累计比(%)",RwcfF);
        ws.addCell(label);
        //冻结第一行、第二行
        ws.getSettings().setHorizontalFreeze(0);
        ws.getSettings().setHorizontalFreeze(1);
        //==========================正文的单元格要求=================
        WritableFont cwf = new WritableFont(WritableFont.ARIAL, 10,WritableFont.NO_BOLD, false);
        //字体颜色为黑色
        cwf.setColour(jxl.format.Colour.BLACK);
        //创建单元格格式：
        WritableCellFormat wcfF = new WritableCellFormat(wf);
        //设置水平对齐为居中对齐
        wcfF.setAlignment(Alignment.CENTRE);
        
        //设置底部边框线为实线(默认是黑色－－也可以设置其他颜色)
        //wcfF.setBorder(Border.BOTTOM, BorderLineStyle.THIN);
        //========数据案例============
        ArrayList<String> alist = new ArrayList<String>();
        alist.add("全  国");
        alist.add("2717");alist.add("2710");alist.add("0.26");alist.add("2935");
        alist.add("-7.43");alist.add("15213");alist.add("15774");alist.add("-3.56");
        
        alist.add("1");alist.add("2");alist.add("-50.00");alist.add("0");
        alist.add("-");alist.add("8");alist.add("2");alist.add("300.00");
        
        for(int i=0,j=2;i<=16;i++){
        	 label = new jxl.write.Label(i,j, alist.get(i),wcfF);
             ws.addCell(label);
        }
        for(int i=0,j=3;i<=16;i++){
       	 label = new jxl.write.Label(i,j, alist.get(i),RwcfF);
            ws.addCell(label);
       }
      //========数据案例 end============        	

        //关闭文件
        wwb.write();
        wwb.close();

   
    }   
}  

最终的效果如下图所示：

地区名称	发病数								死亡数
	本月	上月	与上月比(%)	去年同月	与去年同月比(%)	本年累计	去年累计	与去年累计比(%)	本月	上月	与上月比(%)	去年同月	与去年同月比(%)	本年累计	去年累计	与去年累计比(%)
全  国	2717	2710	0.26	2935	-7.43	15213	15774	-3.56	1	2	-50.00	0	-	8	2	300.00
全  国	2717	2710	0.26	2935	-7.43	15213	15774	-3.56	1	2	-50.00	0	-	8	2	300.00