previousWorksheet::mergeCells (Previous) (Next) Worksheet::setOutlinenext

View this page in Last updated: Sun, 18 Oct 2009
English | Brazilian Portuguese | Chinese | Dutch | French | German | Hungarian | Japanese | Polish | Russian | Spanish | Turkish

Worksheet::insertBitmap

Worksheet::insertBitmap – Insert une image bitmap 24bit dans une feuille de travail

Synopsis

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 )

Description

Insert une image bitmap 24bit dans une feuille de travail. L'enregistrement principal requis est IMDATA mais il doit être précédé par un enregistrement OBJ pour définir sa position.

Parameter

  • integer $row - La ligne dans laquelle l'image sera insérée

  • integer $col - La colonne dans laquelle l'image sera insérée

  • string $bitmap - Le nom du fichier image

  • integer $x - La position horizontale (offset) de l'image dans la cellule

  • integer $y - La position verticale (offset) de l'image dans la cellule

  • integer $scale_x - L'échelle horizontale

  • integer $scale_y - L'échelle verticale

Note

This function can not be called statically.

Example

Exemple avec insertBitmap()

<?php

?>
previousWorksheet::mergeCells (Previous) (Next) Worksheet::setOutlinenext

Download Documentation Last updated: Sun, 18 Oct 2009
Do you think that something on this page is wrong? Please file a bug report or add a note.
User Notes:
Note by: seb
setColumn works like:
setColumn ( firstcol , lastcol , width)
and not
setColumn ( row , col , width)
Note by: hoze
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
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
/************************************************** **************************/