Using POI-3.5-beta5, I encounter the following exception when trying to open an XLS file exported by Google Spreadsheets:
org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance It's worth noting that OOo (2.4) and Microsoft Excel (2003) both open the file, but some information is lost. I guess I just wish POI would not bail out so soon. You can try with the following code on this sheet for example: https://spreadsheets.google.com/ccc?key=ph2LMSwBYdBh9UPblr0CvPw&hl=en ================================= import org.apache.poi.ss.usermodel.*; import java.io.*; public class TestPOI { public static void main(String[] args) { try { InputStream inp = new FileInputStream(args[0]); Workbook wb = WorkbookFactory.create(inp); } catch (Exception e) { System.err.println(e.toString()); } } } ================================= --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
