First post. Here goes… I have exported some xls and xlsx files from our cm system. They export fine and I can open and view them in excel.
I created programs in Eclipse to read the files using both hssf and xssf. Some of the files process ok and I can see the contents. Other files do not process. The files are not very large (all less than 100kb). Even though a spreadsheet contains rows the sheet.getlastrownumber returns zero. I get NO errors but it’s as if the spreadsheet was empty. If I copy the entire contents of the worksheet to an new spreadsheet then that spreadsheet will process correctly. Has anyone come across this? Thanks. Mike ________________________________ Confidentiality Notice: The information contained in this electronic e-mail and any accompanying attachment(s) is intended only for the use of the intended recipient and is confidential and/or privileged. If you and we have a confidentiality agreement or other non-disclosure obligations between us, this Notice shall be deemed to mark and identify the content of this email and any attachments as confidential and proprietary. If any reader of this communication is not the intended recipient, unauthorized use, disclosure or copying is strictly prohibited, and may be unlawful. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete the original message and all copies from your system. Thank you. IRS Circular 230 Disclosure: To ensure compliance with requirements imposed by the IRS, please be advised that any U.S. federal tax advice contained in this communication (including any attachments) is not intended or written to be used or relied upon, and cannot be used or relied upon, for the purpose of (i) avoiding penalties under the Internal Revenue Code, or (ii) promoting, marketing or recommending to another party any transaction or matter addressed herein. E-mail is susceptible to data corruption, interception, unauthorized amendment, tampering and viruses, and we only send and receive e-mails on the basis that we are not liable for any such corruption, interception, amendment, tampering or viruses or any consequences thereof.
