>> I can't find a constructor for HSSFWorkbook that accepts a 
>> NPOIFSFileSystem, only POIFSFileSystem.
>
>Pass in the directory root taken from a NPOIFSFileSystem, that's accepted

I've now got...

        System.out.println(new Date());
        NPOIFSFileSystem npoiFS = new NPOIFSFileSystem( new File("d:\\big n 
p.xls"));
        System.out.println(new Date());
        HSSFWorkbook wb = new HSSFWorkbook(npoiFS.getRoot(), true);
        System.out.println(new Date());
        Boolean check = wb. isWriteProtected();
        System.out.println(check);

However the HSSFWorkbook line is taking for ever to complete when I use a large 
XLS file.

I'm also no longer sure I'm using the correct test (isWiteProtected).  All I am 
looking for is to check that the workbook hasn't had a password added that 
prevents it being loaded/opened.



-----Original Message-----
From: Nick Burch [mailto:[email protected]] 
Sent: 12 September 2011 13:21
To: POI Users List
Subject: RE: How to check whether an XLSX has a read password

On Mon, 12 Sep 2011, Simmons, Tom (GE Oil & Gas, VG) wrote:
> I can't find a constructor for HSSFWorkbook that accepts a 
> NPOIFSFileSystem, only POIFSFileSystem.

Pass in the directory root taken from a NPOIFSFileSystem, that's accepted

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected] For additional 
commands, e-mail: [email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to