【工具】获取pojo类属性，并写入表格

【工具】获取pojo类属性，并写入表格

1、添加依赖

  　　　 <!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->

        <dependency>

            <groupId>org.apache.poi</groupId>

            <artifactId>poi</artifactId>

            <version>3.9</version>

        </dependency>

        <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->

        <dependency>

            <groupId>org.apache.poi</groupId>

            <artifactId>poi-ooxml</artifactId>

            <version>3.9</version>

        </dependency>       

2、java代码

public class CreateExcel {

    static String fileName = "work1.xsl";

    /**

     * 读取domain文件的属性名和类型

     * @param object

     * @return

     */

    public static List<Map<String, String>> getDomainV(Object object){

        List<Map<String, String>> result = new ArrayList<Map<String,String>> ();

        Field[] fields = object.getClass().getDeclaredFields();

        for(int i=0;i<fields.length;i++){

            Map<String, String> map = new HashMap<String, String>();

            String attributeName = fields[i].getName();  //获取属性名称

            String attributeType = fields[i].getGenericType().toString(); //获取属性类型

            String[] types = attributeType.split("\\.");

            map.put("name", attributeName);

            map.put("type", types[types.length-1]);

            result.add(map);

        }

        return result;

    }

    /**

     * 生成表格

     * @param list

     * @throws IOException

     */

    public static void createWorkBook(List<Map<String, String>> list,String fileName) throws IOException {

            Workbook wb = new HSSFWorkbook();//创建excel工作簿

            Sheet sheet = wb.createSheet("new sheet"); //创建第一个sheet（页），命名为 new sheet 

            for(int i=0;i<list.size();i++){

                Row row = sheet.createRow(i); // 创建一行，在页sheet上

                Cell cell = row.createCell(0); // 在row行上创建一个方格

                cell.setCellValue(list.get(i).get("name")); //设置方格的显示

                cell = row.createCell(1);

                cell.setCellValue(list.get(i).get("type")); //

            }

            FileOutputStream fileOut = new FileOutputStream(fileName);

            wb.write(fileOut);

            fileOut.close();

        } 

    /**

    * 读取Excel表格

    * @param fileName

    * @throws Exception

    */

    public static void readWorkBook(String fileName) throws Exception {

        InputStream inp = new FileInputStream(fileName); 

        Workbook wb = WorkbookFactory.create(inp);

        Sheet sheet = wb.getSheetAt(0); 

        for (Row row : sheet) { //利用foreach循环 遍历sheet中的所有行

            for (Cell cell : row) { //遍历row中的所有方格

                System.out.print(cell.toString() + "  "); //输出方格中的内容，以空格间隔

            }

            System.out.println();   //每一个行输出之后换行

        }

        inp.close(); //关闭输入流

    } 

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

        Student stu = new Student();

        List<Map<String, String>> list = getDomainV(stu);

        createWorkBook(list,fileName);

        System.out.println("creat successful!");

        readWorkBook(fileName);

    } 

}