首先我们可以去官网下载相关的POI的jar包
https://poi.apache.org/download.html
然后将需要的jar包引入到项目中去
这样我们的准备工作就好了,然后我们就准备数据到集合中,并将数据写入到WriteSheet.xlsx
package cn.qblank.poi;
import java.io.File;
import java.io.FileNotFoundException;
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.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
/**
* 写数据到表格中
* @author evan_qb
*/
public class Writesheet {
public static void main(String[] args) throws Exception {
//创建XSSFWorkbook对象
XSSFWorkbook workbook = new XSSFWorkbook();
//创建表格
XSSFSheet spreadsheet = workbook.createSheet("部门表");
XSSFRow row;
Map < String, Object[] > empinfo = new TreeMap < String, Object[] >();
empinfo.put( "1", new Object[] {"编号", "部门名字", "描述" });
empinfo.put( "2", new Object[] {"1", "java开发部门", "java" });
empinfo.put( "3", new Object[] {"2", "php开发部门", "php" });
empinfo.put( "4", new Object[] {"3", "前端", "javascript" });
empinfo.put( "5", new Object[] {"4", "c++开发部", "c++" });
empinfo.put( "6", new Object[] {"5", "测试部门", "测试" });
//遍历Map集合
Set < String > keyid = empinfo.keySet();
//定义行
int rowid = 0;
for (String key : keyid){
//创建行
row = spreadsheet.createRow(rowid++);
//通过键获取对应的Object类型的值
Object [] objectArr = empinfo.get(key);
//定义列id
int cellid = 0;
//创建列并给其赋值
for (Object obj : objectArr){
Cell cell = row.createCell(cellid++);
cell.setCellValue((String)obj);
}
}
//写入文件到硬盘中
FileOutputStream out = new FileOutputStream(new File("d:/Writesheet.xlsx"));
workbook.write(out);
out.close();
workbook.close();
System.out.println( "写入成功" );
}
}
运行结果: