In an individual cell, 32767 characters is the Excel limit. It has nothing to do with POI but POI is rightly limiting so that you can't write a file that you can't read or will not be as intended.
XLS format: https://support.office.com/en-us/article/Excel-specifications-and-limits-16c69c74-3d6a-4aaf-ba35-e6eb276e8eaa?CorrelationId=001b704e-8d2f-494c-88de-6a035762ca14&ui=en-US&rs=en-US&ad=US XLSX format: https://support.office.com/en-au/article/Excel-specifications-and-limits-ca36e2dc-1f09-4620-b726-67c00b05040f Aram On Sat, May 23, 2015 at 11:17 PM, parthiprft <[email protected]> wrote: > Hi, > > I'm using poi 3.11 version, while writing a lengthy string to the cell it > throws illegal argument exception: maximum length of cell content is 32767 > in HSSFWorkbook. > > is there any alternative available to set a lengthy string to the cell. > > Thanks in advance! > > > Parthban > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/maximum-length-of-cell-content-is-32767-in-HSSFWorkbook-tp5718875.html > Sent from the POI - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
