In that case, I would advise upgrading to the latest version of the API. The name may include the word 'beta' but many people are successfully using the codebase in production environments and it includes a number of enchancements and bug fixes that do not appear in 3.2 final.
If you visit this site; http://encore.torchbox.com/poi-svn-build/ you will be able to download the relevant archives. Currently, the site is down for maintenance so I cannot get a list of the actual name of the archive but scroll down the list and look for an entry similar to this; poi-3.5-beta7-20090721.jar If all you are using is HSSF then I think that the single archive is all that you will need. Some people are unhappy using beta code. If this is the case then you do have a possible workaround; just create a 'template' file using Excel. Place the image where you want on the worksheet using Excel then save the file away so that you can later open it again using HSSF to populate the worksheet with data. Yours Mark B deep4u wrote: > > Hi, > Thanks for your reply, but i didn't find that constants in > HSSFClientAnchor class. I have to use the poi 3.2 jars. How come it to > resolve. > > Thanks, > Deepu > Usually, when you add an image to a sheet, you pass an instance of the > HSSFClientAnchor class and I think that you need to set the type of the > anchor appropriately. Not too sure about which one would be best but I > reckon that either HSSFClientAnchor.DONT_MOVE_AND_RESIZE or > HSSFClientAnchor.MOVE_DONT_RESIZE would probably be what you are after. > All you would need to do is call the setAnchorType() method on the > HSSFClientAnchor object and pass either of these two constants. > > Yours > > Mark B > > > deep4u wrote: >> >> Hello, >> I am new to this Library. Its working great, 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? >> >> >> >> > > -- View this message in context: http://www.nabble.com/autosize-in-Excel-irrespetive-of-image-tp24604961p24620234.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]
