/*
 * Created on 2006-9-13
 */
package com.livedoor.finance.credit.admin.business.event.service;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.Region;

/**
 * @author Warren~@_@
 */
public class CatOutputSpecification2 {
    HSSFWorkbook hssfWorkbook;
    HSSFSheet hssfSheet;
    HSSFRow hssfRow;
    HSSFCell hssfCell;
   
    OutputStream out;
   
    private String fontName = "MS Pゴシツク";
    private short fontSize = (short) 11;
    private short fontTitleSize = (short) 16;
   
    public CatOutputSpecification2() {
       
    }
   
    public static void main(String[] args) {
        CatOutputSpecification2 cat = new CatOutputSpecification2();
        cat.executeExcel();
       
        System.out.println("========");
    }
   
    public void executeExcel() {
        String filePath = null;
        FileOutputStream fos = null;
       
        filePath = "./data/testPOI.xls";
       
        try {
            fos = new FileOutputStream(filePath);
           
            generate(fos);
           
            fos.close();
        } catch (FileNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    /**
     * @param fos
     */
    private void generate(OutputStream out) {
        // TODO Auto-generated method stub
        this.out = out;
       
        drawWB();
    }

    /**
     *
     */
    private void drawWB() {
        // TODO Auto-generated method stub
        hssfWorkbook = new HSSFWorkbook();
       
        hssfSheet = hssfWorkbook.createSheet();
        hssfWorkbook.setSheetName(0, "test", HSSFWorkbook.ENCODING_UTF_16);
       
        hssfSheet.setDisplayGridlines(true);
       
        for (int i = 0; i < 30; i++) {
            hssfSheet.setColumnWidth((short) i, (short) (4.25 * 256));
        }
       
        drawCell();
       
        try {
            hssfWorkbook.write(out);
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    /**
     *
     */
    private void drawCell() {
        // 1~2 row
        HSSFRow row_001 = hssfSheet.createRow(1);
        HSSFRow row_002 = hssfSheet.createRow(2);
       
        HSSFCell cell_001_000 = row_001.createCell((short) 0);
        HSSFCell cell_002_029 = row_002.createCell((short) 29);
       
        hssfSheet.addMergedRegion(new Region(1, (short) 0, 2, (short) 29));
       
        // 4 row
        HSSFRow row_004 = hssfSheet.createRow(4);
       
        HSSFCell cell_004_001 = row_004.createCell((short) 1);
        HSSFCell cell_004_005 = row_004.createCell((short) 5);
        HSSFCell cell_004_013 = row_004.createCell((short) 13);
       
        hssfSheet.addMergedRegion(new Region(4, (short) 5, 4, (short) 13));
       
        // 5~11 row
        HSSFRow row_005 = hssfSheet.createRow(5);
        HSSFRow row_011 = hssfSheet.createRow(11);
       
        HSSFCell cell_005_000 = row_005.createCell((short) 0);
        HSSFCell cell_011_029 = row_011.createCell((short) 29);
       
        hssfSheet.addMergedRegion(new Region(5, (short) 0, 11, (short) 29));
       
        // 13 row
        HSSFRow row_013 = hssfSheet.createRow(13);
       
        HSSFCell cell_013_000 = row_013.createCell((short) 0);
       
        // 14 row
        HSSFRow row_014 = hssfSheet.createRow(14);
       
        HSSFCell cell_014_001 = row_014.createCell((short) 1);
        HSSFCell cell_014_007 = row_014.createCell((short) 7);
        HSSFCell cell_014_008 = row_014.createCell((short) 8);
        HSSFCell cell_014_027 = row_014.createCell((short) 27);
       
        hssfSheet.addMergedRegion(new Region(14, (short) 1, 14, (short) 7));
        hssfSheet.addMergedRegion(new Region(14, (short) 8, 14, (short) 27));
       
        // 15 row
        HSSFRow row_015 = hssfSheet.createRow(14);
       
        HSSFCell cell_015_001 = row_015.createCell((short) 1);
        HSSFCell cell_015_007 = row_015.createCell((short) 7);
        HSSFCell cell_015_008 = row_015.createCell((short) 8);
        HSSFCell cell_015_027 = row_015.createCell((short) 27);
       
        hssfSheet.addMergedRegion(new Region(15, (short) 1, 15, (short) 7));
        hssfSheet.addMergedRegion(new Region(15, (short) 8, 15, (short) 27));
       
        // 16 row
        HSSFRow row_016 = hssfSheet.createRow(14);
       
        HSSFCell cell_016_001 = row_016.createCell((short) 1);
        HSSFCell cell_016_007 = row_016.createCell((short) 7);
        HSSFCell cell_016_008 = row_016.createCell((short) 8);
        HSSFCell cell_016_027 = row_016.createCell((short) 27);
       
        hssfSheet.addMergedRegion(new Region(16, (short) 1, 16, (short) 7));
        hssfSheet.addMergedRegion(new Region(16, (short) 8, 16, (short) 27));
       
        // 17 row
        HSSFRow row_017 = hssfSheet.createRow(14);
       
        HSSFCell cell_017_001 = row_017.createCell((short) 1);
        HSSFCell cell_017_007 = row_017.createCell((short) 7);
        HSSFCell cell_017_008 = row_017.createCell((short) 8);
        HSSFCell cell_017_027 = row_017.createCell((short) 27);
       
        hssfSheet.addMergedRegion(new Region(17, (short) 1, 17, (short) 7));
        hssfSheet.addMergedRegion(new Region(17, (short) 8, 17, (short) 27));
       
        // 18 row
        HSSFRow row_018 = hssfSheet.createRow(14);
       
        HSSFCell cell_018_001 = row_018.createCell((short) 1);
        HSSFCell cell_018_007 = row_018.createCell((short) 7);
        HSSFCell cell_018_008 = row_018.createCell((short) 8);
        HSSFCell cell_018_027 = row_018.createCell((short) 27);
       
        hssfSheet.addMergedRegion(new Region(18, (short) 1, 18, (short) 7));
        hssfSheet.addMergedRegion(new Region(18, (short) 8, 18, (short) 27));
       
        // 19 row
        HSSFRow row_019 = hssfSheet.createRow(14);
       
        HSSFCell cell_019_001 = row_019.createCell((short) 1);
        HSSFCell cell_019_007 = row_019.createCell((short) 7);
        HSSFCell cell_019_008 = row_019.createCell((short) 8);
        HSSFCell cell_019_027 = row_019.createCell((short) 27);
       
        hssfSheet.addMergedRegion(new Region(19, (short) 1, 19, (short) 7));
        hssfSheet.addMergedRegion(new Region(19, (short) 8, 19, (short) 27));
       
        // set style
        cell_001_000.setCellStyle(cellStyle_title());
       
        // set encoding
        cell_001_000.setEncoding(HSSFCell.ENCODING_UTF_16);
 
        // set value
        cell_001_000.setCellValue("テクス");
    }

    /**
     * @return style_title
     */
    private HSSFCellStyle cellStyle_title() {
        HSSFCellStyle style_title = hssfWorkbook.createCellStyle();
        style_title.setFont(getFont_title());
        style_title.setVerticalAlignment(HSSFCellStyle.ALIGN_CENTER);
        return style_title;
    }

    /**
     * @return font_title
     */
    private HSSFFont getFont_title() {
        HSSFFont font_title = hssfWorkbook.createFont();
        font_title.setFontName(fontName);
        font_title.setFontHeightInPoints(fontTitleSize);
        font_title.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
        return font_title;
    }
}
~@_@