Read data from read only xlsm file using Java Apache POI

Question

I'm trying to read data from a read only xlsm using java apache poi, but when I use XSSF workbook it doesn't seem to be able to access the file and HSSF workbooks only work for xls files. My code looks like this:

try {
                FileInputStream file = new FileInputStream(new File("file.xlsm"));
                System.out.println("found file");
                XSSFWorkbook workbook = new XSSFWorkbook(file);
                System.out.println("in workbook");
                XSSFSheet sheet = workbook.getSheet("Shipments");
                System.out.println("got sheet");

The code never reaches the "in workbook" print line and I'm not sure why. Please help!

none, the program just keeps running but never does anything — ajs, Jun 20 '14 at 20:00
@ajs this sounds like you actually catch and swallow the exception. I'm interested on what is in your catch block... — Daniel Baktiar, Feb 15 '18 at 02:46

score 4 · Answer 1 · answered Oct 18 '18 at 08:29

4

Version 4.0.0 has a workbook factory class with a boolean "readonly" parameter. So, to open in read-only mode...

XSSFWorkbook nextWorkbook = XSSFWorkbookFactory.createWorkbook(myFile, true);

answered Oct 18 '18 at 08:29

ssimm

1,908
3
16
36

score -2 · Accepted Answer · edited Apr 08 '19 at 12:45

-2

I copied your code and gave the absolute path of the file, and I was able to get the expected result.

FileInputStream file = new FileInputStream(new File("C:\\Users\\user\\Desktop\\filet.xlsm"));
System.out.println("found file");
XSSFWorkbook workbook = new XSSFWorkbook(file);
System.out.println("in workbook");
XSSFSheet sheet = workbook.getSheet("Shipments");
System.out.println("got sheet");

It seems like a problem with your referencing. Therefore check the way you refer to the files when you try to create the file resource.

edited Apr 08 '19 at 12:45

Romeo Sierra

1,666
1
17
35

answered Jul 09 '14 at 10:07

Pjarenee

391
3
4

the file I'm accessing is a network file, do you think that would cause the problem? – ajs Jul 10 '14 at 14:37
2

I tried the same code and i ma getting following java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException. Please help me out if you have any clue – user1047873 Mar 27 '16 at 16:56
@user1047873 - Is xmlbeans-2.X.X.jar in your classpath? – NullPumpkinException May 25 '17 at 00:59

Read data from read only xlsm file using Java Apache POI

2 Answers2

Linked