【无标题】

将List导入到Excel中

 if (null != list && list.size() > 0) {
            Field[] fields = list.get(0).getClass().getSuperclass().getDeclaredFields();
            int len = fields.length;
            
            title = new String[len];
            int index = 0 ;
            
            for (int i = 0; i < len; i++) {
                String name = fields[i].getName();
                if (name.equals("serialVersionUID")){
                    continue;
                }
                title[i] = name;
            }
            
            for (int i = 0; i < list.size(); i++) {
                content[i] = new Object[title.length];
                for (int j = 0; j < title.length; j++) {
                    String name = fields[j].getName();
                    if (name.equals("serialVersionUID")){
                        continue;
                    }
                    
                    fields[j].setAccessible(true);
                    Field field = fields[j];
                    //Object value = fields[j].get(name) + "";
                    Object value = fields[j].get(list.get(i));
                    content[i][j] = value;
                }
            }
            
            HSSFWorkbook workbook = ExcelUtils.getHSSFWorkbook("period_strategy_income", title, content, null);//写入HSSFWorkbook

            File file =new File(EXPORT_PATH);
            //如果文件导出路径不存在则创建
            if(!file.exists()) {
                file.mkdirs();
            }
            SimpleDateFormat df = new SimpleDateFormat("yyyyMMddHHmmss");
            String fileName=  "***-" + df.format(new Date()) + ".xls" ;
            filePath = EXPORT_PATH + fileName;
            FileOutputStream fos = new FileOutputStream(filePath);
            workbook.write(fos);
            fos.close();
            
    
    @SuppressWarnings("deprecation")
    public static HSSFWorkbook getHSSFWorkbook(String sheetName, String[] title, Object[][] values, HSSFWorkbook wb){
        // 第一步，创建一个HSSFWorkbook，对应一个Excel文件
        if(wb == null){
            wb = new HSSFWorkbook();
        }
        // 第二步，在workbook中添加一个sheet,对应Excel文件中的sheet
        HSSFSheet sheet = wb.createSheet(sheetName);
        // 第三步，在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制
        HSSFRow row = sheet.createRow(0);
        row.setHeightInPoints(15);
        // 第四步，创建单元格，并设置值表头 设置表头居中
        HSSFCellStyle headerStyle = wb.createCellStyle();
        //创建一个水平居中和垂直居中
        headerStyle.setAlignment(HorizontalAlignment.CENTER);
        headerStyle.setVerticalAlignment(VerticalAlignment.CENTER);
        Font font = wb.createFont();
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
        font.setFontName("宋体");
        headerStyle.setFont(font);

        //创建标题
        for(int i=0;i