java导出excel

java代码

//获取保存文件地址
            String saveFilePath = conf.get("down.url") + "/" ;
            Workbook workbook=new XSSFWorkbook();

            //创建sheet
            Sheet sheet1=workbook.createSheet("结果总数拦截记录");
            

            //写入sheet数据

            //表头
            JSONObject head=new JSONObject();
            head.put("deptname","科室名称");
            head.put("fzyh","住院号");
            
            //表头属性
            List<String> props=Arrays.asList("deptname","fzyh");

            //第一个sheet的数据
            JSONObject obj1=getDeptShjlDetails(happenDate,strDate,endDate,null,"结果总数",ruletype,null,null,null,null,"","",gzlx);
            JSONArray arr1=obj1.getJSONArray("list");

            

            //创建表头
            Row row=sheet1.createRow(0);
            for(int j=0;j<props.size();j++){
                //创建列
                Cell cell=row.createCell(j);
                cell.setCellValue(head.getString(props.get(j)));
            }

            //创建表数据
            for(int i=0;i<arr1.size();i++){
                //创建行
                Row rowData=sheet1.createRow(i+1);
                for(int j=0;j<props.size();j++){
                    //创建列
                    Cell cell=rowData.createCell(j);
                    Record record= (Record) arr1.get(i);
                    cell.setCellValue(record.getString(props.get(j)));
                }

            }


            SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
            //导出excel文件
            String fileName="全部科室拦截记录.xlsx";
            File file=new File(saveFilePath+"/"+sdf.format(new Date()),fileName);
            if(!file.exists()){
                File dirFile = new File(file.getParent());
                if(!dirFile.exists()){
                    dirFile.mkdirs();
                }
                file.createNewFile();
            }
            FileOutputStream outputStream=new FileOutputStream(file);

            workbook.write(outputStream);
            workbook.close();
            outputStream.close();