jxls 问题总结(自用--持续更新)

1- 拒绝访问

下午用jxls来导出excel文件, 结果控制台报了这个错,源代码如下:

 private static String templateFileName = "F:/jxls-1.0.2/examples/src/main/resources/templates/adjacentlists.xls";
    private static String destFileName = "F:/jxls-1.0.2/dest";

此处省略一万码

        Map beans = new HashMap();
        beans.put("depIT", depIT);
        beans.put("depHR", depHR);

        XLSTransformer transformer = new XLSTransformer();
        transformer.transformXLS(templateFileName, beans, destFileName);

报错内容：

Exception in thread "main" java.io.FileNotFoundException: F:\jxls-1.0.2\dest (拒绝访问。)
	at java.io.FileOutputStream.open(Native Method)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
	at java.io.FileOutputStream.<init>(FileOutputStream.java:70)
	at net.sf.jxls.transformer.XLSTransformer.transformXLS(XLSTransformer.java:202)
	at net.sf.jxls.sample.AdjacentListsSample.main(AdjacentListsSample.java:58)

原因: 他是需要指定文件名, 不是文件夹.  这个错在IO操作的时候经常会出, 引以为戒.