I can't get POI to open this
http://sik.dk/var/storage/elinstallatoerregister.xls
Tried different versions. Latest 3.5 beta 5.
Excel can open the file.
Is there any way I can get POI to open this?
java.io.IOException: block[ 0 ] already removed - does your POIFS have circular
or duplicate block references?
at
org.apache.poi.poifs.storage.BlockListImpl.remove(BlockListImpl.java:97)
at
org.apache.poi.poifs.storage.BlockAllocationTableReader.fetchBlocks(BlockAllocationTableReader.java:196)
at
org.apache.poi.poifs.storage.BlockListImpl.fetchBlocks(BlockListImpl.java:132)
at
org.apache.poi.poifs.filesystem.POIFSFileSystem.processProperties(POIFSFileSystem.java:538)
at
org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:176)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:317)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:298)
at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:59)
at
dk.scoutconsult.sik.hssf.ImportInstallatoer.main(ImportInstallatoer.java:12)
public static void main(String[] args) {
try {
URL url = new
URL("http://sik.dk/var/storage/elinstallatoerregister.xls";);
InputStream is = url.openConnection().getInputStream();
org.apache.poi.ss.usermodel.Workbook wb =
org.apache.poi.ss.usermodel.WorkbookFactory.create(is);
}
catch (Exception ex){
ex.printStackTrace();
}
}
Christian S. Junker
Service Konsulent
[email protected]
Mob: +45 61 61 11 44
............................................
Informi GIS A/S, Hovedkontor
Jægersborg Allé 4, DK-2920 Charlottenlund
tlf. +45 39 96 59 00, fax. +45 39 96 59 34, http://www.informi.dk
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
