Well, to answer part one of your question, Microsoft imposed limits when they designed that file format many, many years ago. Take a look here for the full list of limitations that apply to the older binary file format (.xls) - http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx. When Office 2007 was intorduced, a new file format appeared called OOXML (Office Open XML) and it has different limits - http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx. So, the answer to the first part of your question is to use the OOXML file format for your workbooks if you can.
Secondly, insertion of images is covered here - http://poi.apache.org/spreadsheet/quick-guide.html#Images, in the Quick Guide. Have you tried this yet? Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Max-column-size-and-image-in-sheetq-tp5709933p5709938.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]
