Worksheet::mergeCells (Previous) (Next) Worksheet::setOutline
View this page in Last updated: Mon, 02 Jul 2007
English | Dutch | French | German | Hungarian | Japanese | Polish | Russian | Spanish | Plain HTML

Worksheet::insertBitmap

Worksheet::insertBitmap -- Insert a 24bit bitmap image in a worksheet. The main record required is

Referentiesamenvatting

require_once "Spreadsheet/Excel/Writer.php";

void Worksheet::insertBitmap (integer $row, integer $col, string $bitmap [, integer $x=0 [, integer $y=0 [, integer $scale_x=1 [, integer $scale_y=1]]]])

Beschrijving

Insert a 24bit bitmap image in a worksheet. The main record required is IMDATA but it must be proceeded by a OBJ record to define its position.

Parameter

  • integer $row - The row we are going to insert the bitmap into

  • integer $col - The column we are going to insert the bitmap into

  • string $bitmap - The bitmap filename

  • integer $x - The horizontal position (offset) of the image inside the cell.

  • integer $y - The vertical position (offset) of the image inside the cell.

  • integer $scale_x - The horizontal scale

  • integer $scale_y - The vertical scale

Note

Deze functie kan niet statisch worden aangeroepen.

Voorbeeld

Voorbeeld 39-1. Using insertBitmap()


 

  
   Worksheet::mergeCells (Previous)
  
  
(Next) Worksheet::setOutline
  
 

 

     
  		
 

 

  
   

    

     
Download Documentation
     
     Last updated: Mon, 02 Jul 2007
    

    

    Do you think that something on this page is wrong?    Please file a bug report     or add a note. 
   


User Notes:





 
Note by: hoze

 
2008-04-24 11:41 UTC

 

  if u want to place a image to (0,0) for example, and u want to set width and height of the rows and columns around the image with setRow and setColumn, don't use setColumn on the same row:



$worksheet->setRow(0,70);

$worksheet->setColumn(0,0,50); // row 0 col 0

$worksheet->setColumn(0,1,50); // row 0 col 1

with this the image get scaled.

try:

$worksheet->setRow(0,70);

$worksheet->setColumn(0,0,50); // row 0 col 0

$worksheet->setColumn(1,1,50); // row 1 col 1 <-- setting row1 and col1 (instead of row0 col1)



with that usage, i used:

$worksheet->insertBitmap(0, 0, "path_to_img/image", 0, 0, 1, 1);

not (...1.25,1) and the image is not scaled.



hope this helps. 





 
Note by: grodrigu@uci.edu

 
2008-03-25 01:12 UTC

 

  I found this from somewhere else which proved to be helpful



/* ************** Important - do this AFTER all column widths and merges! ************/



$logo = "/home/username/public_html/images/image_name.bmp";



// Insert Logo into Top Left corner of worksheet

$worksheet->insertBitmap(0, 0, $logo, 0, 0, 1.25, 1);

// 1.25 adjusts for problems with display size

/************************************************** **************************/