Results 1 to 2 of 2
  1. #1
    amitbajpai is offline Member
    Join Date
    Apr 2014
    Rep Power

    Default Unreadable content when creating xlsx file using Apache POI

    I am getting the below message when opening a xlsx file generated through Apache POI.

    "We found a problem with some content in "workbook.xlsx". Do you want to try to recover as much as we can? If you trust the source of this workbook. click Yes"

    If we click yes the excel is recovered but all the validation are removed and I am getting this message "Repaired Part: /xl/worksheets/sheet1.xml part with XML error. Load error. Line 2, column 0."

    Attached is the code snippet which I am using.

    Can you someone help me here
    Attached Files Attached Files

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Rep Power

    Default Re: Unreadable content when creating xlsx file using Apache POI

    Please post code in the thread, but only relevant code.
    Make sure you wrap it in [code] tags [/code] so it retains its formatting.

    Since it seems to be the validation part that's causing Excel problems then I would focus on that. Give an example of what you are adding to the workbook that covers validation.

    Note, don't just dump a mass of code here and expect us to read through it to find the problem.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. Replies: 0
    Last Post: 01-28-2014, 06:50 AM
  2. Illegal xml character breakes .xlsx file
    By nmirra in forum Apache POI
    Replies: 1
    Last Post: 04-23-2013, 10:58 AM
  3. Replies: 0
    Last Post: 12-09-2012, 10:51 PM
  4. save XML file as .xlsx
    By prutser in forum Apache POI
    Replies: 2
    Last Post: 04-23-2012, 11:51 AM
  5. Unreadable socket data
    By vishrut_n_shah in forum Networking
    Replies: 1
    Last Post: 11-09-2011, 04:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts