java xlsx poi,java poi 操作 1 创建Excel.xlsx

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 empinfo = new TreeMap();

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 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");

}

}