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
/************************************************** **************************/
|
