So I've done a little bit of research into the issue, and it appears that when an item is a pulldown list in excel, the cell's "data validation" is set to "list". I can't figure out how to do that, or if it's even possible with POI. Any insights are welcome.
Thanks Seth -----Original Message----- From: Markle, Seth [mailto:[EMAIL PROTECTED] Sent: Thursday, April 06, 2006 3:24 PM To: poi-user@jakarta.apache.org Subject: Writing multi-values to an excel cell as a pulldown list I'd like to be able to create a spreadsheet with pulldown lists of values in its cells. I've looked at the Javadoc and the documentation on the POI homepage, but can't seem to find this use case addressed. Ideally, I'd do something like this psuedo-code: Collection list = new ArrayList(); list.add("foo"); List.add("bar"); myRow.addCell(list); Does anyone have any experience doing this? Thank you, Seth --- Seth Markle Software Development Engineer, Merchant Integration [EMAIL PROTECTED] --------------------------------------------------------------------- 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/