java如何设置poi的保存路径 第2页

                     }
                     else
                     {
                         val = rs.getObject(j).toString();
                     }
                     if (val == null)
                     {
                         cell.setCellValue("NULL");
                     }
                     else
                     {
                         cell.setCellValue(val);
                     }
                 }
                 iRow++;
             }
             // 保存文件
             FileOutputStream fOut = new FileOutputStream(xlsName);

             workbook.write(fOut);
             fOut.flush();
             fOut.close();
             System.out.println("导出数据完成！");
         }
         catch (Exception e)
         {
             System.out.println("写表时异常..." + e.getMessage());
         }
     }
保存路径？你是要保存到服务器上？
你在服务器新建一个文件夹，生成文件的时候，在该文件夹下生成不就好了么。
如果提供下载的话，给用户一个超链接好了。
 
  String excelName = "abc.xls";
        response.setHeader("Content-Disposition", "attachment;filename=" + new String(excelName.getBytes(), "iso-8859-1"));
        ServletOutputStream out = response.getOutputStream();
        BufferedOutputStream bos = new BufferedOutputStream(out);
       
        wb.write(bos);//wb是HSSFWorkbook，也就是你程序里的workbook
        if(bos != null){
            bos.close();
        }
        if(out != null){
            out.close();
        }

上一页  [1] [2]