Hi mark,
when u free send me the code.
Thanks,
MSB wrote:
>
> The image ought to be fine. Using Excel, it is possible to set the same
> sort of properties that you can with POI, i.e. that the image should not
> move or resize itself with the cells. To do this using 'my' version of
> Excel, you select the image on the worksheet and click on the right hand
> mouse button; this pops open a menu from which you can select the 'Size
> and Properties' option. The options screen that appears in response to
> this has a number of tabs on it. One of them is labelled 'Properties' and
> selecting this allows you to say how the image should respond to resizing
> of the cells. I would select the 'Don't move or size with cells' option.
> Then the image ought to remain tha same size irrespective of what you do
> with the columns or rows.
>
> If you are in no hurry, I can put together some code later today to test
> this hypothesis and then post the results to you. Sadly, I have to leave
> in about an hour to help a group of volunteers construct a flight of steps
> linking two footpaths together - which should be fun given the weather
> forecast today - but should be able to get some code together this
> evening.
>
> Yours
>
> Mark B
>
>
> deep4u wrote:
>>
>> Hi mark,
>> I need to create a excel dynamically means based On weekly,
>> Monthly, suppose this is current week so 07/24/09-07/31/09,...next based
>> on months july month the name excelsheet will be "july.xls" , and next
>> nonth "August.xls"... If i taking a template ok but in my program i will
>> set autosize on that no streched the image?
>>
>> Thanks,
>>
>>
>> MSB wrote:
>>>
>>> You need to do the following;
>>>
>>> Start Excel
>>> If necessary, open a new workbook - Excel usually opens up with a new,
>>> empty workbook so this may not be necessary.
>>> Select Insert->Picture and navigate your way to where the logo image is
>>> stored. Select (highlight) the image and then click on the Insert
>>> button.
>>> Now, you should see that the logo has been inserted into the worksheet
>>> and you can use the mouse to drag it into the correct location and
>>> re-size it as necessary.
>>> Save the file away and remember where you stored it and the name you
>>> used.
>>>
>>> That has created the template that you will pick up using POI and
>>> populate with data. All you need to do is something like this;
>>>
>>> File file = new File("..Path to and name of the file you created
>>> above..");
>>> FileInputStream fis = new FileInputStream(file);
>>> HSSFWorkbook workbook = new HSSFWorkbook(fis);
>>> HSSFSheet sheet = workbook.getSheetAt(0);
>>>
>>> and when you have your sheet, populate it in the usual manner and then
>>> save the completed workbook away again, most likely using a different
>>> name so that the template can be used again and again as the basis for
>>> further documents. It is common to see users do this sort of thing as
>>> POI's image manipulation facilities are not quite as feature rich as are
>>> Excel's.
>>>
>>> Hope that helps. If it is not clear, I will create a template and some
>>> code that picks it up and populates it and PM both to you; just let me
>>> know.
>>>
>>> Yours
>>>
>>> Mark B
>>>
>>>
>>> deep4u wrote:
>>>>
>>>> Hi mark,
>>>> I need to create Excel sheet dynamically with logo. But
>>>> using Template how it is possible.
>>>>
>>>> Thanks,
>>>>
>>>>
>>>> MSB wrote:
>>>>>
>>>>> So, setting the anchor type does not solve the problem?
>>>>>
>>>>> In that case, I think that your only recourse is to create a document
>>>>> template using Excel and to place the logo onto the document with it.
>>>>> Then you should be able to safely use HSSF/XSSF to populate the
>>>>> worksheet.
>>>>>
>>>>> Yours
>>>>>
>>>>> Mark B
>>>>>
>>>>>
>>>>> deep4u wrote:
>>>>>>
>>>>>> Hi,
>>>>>> i use the poi 3.5 also image will be expanding. I write like this
>>>>>> anchor.setAnchorType(HSSFClientAnchor.DONT_MOVE_AND_RESIZE);
>>>>>> or anchor.setAnchorType(3); how to reslove this.
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>>
>>>>>> 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-tp24604961p24718085.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]
