Discussions

Web tier: servlets, JSP, Web frameworks: JSP to excel error

  1. JSP to excel error (4 messages)

    Hi,
    I am sending the data from jsp to excel. When I try to open the saved excel file,excel pops up the error message saying

    HTML Import Errors
    Problems came up in the following areas during load
    Cell data too large


    And then the file opens with all the data messed up.

    How do I fix this issue?
    Thanks

    Threaded Messages (4)

  2. JSP to excel error[ Go to top ]

    I find that the easiest way to get information into Excel is to save data as a tab-delimited file with the .xls extension. Maybe you should drop the HTML code.
  3. JSP to excel error[ Go to top ]

    use XML or jxl.jar
  4. jsp to excel transfer of data[ Go to top ]

    hello friends is there any one who can help me out of this problem
    i want to transfer my data from my oracle database to excel file, is
    there any way or not plz help me to solve this problem
    thanks i adva my email id is gohilumesh@hotmail.com
  5. a <table> tag is to blame[ Go to top ]

    Problems came up in the following areas during load

    > Cell data too large
    > And then the file opens with all the data messed up.

    I got this error, but it says "HTML ERROR in Cell data too large" (Excel 2000).
    The reason is a <table> tag in a cell text. Stupid excel tries to interpret the <table> tag. I suppose you need to escape (mangle) such tags somehow, eg turn them into "[table]".

    My file is named TDV and is tab-delimited. But whether you name the file TXT or XLS makes no difference. I haven't tried with CSV.

    > use XML

    Maybe the guy is right: if Excel is so brazen as to try to interpret our plain text as <table>, we should play by its stupid rules and do XML. But for now, I'll try to disable its stupid interpretation of <table>.