DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=16488>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=16488 Unable to open written spreadsheet in Excel, but can in Open Office Summary: Unable to open written spreadsheet in Excel, but can in Open Office Product: POI Version: unspecified Platform: PC OS/Version: Windows NT/2K Status: NEW Severity: Major Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] Overview Description: Using a template spreadsheet, I add data to the spreadsheet, but am then unable to open it in Excel 97SR2: Dialogue box error "unmable to read file" . I can open it in OpenOffice 1.0.1. Steps to Reproduce: small example program and template is attached Detail: I am attempting to read in a template file, add a bunch of data and then write it out to a new file. This works fine under OpenOffice, I can open the generated file in sheet with no problems. Using Excel though, I find that it will not open, giving the error dialogue box: Unable to read file" I'm using: POI version 1.9.0-dev-2003-122 Excel 97Sr2 OpenOffice 1.0.1 Java - IBM SDK 1.3 The code I am running is adapted from the quick start developers pages: I get the POIFSFileSystem from the template Excel xls file, grab the correct sheet in the workbook and write the data. I then use the write method on HSSFWorkbook to write out the new POIFSFileSystem. The template (input) spreadsheet has the following Entry objects in the POIFSFileSystem: found Entry: Workbook found Entry: DocumentSummaryInformation found Entry: SummaryInformation found Entry: CompObj found Entry: _VBA_PROJECT_CUR The output file has matching entries, so I am assuming that nothing is missing. The Excel files are to be used as described here: http://www.doh.gov.uk/bulkloading.htm -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
