How to solve this error:Row number must be between 0 and 65535, was <65536>


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How to solve this error:Row number must be between 0 and 65535, was <65536>

Hybrid View

  1. #1
    Join Date
    May 2009
    Posts
    1

    How to solve this error:Row number must be between 0 and 65535, was <65536>

    Hi,

    Iam generating an excel report which retrieves the data from SQL database and displays in the excel sheet.

    FYI, Iam using WSAD and the framework is a Struts framework.

    Likewise, an excel sheet is generated, which results in an error:
    java.lang.IndexOutOfBoundsException: Row number must be between 0 and 65535, was <65536>

    Can anyone please help me solve this exception?

    Is there any relation to the POI jar which Iam using?
    Iam using the jar poi-3.0.2-FINAL-20080204.jar

    Thanks & Regards,
    Balmu

  2. #2
    Join Date
    Jul 2005
    Posts
    78
    Looks like you can only have 65535 rows in your excel spreadsheet.

    You'll need to organise things so you get less than that, or to start importing into a new sheet when you fill one up.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center