集合数据导向Xlsx文件

    /**
     * 将筛选后的集合存入Xlsx文件中
     * @param list 待存集合
     */
    public static void toXlsx(  List<TransRecord> list,String path){
        //获取抽象类WritableWorkbook对象 。
        WritableWorkbook book = null;
        //定义表头
        String[] tableHead = {"客户号","姓名","所述机构号","性别","帐号","发生时间","发生额"};
        try {
            book = Workbook.createWorkbook(new File(path));
            //生成工作表，参数0表示第一页
            //创建Sheet工作名称workSheet
            WritableSheet sheet = book.createSheet("workSheet",0);
            //表头导航,循环为表头赋值
            for (int i = 0; i < tableHead.length;i++){
                //i为行，r为列
                //lable文本单元格
                Label label = new Label(i,0,tableHead[i]);
                //为单元格添加内容.
                sheet.addCell(label);
            }
            //循环将集合中的数据添加进sheet
            //将内容放入到对应的行和列。
            for (int j = 0; j < list.size();j++){
                //c行r列   列需要+1，从1开始
                sheet.addCell(new Label(0,j+1,list.get(j).getCustomerNumber()));
                sheet.addCell(new Label(1,j+1,list.get(j).getName()));
                sheet.addCell(new Label(2,j+1,list.get(j).getMechanism()));
                sheet.addCell(new Label(3,j+1, String.valueOf(list.get(j).getSex())));
                sheet.addCell(new Label(4,j+1,String.valueOf(list.get(j).getAccount())));
                sheet.addCell(new Label(5,j+1,String.valueOf(list.get(j).getTime())));
                sheet.addCell(new Label(6,j+1,String.valueOf(list.get(j).getMoney())));
            }
            book.write();
        } catch (IOException | WriteException e) {
            e.printStackTrace();
        } finally {
            //关闭资源
            try {
                if (book != null)
                    book.close();
            } catch (IOException | WriteException e) {
                e.printStackTrace();
            }
        }
    }

jar包的连接：
添加链接描述