Thanks. I have a sample xlsx file that does not process. Sorry, but how can I share the file? I did not think it was allow to attach files here.
Mike On 9/26/14, 2:20 AM, "Dominik Stadler" <[email protected]> wrote: >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] > > > >------------------------------------------------------------- >Mail1 junk filter. >Click here >http://mail1.tachyon.net:5272/FrontController?operation=mbeu&f=00001_-48_2 >0140926_3084250.eml&chkBayesian=1&pr=1&mt=1&ma=s to mark email as junk. >------------------------------------------------------------- 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]
