Hi, Can you share such a file that is not working?
Sounds like your CM system exports files in a slightly different or non-standard way which seems to not break in Excel, but breaks POI... Dominik. On Fri, Sep 26, 2014 at 1:33 AM, Michael Guerrero <[email protected]> wrote: > 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. > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
