ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel image help (https://www.excelbanter.com/excel-programming/437259-excel-image-help.html)

aphxps

excel image help
 
hello i need a bit of help programming the following problem in excel

the code is as follows

<Column ss:AutoFitWidth="0" ss:Width="15"/
<Column ss:AutoFitWidth="0" ss:Width="15"/
<Column ss:AutoFitWidth="0" ss:Width="15"/
<Column ss:Index="256" ss:AutoFitWidth="0" ss:Width="1.5"/


<Row ss:AutoFitHeight="0" ss:Height="30"
<Cell ss:MergeAcross="1" ss:StyleID="s40"<image href="C:\Documents and
Settings\andy holmes\My Documents\My
Pictures\andy_sgnature.JPG"</image<NamedCell
ss:Name="Print_Area"/</Cell



</Row
<Row ss:AutoFitHeight="0" ss:Height="100"
</Row
<Row ss:AutoFitHeight="0" ss:Height="100"
</Row


if i have this code for example what am i doing wrong to add a image the
file is in xml format

the file will be loaded into excel

for the life of me i cant figure out how excel places images in cells

thanks for any help u can give in advance

Paul C

excel image help
 
Excel does not place an image into the cell. Images float over a cell or
cells.

You will need to determine the cell, place the picture and resize the cell

In Excel 2003 and 2007 there are some differences

This previous thread addresses both

http://www.microsoft.com/office/comm...xp=&sloc=en-us



--
If this helps, please remember to click yes.


"aphxps" wrote:

hello i need a bit of help programming the following problem in excel

the code is as follows

<Column ss:AutoFitWidth="0" ss:Width="15"/
<Column ss:AutoFitWidth="0" ss:Width="15"/
<Column ss:AutoFitWidth="0" ss:Width="15"/
<Column ss:Index="256" ss:AutoFitWidth="0" ss:Width="1.5"/


<Row ss:AutoFitHeight="0" ss:Height="30"
<Cell ss:MergeAcross="1" ss:StyleID="s40"<image href="C:\Documents and
Settings\andy holmes\My Documents\My
Pictures\andy_sgnature.JPG"</image<NamedCell
ss:Name="Print_Area"/</Cell



</Row
<Row ss:AutoFitHeight="0" ss:Height="100"
</Row
<Row ss:AutoFitHeight="0" ss:Height="100"
</Row


if i have this code for example what am i doing wrong to add a image the
file is in xml format

the file will be loaded into excel

for the life of me i cant figure out how excel places images in cells

thanks for any help u can give in advance


Paul C

excel image help
 
my apologies, I posted an incomplete link.

This is the correct link

http://www.microsoft.com/office/comm...b-a613baecf864
--
If this helps, please remember to click yes.


"Paul C" wrote:

Excel does not place an image into the cell. Images float over a cell or
cells.

You will need to determine the cell, place the picture and resize the cell

In Excel 2003 and 2007 there are some differences

This previous thread addresses both

http://www.microsoft.com/office/comm...xp=&sloc=en-us



--
If this helps, please remember to click yes.


"aphxps" wrote:

hello i need a bit of help programming the following problem in excel

the code is as follows

<Column ss:AutoFitWidth="0" ss:Width="15"/
<Column ss:AutoFitWidth="0" ss:Width="15"/
<Column ss:AutoFitWidth="0" ss:Width="15"/
<Column ss:Index="256" ss:AutoFitWidth="0" ss:Width="1.5"/


<Row ss:AutoFitHeight="0" ss:Height="30"
<Cell ss:MergeAcross="1" ss:StyleID="s40"<image href="C:\Documents and
Settings\andy holmes\My Documents\My
Pictures\andy_sgnature.JPG"</image<NamedCell
ss:Name="Print_Area"/</Cell



</Row
<Row ss:AutoFitHeight="0" ss:Height="100"
</Row
<Row ss:AutoFitHeight="0" ss:Height="100"
</Row


if i have this code for example what am i doing wrong to add a image the
file is in xml format

the file will be loaded into excel

for the life of me i cant figure out how excel places images in cells

thanks for any help u can give in advance


aphxps

excel image help
 

those solutions are for visual basic i need a solution for xml code or java
would work also

"Paul C" wrote:

my apologies, I posted an incomplete link.

This is the correct link

http://www.microsoft.com/office/comm...b-a613baecf864
--
If this helps, please remember to click yes.


"Paul C" wrote:

Excel does not place an image into the cell. Images float over a cell or
cells.

You will need to determine the cell, place the picture and resize the cell

In Excel 2003 and 2007 there are some differences

This previous thread addresses both

http://www.microsoft.com/office/comm...xp=&sloc=en-us



--
If this helps, please remember to click yes.


"aphxps" wrote:

hello i need a bit of help programming the following problem in excel

the code is as follows

<Column ss:AutoFitWidth="0" ss:Width="15"/
<Column ss:AutoFitWidth="0" ss:Width="15"/
<Column ss:AutoFitWidth="0" ss:Width="15"/
<Column ss:Index="256" ss:AutoFitWidth="0" ss:Width="1.5"/


<Row ss:AutoFitHeight="0" ss:Height="30"
<Cell ss:MergeAcross="1" ss:StyleID="s40"<image href="C:\Documents and
Settings\andy holmes\My Documents\My
Pictures\andy_sgnature.JPG"</image<NamedCell
ss:Name="Print_Area"/</Cell



</Row
<Row ss:AutoFitHeight="0" ss:Height="100"
</Row
<Row ss:AutoFitHeight="0" ss:Height="100"
</Row


if i have this code for example what am i doing wrong to add a image the
file is in xml format

the file will be loaded into excel

for the life of me i cant figure out how excel places images in cells

thanks for any help u can give in advance



All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com