【POI】第一个POI例子将数据写入到Excel文档中

来源：互联网发布：雅思有模考软件么编辑：程序博客网时间：2024/06/03 06:13

首先我们可以去官网下载相关的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( "写入成功" );   }}

运行结果:

阅读全文

0 0