Can andbody help me ? I will be very grateful. Thanks, Kevin
On Fri, Jan 4, 2019 at 8:12 PM Kevin Yao <[email protected]> wrote: > hi, > I get a null exception when I use workbook write function with Apache POI. > My java code is > > try (OutputStream out = new FileOutputStream(saveUrl)) { > workbook.write(out); > } catch (IOException e) { > System.err.println(e.getMessage()); > } > > > The exception log is shown below. > > java.lang.NullPointerException > at > org.apache.poi.poifs.filesystem.FilteringDirectoryNode$FilteringIterator.<init>(FilteringDirectoryNode.java:193) > at > org.apache.poi.poifs.filesystem.FilteringDirectoryNode$FilteringIterator.<init>(FilteringDirectoryNode.java:188) > at > org.apache.poi.poifs.filesystem.FilteringDirectoryNode.getEntries(FilteringDirectoryNode.java:101) > at > org.apache.poi.poifs.filesystem.FilteringDirectoryNode.iterator(FilteringDirectoryNode.java:105) > at org.apache.poi.poifs.filesystem.EntryUtils.copyNodes(EntryUtils.java:71) > at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1407) > at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1375) > at QuestionnaireExcel.writeExcelToLocal(QuestionnaireExcel.java:42) > at Main.main(Main.java:18) > > The exception is the same as the url > *https://stackoverflow.com/questions/35654570/nullpointerexception-on-writing-excel-file-with-apache-poi > <https://stackoverflow.com/questions/35654570/nullpointerexception-on-writing-excel-file-with-apache-poi>.* > > I searched a lot on Google but didn't find a useful solution. Could you > give me some advice to solve it ? > > Thanks, > Kevin >
