HSSFCellStyle problems... border style... background color...

2007-03-21 Thread cga
I develope a Java aplication, and try to export some data in MS Excel format using POI... I set HSSFCellStyle borders styles... generate the MS Excel but when I try to open Format Cell dlg (in MS Excell offcourse) that doesn't open... if I don't set border style, no problemo Another problem...

dynamic table

2007-03-21 Thread Paulo Alexandre Figueiredo Gonçalves
Hi ! Can I create a dynamic table with POI ? Example in the images (image 1 is source data, image 2 is result). I can do this in excel in menu Data-Tables and Dynamic Graphics Reports (menus translated from Portuguese, may not be exactly that). Thanks, Paulo Gonçalves

Re: POI-Ruby

2007-03-21 Thread Andrew C. Oliver
Why? Why not just compile with GCJ and then wrap that? Seems weird to go 3 techs deep... Also there are C utils for OLE and XLS. Check out open office and gnumeric...use those...doesn't make sense to use C-Ruby-POI Jeff Swensen wrote: I am attempting to write my own C wrapper for the POI

Re: POI-Ruby

2007-03-21 Thread Jeff Swensen
I might be stating my intention incorrectly. I have the relevant bits from poi-ruby compiled with gcj, and am attempting to wrap that myself instead of using SWIG. As far as open office and gnumeric, I have been unable to find a fully featured discrete library for writing XLS files from ruby on

Re: POI-Ruby

2007-03-21 Thread Andrew C. Oliver
Okay from Ruby on Linux...yes POI-ruby is probably your best option I thought you were doing from C on Linux Hopefully Avik is around and he can help... I'll ping him if he doesn't answer. Jeff Swensen wrote: I might be stating my intention incorrectly. I have the relevant bits from

Re: [POI- HSSF] Alignment issue in sizing the Cell automatically

2007-03-21 Thread Yegor Kozlov
Hi, The POI 3.0 RC1 can be downloaded from http://people.apache.org/~nick/POI-3.0-RC1/ HSSFSheet.autoSizeColumn was added after 12-Dec-2006. Try the latest jar. Regards, Yegor VK Hi all, VK I'm new to this group. I'm trying to generate MS Excel from my java code. VK I'ts