Hello everyone, I'm relatively new to POI, but I have some experience with Interop in C#. I need to update an open xls file multiple times and I'm doing so with the method workbook.write(outputstream). I don't close the stream after each write since that would force a reopening of the stream. The problem is that only the first write is visible in the file although the file size seems to indicate that all the data is present. At the end of the main method I close the stream. If I write the workbook at the end, then I can see all the data in the file. Allow me to give you an example:
cell.setCellValue(1.5); workbook.write(outputstream); ...... cell.setCellValue(3.5); workbook.write(outputstream); ...... outputstream.close(); Only the value 1.5 exists in the xls file. Thanks in advance for any input. -- View this message in context: http://www.nabble.com/Workbook-multiple-write%2C-single-outputstream-close-tp24337575p24337575.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
