Re[2]: problems with POI build
I use JDK 1.4.2 and JDK 1.5. To build POI users need JDK 1.4 or greater. It should be reflected it the docs somehow. Compilation under JDK 1.3 fails. I've just tried it and got 68 errors. Does it concerns you? Yegor AO> Which JDK? AO> Yegor Kozlov wrote: >> Hi, >> >> I don't quite understand what's wrong with POI. I'm using Ant 1.6.2 >> and it works fine for me. >> >> POI build.xml is all-sufficient. It downloads the required jars if >> they are missing. No intervention in Ant's config is required. >> >> Regards, >> Yegor >> LS> Has anyone tested this with a newer version of ANT other than 1.5.3? >> >> >> >> >> >> LS> >> >> LS> From: Levi Strope [mailto:[EMAIL PROTECTED] >> LS> Sent: Tuesday, March 20, 2007 11:07 AM >> LS> To: poi-user@jakarta.apache.org >> LS> Subject: problems with POI build >> >> >> >> LS> I'm using ANT 1.7 and there is no optional.jars - has anyone worked >> LS> through this before? >> >> >> >> LS> Additionally - I did include all required .JARS per the 'How to Build' >> LS> instructions - but I get an error telling me org.apache.xalan does not >> LS> exist. It doesn't exist but I did include it in %ANT_HOME%/lib so I'm >> LS> not sure what I need to do. >> >> >> - >> 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/ >> AO> - AO> To unsubscribe, e-mail: [EMAIL PROTECTED] AO> Mailing List: http://jakarta.apache.org/site/mail2.html#poi AO> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ - 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/
Sheet background
Hi, Please tell me how can I set the background of a sheet. I'm using 2.5.1 version of POI. Thanks. Best regards, Rodica 8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime shortcut. http://tools.search.yahoo.com/shortcuts/#news - 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/
Re: problems with POI build
Which JDK? Yegor Kozlov wrote: Hi, I don't quite understand what's wrong with POI. I'm using Ant 1.6.2 and it works fine for me. POI build.xml is all-sufficient. It downloads the required jars if they are missing. No intervention in Ant's config is required. Regards, Yegor LS> Has anyone tested this with a newer version of ANT other than 1.5.3? LS> LS> From: Levi Strope [mailto:[EMAIL PROTECTED] LS> Sent: Tuesday, March 20, 2007 11:07 AM LS> To: poi-user@jakarta.apache.org LS> Subject: problems with POI build LS> I'm using ANT 1.7 and there is no optional.jars - has anyone worked LS> through this before? LS> Additionally - I did include all required .JARS per the 'How to Build' LS> instructions - but I get an error telling me org.apache.xalan does not LS> exist. It doesn't exist but I did include it in %ANT_HOME%/lib so I'm LS> not sure what I need to do. - 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/ - 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/
RE: Re[2]: problems with POI build
Then I think the problem may be with Eclipse 3.2. In Eclipse 3.2 if I follow the build instructions the ANT build script errors out every time because the directories it is looking for do not exist. I manually created the directories but I'm still unable to get past the error that says org.apache.xalan does not exist. In my situation I've had to place a lot of these files manually, but no matter what I do this still causes problems. Could it be the version of xalan that I am pulling down? I believe the version was 2.7. -Original Message- From: Yegor Kozlov [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 12:59 PM To: POI Users List Subject: Re[2]: problems with POI build Hi, I don't quite understand what's wrong with POI. I'm using Ant 1.6.2 and it works fine for me. POI build.xml is all-sufficient. It downloads the required jars if they are missing. No intervention in Ant's config is required. Regards, Yegor LS> Has anyone tested this with a newer version of ANT other than 1.5.3? LS> LS> From: Levi Strope [mailto:[EMAIL PROTECTED] LS> Sent: Tuesday, March 20, 2007 11:07 AM LS> To: poi-user@jakarta.apache.org LS> Subject: problems with POI build LS> I'm using ANT 1.7 and there is no optional.jars - has anyone worked LS> through this before? LS> Additionally - I did include all required .JARS per the 'How to Build' LS> instructions - but I get an error telling me org.apache.xalan does not LS> exist. It doesn't exist but I did include it in %ANT_HOME%/lib so I'm LS> not sure what I need to do. - 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/ - 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/
Re: [POI- HSSF] Alignment issue in sizing the Cell automatically
Thanks Yegor,
Its working great, but getting another alignment issue with this,
i used logo (image) in the excel sheet. with the auto sizing the image also
expanding and contracting according to that column data.
Can i keep the image irrespective of the column size?
Here is the code that i used to insert the image..
___
HSSFRow headerRow = sheet.createRow((short)0);
sheet.addMergedRegion(new Region(0,(short)0,1,(short)6));
//Displaying Logo
byte[] picData = null;
File pic = new File("C:\\images\\excelLogo.jpeg");
long length = pic.length();
picData = new byte[(int) length];
FileInputStream picIn;
picIn = new FileInputStream(pic);
picIn.read(picData);
int index = workbook.addPicture(picData,
HSSFWorkbook.PICTURE_TYPE_JPEG);
HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
HSSFClientAnchor anchor = new
HSSFClientAnchor(0,0,0,255,(short)0,0,(short)1,1);
HSSFSimpleShape shape = patriarch.createPicture(anchor,index);
shape.setShapeType(HSSFSimpleShape.OBJECT_TYPE_PICTURE);
_
Please help me in this regard,
Thanks,
Vinay
On 3/21/07, Yegor Kozlov <[EMAIL PROTECTED]> wrote:
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 working great, but i have some alignment issue like the width of
the
VK> cell is not enough to fit the text.
VK> i.e the cell width is not good enough to view the text that is
displaying.
VK> I need to set the width size automatic (i.e something like AutoFit
option)
VK> i.e the cell width should be set to max length of text value in that
column.
VK> I walked through api of HSSF (poi) but i dont find any method to set
the
VK> autoSize of the Column
VK> i have latest jar of poi-bin-3.0-alpha3-20061212 (12-Dec-2006)
VK> I have seen in couple of places that new method called
"autoSizeColumn()"
VK> was added, but i don't see even in alpha build, is there any other
build
VK> lately,
VK> Please provide me the link to download the latest jar of POI.
VK> Any Suggestions will be appreciated .
VK> Looking for any kind of help, i was in little bit urgency.
VK> Thanks,
VK> Vinay
-
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/
Re[2]: problems with POI build
Hi, I don't quite understand what's wrong with POI. I'm using Ant 1.6.2 and it works fine for me. POI build.xml is all-sufficient. It downloads the required jars if they are missing. No intervention in Ant's config is required. Regards, Yegor LS> Has anyone tested this with a newer version of ANT other than 1.5.3? LS> LS> From: Levi Strope [mailto:[EMAIL PROTECTED] LS> Sent: Tuesday, March 20, 2007 11:07 AM LS> To: poi-user@jakarta.apache.org LS> Subject: problems with POI build LS> I'm using ANT 1.7 and there is no optional.jars - has anyone worked LS> through this before? LS> Additionally - I did include all required .JARS per the 'How to Build' LS> instructions - but I get an error telling me org.apache.xalan does not LS> exist. It doesn't exist but I did include it in %ANT_HOME%/lib so I'm LS> not sure what I need to do. - 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/
Re: POI-Ruby
I'm working on getting the SWIG included version running. I had to edit the Makefile to set some paths (GCJ_HOME, SWIG) to point to the compatible versions and everything compiles correctly. The problem is: irb(main):001:0> require 'release/poi4r' LoadError: libgcj.so.7: cannot open shared object file: No such file or directory - /home/jswensen/poi/trunk/src/contrib/poi-ruby/release/poi4r.so from /home/jswensen/poi/trunk/src/contrib/poi-ruby/release/poi4r.so from (irb):1 I have the path to libgcj.so.7 included in my RUBYLIB variable so I'm at a loss for what the issue is. Any ideas? Jeff Swensen wrote: > I am attempting to write my own C wrapper for the POI Ruby bindings and > am looking for some guidance. I compiled poi4r using the swig wrapper > only to result in a segfault which I'm unable to track down. It also > seems that swig generates a lot of unnecessary bloat while creating the > wrapper, which is why I decided to try to replace it with my own version > (also partly due to some feedback from my boss who seems to dislike swig > quite a bit). > > Are there any resources you could point me to for writing the ruby > interface? I understand that at the most basic level I need to define > all of the Java classes and public methods, but after that I'm at a > loss. I've tried googling but I can't find any examples of writing a c > extension to wrap compiled java for ruby. > > Thanks, > Jeff > > > - > 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/ > > -- Jeffery S. Swensen Software Engineer Merrill Lextranet Legal Computer Solutions, Inc. 107 Union Wharf Boston, MA 02109 t. 617-227-4469 x234 [EMAIL PROTECTED] THE INFORMATION IN THIS MESSAGE IS INTENDED ONLY FOR THE PERSONAL AND CONFIDENTIAL USE OF THE DESIGNATED RECIPIENTS NAMED ABOVE AND MAY CONTAIN LEGALLY PRIVILEGED INFORMATION. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error, and that any review, dissemination, distribution or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by telephone at 617-227-4469 Ext. 200. Thank you. - 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/
RE: problems with POI build
Has anyone tested this with a newer version of ANT other than 1.5.3? From: Levi Strope [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 20, 2007 11:07 AM To: poi-user@jakarta.apache.org Subject: problems with POI build I'm using ANT 1.7 and there is no optional.jars - has anyone worked through this before? Additionally - I did include all required .JARS per the 'How to Build' instructions - but I get an error telling me org.apache.xalan does not exist. It doesn't exist but I did include it in %ANT_HOME%/lib so I'm not sure what I need to do. - 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/
Re: POI-Ruby
My mistake, I'm using 1.3.31. Jeff Swensen wrote: > Thanks for the responses. > > Avik, > > What version of SWIG has worked the best for you? The version installed > here is 1.1 (patch 5). I see that is the most recent stable release. > > Thanks, > Jeff > > Avik Sengupta wrote: > >> Jeff >> >> You can certainly wrap stuff on your own, but I would figure it will be a >> lot >> of work, which is reason I started on swig. I wouldnt start on it unless you >> either have a lot of time, or some significant experience writing C >> extensions for ruby (neither of which is true for me) >> >> You'l have to declare the function signatures to call from ruby, convert >> objects (eg ruby strings to gcj string objects) and handle memory allocation >> and de-allocation on either side. Both ruby and java being garbage >> collected, >> not only will you have to worry about leaks, but also premature collection. >> >> http://www.rubycentral.com/book/ext_ruby.html has the basics. You've >> probably already seen this. >> >> With swig, you still have to worry about all this, but a lot of the >> boilerplate is generated. For eg, you'll have to write the object wrapping >> code once, and not worry about calling it every time an object is >> referenced. >> >> As for segfaults, the whole thing, i've found, is quite sensitive to swig >> version. Maybe you can try with an older swig version? >> >> Regards >> - >> Avik >> >> >> >> >> >> >> On Thursday 22 Mar 2007 3:03:11 am Andrew C. Oliver wrote: >> >> >>> 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 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 linux. Would be most appreciative if you could point me to one. Andrew C. Oliver wrote: > 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 Ruby bindings and >> am looking for some guidance. I compiled poi4r using the swig wrapper >> only to result in a segfault which I'm unable to track down. It also >> seems that swig generates a lot of unnecessary bloat while creating the >> wrapper, which is why I decided to try to replace it with my own >> version (also partly due to some feedback from my boss who seems to >> dislike swig quite a bit). >> >> Are there any resources you could point me to for writing the ruby >> interface? I understand that at the most basic level I need to define >> all of the Java classes and public methods, but after that I'm at a >> loss. I've tried googling but I can't find any examples of writing a c >> extension to wrap compiled java for ruby. >> >> Thanks, >> Jeff >> >> >> - >> 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/ >> >> - 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/ >> >> - >> 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/ >> >> >> > > -- Jeffery S. Swensen Software Engineer Merrill Lextranet Legal Computer Solutions, Inc. 107 Union Wharf Boston, MA 02109 t. 617-227-4469 x234 [EMAIL PROTECTED] THE INFORMATION IN THIS MESSAGE IS INTENDED ONLY FOR THE PERSONAL AND CONFIDENTIAL USE OF THE DESIGNATED RECIPIENTS NAMED ABOVE AND MAY CONTAIN LEGALLY PRIVILEGED INFORMATION. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error, and that any review, dissemination, distribution or copying of this message is strictly prohibited. If you ha
Re: POI-Ruby
Thanks for the responses. Avik, What version of SWIG has worked the best for you? The version installed here is 1.1 (patch 5). I see that is the most recent stable release. Thanks, Jeff Avik Sengupta wrote: > Jeff > > You can certainly wrap stuff on your own, but I would figure it will be a lot > of work, which is reason I started on swig. I wouldnt start on it unless you > either have a lot of time, or some significant experience writing C > extensions for ruby (neither of which is true for me) > > You'l have to declare the function signatures to call from ruby, convert > objects (eg ruby strings to gcj string objects) and handle memory allocation > and de-allocation on either side. Both ruby and java being garbage collected, > not only will you have to worry about leaks, but also premature collection. > > http://www.rubycentral.com/book/ext_ruby.html has the basics. You've > probably already seen this. > > With swig, you still have to worry about all this, but a lot of the > boilerplate is generated. For eg, you'll have to write the object wrapping > code once, and not worry about calling it every time an object is referenced. > > As for segfaults, the whole thing, i've found, is quite sensitive to swig > version. Maybe you can try with an older swig version? > > Regards > - > Avik > > > > > > > On Thursday 22 Mar 2007 3:03:11 am Andrew C. Oliver wrote: > >> 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 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 linux. >>> Would be most appreciative if you could point me to one. >>> >>> Andrew C. Oliver wrote: >>> 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 Ruby bindings and > am looking for some guidance. I compiled poi4r using the swig wrapper > only to result in a segfault which I'm unable to track down. It also > seems that swig generates a lot of unnecessary bloat while creating the > wrapper, which is why I decided to try to replace it with my own > version (also partly due to some feedback from my boss who seems to > dislike swig quite a bit). > > Are there any resources you could point me to for writing the ruby > interface? I understand that at the most basic level I need to define > all of the Java classes and public methods, but after that I'm at a > loss. I've tried googling but I can't find any examples of writing a c > extension to wrap compiled java for ruby. > > Thanks, > Jeff > > > - > 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/ > >>> - >>> 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/ >>> > > > > - > 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/ > > -- Jeffery S. Swensen Software Engineer Merrill Lextranet Legal Computer Solutions, Inc. 107 Union Wharf Boston, MA 02109 t. 617-227-4469 x234 [EMAIL PROTECTED] THE INFORMATION IN THIS MESSAGE IS INTENDED ONLY FOR THE PERSONAL AND CONFIDENTIAL USE OF THE DESIGNATED RECIPIENTS NAMED ABOVE AND MAY CONTAIN LEGALLY PRIVILEGED INFORMATION. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error, and that any review, dissemination, distribution or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by telephone at 617-227-4469 Ext. 200. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.
Re: POI-Ruby
Jeff You can certainly wrap stuff on your own, but I would figure it will be a lot of work, which is reason I started on swig. I wouldnt start on it unless you either have a lot of time, or some significant experience writing C extensions for ruby (neither of which is true for me) You'l have to declare the function signatures to call from ruby, convert objects (eg ruby strings to gcj string objects) and handle memory allocation and de-allocation on either side. Both ruby and java being garbage collected, not only will you have to worry about leaks, but also premature collection. http://www.rubycentral.com/book/ext_ruby.html has the basics. You've probably already seen this. With swig, you still have to worry about all this, but a lot of the boilerplate is generated. For eg, you'll have to write the object wrapping code once, and not worry about calling it every time an object is referenced. As for segfaults, the whole thing, i've found, is quite sensitive to swig version. Maybe you can try with an older swig version? Regards - Avik On Thursday 22 Mar 2007 3:03:11 am Andrew C. Oliver wrote: > 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 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 linux. > > Would be most appreciative if you could point me to one. > > > > Andrew C. Oliver wrote: > >> 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 Ruby bindings and > >>> am looking for some guidance. I compiled poi4r using the swig wrapper > >>> only to result in a segfault which I'm unable to track down. It also > >>> seems that swig generates a lot of unnecessary bloat while creating the > >>> wrapper, which is why I decided to try to replace it with my own > >>> version (also partly due to some feedback from my boss who seems to > >>> dislike swig quite a bit). > >>> > >>> Are there any resources you could point me to for writing the ruby > >>> interface? I understand that at the most basic level I need to define > >>> all of the Java classes and public methods, but after that I'm at a > >>> loss. I've tried googling but I can't find any examples of writing a c > >>> extension to wrap compiled java for ruby. > >>> > >>> Thanks, > >>> Jeff > >>> > >>> > >>> - > >>> 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/ > > > > - > > 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/ - 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/
