Thanks for the reply. there are no formulas in the spreadsheet I believe, just basic data. [btw, it can be downloaded at http://www.filedropper.com/book2_1]
Tom. On Tue, Jun 24, 2008 at 1:05 AM, Gabriel Claramunt < [EMAIL PROTECTED]> wrote: > 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] > >
