yearexcel.java

java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经

package com.download;

import java.io.OutputStream;
import java.util.HashMap;
import java.util.Vector;

import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.VerticalAlignment;
import jxl.write.WritableCellFormat;
import jxl.write.WritableSheet;


public class YearExcel {
	  public YearExcel(){}
	  public String expordExcel(OutputStream os)throws Exception{
//		  ExcelData edata = new ExcelData();
	//	  Vector s1=edata.getModel(sql);
		 
	//		System.out.println("高级查询的结果集数目为："+s1.size());
			
		//	int num1=s1.size();
				
	    jxl.write.WritableWorkbook workbook = Workbook.createWorkbook(os); //建立excel文件
  WritableSheet sheet1 = workbook.createSheet("sheet1", 0);//创建sheet
  sheet1.mergeCells(0, 0, 0, 1);
  
  sheet1.mergeCells(1, 0, 2, 1);
  sheet1.mergeCells(3, 0 ,4, 1);
  sheet1.mergeCells(5, 0, 6, 1);
  sheet1.mergeCells(7, 0, 8, 1);
  sheet1.mergeCells(9, 0, 10, 1);
  sheet1.mergeCells(11, 0, 12, 1);
  sheet1.mergeCells(13, 0, 14, 1);
  sheet1.mergeCells(15, 0, 16, 1);
  sheet1.mergeCells(17, 0, 18, 1);
  sheet1.mergeCells(19, 0, 20, 1);
  sheet1.mergeCells(21, 0, 22, 1);
  sheet1.mergeCells(23, 0, 24, 1);
  sheet1.mergeCells(25, 0, 27, 1);

  sheet1.setColumnView(0, 10);
  sheet1.setColumnView(1, 6);
  sheet1.setColumnView(2, 6);
  sheet1.setColumnView(3, 6);
  sheet1.setColumnView(4, 6);
  sheet1.setColumnView(5, 6);
  sheet1.setColumnView(6, 6);
  sheet1.setColumnView(7, 6);
  sheet1.setColumnView(8, 6);
  sheet1.setColumnView(9, 6);
  sheet1.setColumnView(10, 6);
  sheet1.setColumnView(11, 6);
  sheet1.setColumnView(12, 6);
  sheet1.setColumnView(13, 6);
  sheet1.setColumnView(14, 6);
  sheet1.setColumnView(15, 6);
  sheet1.setColumnView(16, 6);
  sheet1.setColumnView(17, 7);
  sheet1.setColumnView(18, 6);
  sheet1.setColumnView(19, 6);
  sheet1.setColumnView(20, 6);
  sheet1.setColumnView(21, 6);
  sheet1.setColumnView(22, 6);
  sheet1.setColumnView(23, 6);
  sheet1.setColumnView(24, 6);
  sheet1.setColumnView(25, 6);
  sheet1.setColumnView(26, 6);
  sheet1.setColumnView(27, 6);

  
  
WritableCellFormat totalx2Format = new WritableCellFormat(); 
  



 totalx2Format.setVerticalAlignment(VerticalAlignment.CENTRE); //垂直居中 
 totalx2Format.setAlignment(Alignment.CENTRE);//水平居中
 //totalx2Format.setBackground(jxl.format.Colour.BLUE_GREY);

    sheet1.addCell(new jxl.write.Label(0, 	0, 	"   ",totalx2Format));     
    sheet1.addCell(new jxl.write.Label(0, 	2, 	"部所",totalx2Format)); 
    sheet1.addCell(new jxl.write.Label(1, 	0, 	"一月",totalx2Format)); 
    sheet1.addCell(new jxl.write.Label(1, 	2, 	"考核",totalx2Format));
    sheet1.addCell(new jxl.write.Label(2, 	2, 	"加减",totalx2Format));
    
    sheet1.addCell(new jxl.write.Label(3, 	0, 	"二月",totalx2Format)); 
    sheet1.addCell(new jxl.write.Label(3, 	2, 	"考核",totalx2Format));
    sheet1.addCell(new jxl.write.Label(4, 	2, 	"加减",totalx2Format));
     
    sheet1.addCell(new jxl.write.Label(5, 	0, 	"三月",totalx2Format)); 
    sheet1.addCell(new jxl.write.Label(5, 	2, 	"考核",totalx2Format));
    sheet1.addCell(new jxl.write.Label(6, 	2, 	"加减",totalx2Format));
    
    sheet1.addCell(new jxl.write.Label(7, 	0, 	"四月",totalx2Format)); 
    sheet1.addCell(new jxl.write.Label(7, 	2, 	"考核",totalx2Format));
    sheet1.addCell(new jxl.write.Label(8, 	2, 	"加减",totalx2Format));
    
    sheet1.addCell(new jxl.write.Label(9, 	0, 	"五月",totalx2Format)); 
    sheet1.addCell(new jxl.write.Label(9, 	2, 	"考核",totalx2Format));
    sheet1.addCell(new jxl.write.Label(10, 	2, 	"加减",totalx2Format));
    
    sheet1.addCell(new jxl.write.Label(11, 	0, 	"六月",totalx2Format)); 
    sheet1.addCell(new jxl.write.Label(11, 	2, 	"考核",totalx2Format));
    sheet1.addCell(new jxl.write.Label(12, 	2, 	"加减",totalx2Format));
    
    sheet1.addCell(new jxl.write.Label(13, 	0, 	"七月",totalx2Format)); 
    sheet1.addCell(new jxl.write.Label(13, 	2, 	"考核",totalx2Format));
    sheet1.addCell(new jxl.write.Label(14, 	2, 	"加减",totalx2Format));
    
    sheet1.addCell(new jxl.write.Label(15, 	0, 	"八月",totalx2Format)); 
    sheet1.addCell(new jxl.write.Label(15, 	2, 	"考核",totalx2Format));
    sheet1.addCell(new jxl.write.Label(16, 	2, 	"加减",totalx2Format));
    
    sheet1.addCell(new jxl.write.Label(17, 	0, 	"九月",totalx2Format)); 
    sheet1.addCell(new jxl.write.Label(17, 	2, 	"考核",totalx2Format));
    sheet1.addCell(new jxl.write.Label(18, 	2, 	"加减",totalx2Format));
    
    sheet1.addCell(new jxl.write.Label(19, 	0, 	"十月",totalx2Format)); 
    sheet1.addCell(new jxl.write.Label(19, 	2, 	"考核",totalx2Format));
    sheet1.addCell(new jxl.write.Label(20, 	2, 	"加减",totalx2Format));
    
    sheet1.addCell(new jxl.write.Label(21, 	0, 	"十一月",totalx2Format)); 
    sheet1.addCell(new jxl.write.Label(21, 	2, 	"考核",totalx2Format));
    sheet1.addCell(new jxl.write.Label(22, 	2, 	"加减",totalx2Format));
    
    sheet1.addCell(new jxl.write.Label(23, 	0, 	"十二月",totalx2Format)); 
    sheet1.addCell(new jxl.write.Label(23, 	2, 	"考核",totalx2Format));
    sheet1.addCell(new jxl.write.Label(24, 	2, 	"加减",totalx2Format));

	
	sheet1.addCell(new jxl.write.Label(25, 	0, 	"小计",totalx2Format));
	sheet1.addCell(new jxl.write.Label(25, 	2, 	"考核",totalx2Format));
	sheet1.addCell(new jxl.write.Label(26, 	2, 	"加减",totalx2Format));
	sheet1.addCell(new jxl.write.Label(27, 	2, 	"总计",totalx2Format));

		   sheet1.addCell(new jxl.write.Label(0,  3, "办公室",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0,  4, "党群工作部",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0,  5, "人事部",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0,  6, "财务部",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0,  7, "市场经营部",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0,  8, "安全监察部",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0,  9, "生产技术部",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0,  10, "科研开发部",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0,  11, "基建调试部",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0,  12, "综合部",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0, 13, "园区建管部",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0, 14, "电气所",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0, 15, "计量所",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0, 16, "自动化所",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0, 17, "系统分析所",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0, 18, "热能动力所",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0, 19, "水能动力所",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0, 20, "化学环保所",totalx2Format));
		   sheet1.addCell(new jxl.write.Label(0, 21, "金属所",totalx2Format));
		
	//	}
				
		
   workbook.write();
   //关闭Excel工作薄对象
   workbook.close();
	    os.close();
	    return "success";
	  }
}