POI excel导出

package com.gotokeep.erp.test.utils;

import com.gotokeep.erp.test.JsonData;
import  org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.usermodel.BorderStyle;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.HorizontalAlignment;

import java.io.FileOutputStream;

public class ExcelExport {
    // 创建新的Excel 工作簿
    static HSSFWorkbook workbook = new HSSFWorkbook();
    static HSSFFont font = workbook.createFont();
    static HSSFCellStyle style = workbook.createCellStyle();//PASS-style

    //在Excel工作簿中建一工作表
    static HSSFSheet sheet = workbook.createSheet("UserEventUA");
    static HSSFRow rowinsert;
    static HSSFCell ceilinsert;

    public static void CreateXls(String outfile){
        try{
            font.setFontHeightInPoints((short) 10);//设置字体大小
            font.setFontName("Times");
            style.setBorderBottom(BorderStyle.THIN);//下边框
            style.setBorderLeft(BorderStyle.THIN);//左边框
            style.setBorderTop(BorderStyle.THIN);//上边框
            style.setBorderRight(BorderStyle.THIN);//右边框
            style.setAlignment(HorizontalAlignment.LEFT);//字体左对齐
            style.setWrapText(true);//设置自动换行
            style.setFont(font);
            //设置列宽
            for(int i=0;i<13;i++) {
                sheet.setColumnWidth(i, 3200);
            }
            // 在索引0的位置创建行（最顶端的行）
            HSSFRow row = sheet.createRow((short) 0);
            row.setHeight((short) 500);
            //在索引0的位置创建单元格（左上端）
            HSSFCell cell = row.createCell((short) 0);
            // 定义单元格为字符串类型
            cell.setCellType(CellType.STRING);
            cell.setCellValue("第一题"); cell.setCellStyle(style);
            cell = row.createCell((short) 1);
            cell.setCellValue("第二题"); cell.setCellStyle(style);
            cell = row.createCell((short) 2);
            cell.setCellValue("第三题"); cell.setCellStyle(style);
            cell = row.createCell((short) 3);
            cell.setCellValue("答对题数"); cell.setCellStyle(style);
            cell = row.createCell((short) 4);
            cell.setCellValue("第四题"); cell.setCellStyle(style);
            cell = row.createCell((short) 5);
            cell.setCellValue("姓名"); cell.setCellStyle(style);
            cell = row.createCell((short) 6);
            cell.setCellValue("性别"); cell.setCellStyle(style);
            cell = row.createCell((short) 7);
            cell.setCellValue("年龄"); cell.setCellStyle(style);
            cell = row.createCell((short) 8);
            cell.setCellValue("公司"); cell.setCellStyle(style);
            cell = row.createCell((short) 9);
            cell.setCellValue("职业"); cell.setCellStyle(style);
            cell = row.createCell((short) 10);
            cell.setCellValue("社会平台"); cell.setCellStyle(style);
            cell = row.createCell((short) 11);
            cell.setCellValue("电话号码"); cell.setCellStyle(style);
            cell = row.createCell((short) 12);
            cell.setCellValue("所在城市"); cell.setCellStyle(style);

            // 新建一输出文件流
            FileOutputStream fOut = new FileOutputStream(outfile);
            // 把相应的Excel 工作簿存盘
            workbook.write(fOut);
            fOut.flush();
            // 操作结束，关闭文件
            fOut.close();
        }catch (Exception e){
        }
    }


    public static void exportrow(int i, JsonData jsonData){
        HSSFRow rowinsert1 = sheet.createRow((short) i);
//        rowinsert1.setHeight((short) 1200);
        HSSFCell ceilinsert1 = rowinsert1.createCell((short)0);
        ceilinsert1.setCellType(CellType.STRING);
        int num=0;
        if (jsonData.getA()==1){
            ceilinsert1.setCellValue("对");
            num++;
        }else{
            ceilinsert1.setCellValue("错");
        }
        ceilinsert1.setCellStyle(style);

        ceilinsert1 = rowinsert1.createCell((short)1);
        ceilinsert1.setCellType(CellType.STRING);
        if (jsonData.getB()==1){
            ceilinsert1.setCellValue("对");
            num++;
        }else{
            ceilinsert1.setCellValue("错");
        }
        ceilinsert1.setCellStyle(style);

        ceilinsert1 = rowinsert1.createCell((short)2);
        ceilinsert1.setCellType(CellType.STRING);
        if (jsonData.getC()==2){
            ceilinsert1.setCellValue("对");
            num++;
        }else{
            ceilinsert1.setCellValue("错");
        }
        ceilinsert1.setCellStyle(style);

        ceilinsert1 = rowinsert1.createCell((short)3);
        ceilinsert1.setCellType(CellType.STRING);
        ceilinsert1.setCellValue(num); ceilinsert1.setCellStyle(style);

        ceilinsert1 = rowinsert1.createCell((short)4);
        ceilinsert1.setCellType(CellType.STRING);
        ceilinsert1.setCellValue(jsonData.getD()); ceilinsert1.setCellStyle(style);

        ceilinsert1 = rowinsert1.createCell((short)5);
        ceilinsert1.setCellType(CellType.STRING);
        ceilinsert1.setCellValue(jsonData.getName()); ceilinsert1.setCellStyle(style);

        ceilinsert1 = rowinsert1.createCell((short)6);
        ceilinsert1.setCellType(CellType.STRING);
        ceilinsert1.setCellValue(jsonData.getGender().equalsIgnoreCase("M")?"男":"女"); ceilinsert1.setCellStyle(style);

        ceilinsert1 = rowinsert1.createCell((short)7);
        ceilinsert1.setCellType(CellType.STRING);
        ceilinsert1.setCellValue(jsonData.getAge()); ceilinsert1.setCellStyle(style);

        ceilinsert1 = rowinsert1.createCell((short)8);
        ceilinsert1.setCellType(CellType.STRING);
        ceilinsert1.setCellValue(jsonData.getCompany()); ceilinsert1.setCellStyle(style);

        ceilinsert1 = rowinsert1.createCell((short)9);
        ceilinsert1.setCellType(CellType.STRING);
        ceilinsert1.setCellValue(jsonData.getJobTitle()); ceilinsert1.setCellStyle(style);

        ceilinsert1 = rowinsert1.createCell((short)10);
        ceilinsert1.setCellType(CellType.STRING);
        ceilinsert1.setCellValue(jsonData.getSocialPlatform()); ceilinsert1.setCellStyle(style);

        ceilinsert1 = rowinsert1.createCell((short)11);
        ceilinsert1.setCellType(CellType.STRING);
        ceilinsert1.setCellValue(jsonData.getPhoneNumber()); ceilinsert1.setCellStyle(style);

        ceilinsert1 = rowinsert1.createCell((short)12);
        ceilinsert1.setCellType(CellType.STRING);
        ceilinsert1.setCellValue(jsonData.getCity()); ceilinsert1.setCellStyle(style);


        rowinsert=rowinsert1;
        ceilinsert=ceilinsert1;
    }
}