Need help reg dropdowns in Excel sheets

2007-02-25 Thread Anjishnu Bandyopadhyay
Hi all, I need to display a drop-down (with pre-defined values, that will be hard-coded in a List/ArrayList in my Java class) in one particular cell of an Excel sheet. Any pointers regarding this will be of great help. Thanks for your time. With best regards, Anjishnu.

Auto fit of cell values in MS Excel

2007-04-03 Thread Anjishnu Bandyopadhyay
Hi all, I am generating an MS Excel sheet through POI. For a column in the sheet, I am specifying a width by using the method setColumnWidth(). Now, if the content of the cell is more, then, portions of the value in the cell are hidden. Is it possible to break the contents to the next line

RE: Auto fit height of cell values in MS Excel

2007-04-04 Thread Anjishnu Bandyopadhyay
Hi all, Actually, I intend to make the height to fit the value of the cell. With best regards, Anjishnu. -Original Message- From: Anjishnu Bandyopadhyay [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 11:29 AM To: poi-user@jakarta.apache.org Subject: Auto fit

InvocationTargetException while reading an Excel file.

2007-05-03 Thread Anjishnu Bandyopadhyay
Hi all, I am trying to read a MS Excel file through my POI code. The file contains Filters, Macros Pivot tables. By trying to do so, I get an InvocationTargetException when I try to instantiate a new workbook, with an instance of POIFSFileSystem class. My code is something like:

Repost: InvocationTargetException while reading an Excel file.

2007-05-09 Thread Anjishnu Bandyopadhyay
Hi all, I am trying to read a MS Excel file through my POI code. The file contains Filters, Macros Pivot tables. By trying to do so, I get an InvocationTargetException when I try to instantiate a new workbook, with an instance of POIFSFileSystem class. My code is something like: