package com.tanruyu.demo;

import java.io.File;

import java.io.FileOutputStream;

import java.util.Map;

import java.util.Set;

import java.util.TreeMap;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.IndexedColors;

import org.apache.poi.xssf.usermodel.XSSFCellStyle;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class CreateXlsx {

    public static void main(String[] args) throws Exception {

        // 1. 创建一个工作薄

        XSSFWorkbook workbook = new XSSFWorkbook();

        // 创建一个目录和文件名

        FileOutputStream out = new FileOutputStream(new File("f:\\createworkbook.xlsx"));

        // 2. 创建一个工作表

        XSSFSheet spreadsheet = workbook.createSheet("Sheet1");

        // 数据

        Map<String, Object[]> empinfo = new TreeMap<String, Object[]>();

        empinfo.put("1", new Object[] { "EMP ID", "EMP NAME", "DESIGNATION" });

        empinfo.put("2", new Object[] { "tp01", "Gopal", "Technical Manager" });

        empinfo.put("3", new Object[] { "tp02", "Manisha", "Proof Reader" });

        empinfo.put("4", new Object[] { "tp03", "Masthan", "Technical Writer" });

        empinfo.put("5", new Object[] { "tp04", "Satish", "Technical Writer" });

        empinfo.put("6", new Object[] { "tp05", "Krishna", "Technical Writer" });

        Set<String> keyid = empinfo.keySet();// 获取所有的key值

        int rowid = 0;

        for (String key : keyid) {

            // 3. 创建一行

            XSSFRow row = spreadsheet.createRow(rowid++);

            Object[] objectArr = empinfo.get(key);

            // 单元格样式 试验

            XSSFCellStyle style5 = workbook.createCellStyle();

            style5.setAlignment(XSSFCellStyle.ALIGN_CENTER);

            style5.setBorderBottom(XSSFCellStyle.BORDER_THICK);

            style5.setBottomBorderColor(IndexedColors.BLUE.getIndex());

            style5.setBorderLeft(XSSFCellStyle.BORDER_DOUBLE);

            style5.setLeftBorderColor(IndexedColors.GREEN.getIndex());

            style5.setBorderRight(XSSFCellStyle.BORDER_HAIR);

            style5.setRightBorderColor(IndexedColors.RED.getIndex());

            style5.setBorderTop(XSSFCellStyle.BIG_SPOTS);

            style5.setTopBorderColor(IndexedColors.CORAL.getIndex());

            // cell.setCellStyle(style5);

            int cellid = 0;

            for (Object obj : objectArr) {

                // 在行中创建一个单元格

                Cell cell = row.createCell(cellid++);

                // 设置单元格的值

                cell.setCellValue((String) obj);

                // 设置单元格样式

                cell.setCellStyle(style5);
            }
        }
        // 输出
        workbook.write(out);
        out.close();
        System.out.println(" createworkbook.xlsx written successfully");
    }
}