Ah, I misunderstood your post and I guess that both of your current questions really relate to the same issue; this is not a criticism, just an observation by the way.
If that is the case, then I would still suggest updating the version of POI that you are using so that you can test out the effects of the HSSFCleintAnchor constants we discussed in your other post. Then, if that still does not do what you want, try basing your file upon a template (a spreadsheet file you have created using Excel) that already contains the logo correctly positioned and aligned. Excel allows you to control images more precisely than does POI; the problems really arise because images float over the surface of the worksheet, they are not actually inserted into a cell. Many users of the API start with a template that contains macros or images for example and then use POI to build their worksheets and it is a techniques that seems to work quite well. Hopefully if the image already exists on the sheet then auto-sizing the column will have little or no effect upon it. Yours Mark B deep4u wrote: > > Hello, > I am new to this. In my application i generate Excel Sheet using > apache poi. Its working fine. but my requirement is i set the autosize to > 1st coulmn in that no need of some cells. For this how can we > implement,please share your ideas. > > Regards, > Deepu > -- View this message in context: http://www.nabble.com/autosize-in-Excel-tp24604780p24639392.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]
