I guess there could be many possible causes, but just in case someone has an idea about this........
In POI 1.10.0, I read in an xls template, and using POI API I create/write a moderately large xls file of size 420 KB. This is a spreadsheet which I expect to have about 18,000 rows and 5 columns. Some cells have borders and some cells are colored and shaded. If I try to open this xls file in Excel 97 on my PC, I get the popup window message: "Unable to read file." When the data is less, there is no problem opening the resulting xls file on my PC. What does that indicate? What am I doing wrong, possibly? I can create a 6000 KB spreadsheet in Excel, with 65000 rows, save it and open it in Excel with no problem. QUESTIONS: Pehaps I don't understand some basics. When I read in a template xls file and add new rows to it, I assume that I can, for example, add a new row 27 and then add a new row 29, without doing anything with row 28. Thus, row 28 is not created in POI API, but it will exist in the new xls file. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
