Do you have formulas in the excel? XLS2CSVmra uses the MissingRecordAwareHSSFListener, and I found that sometimes reports a end of line inside the formula, leading to empty lines.
Gabriel "tom corcoran" <[EMAIL PROTECTED]> 06/23/2008 04:28 PM CETPlease respond to"POI Users List" To [email protected] cc bcc Subject Blank lines added when outputting csv? Using the XLS2CSVmra demo as is: http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java I output this excel file http://www.filedropper.com/book2_1 and it contains a number of blank lines before the last line. If I delete any line from the excel sheet and then output it to csv, the blank lines return. Does anyone have an explanation? Thanks, Tom. =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
