1. 導入
  2. 書式設定のチュー
    トリアル
  3. Workbook::close
  4. Workbook::&addWorksheet
  5. Workbook::&addFormat
  6. Workbook::setCountry
  7. Workbook::&setTempDir
  8. Workbook::setVersion
  9. Workbook::setCustomColor
  10. Workbook::worksheets
  11. Worksheet::getName
  12. Worksheet::
    setInputEncoding
  13. Worksheet::select
  14. Worksheet::activate
  15. Worksheet::setFirstSheet
  16. Worksheet::protect
  17. Worksheet::setColumn
  18. Worksheet::writeCol
  19. Worksheet::writeRow
  20. Worksheet::setSelection
  21. Worksheet::freezePanes
  22. Worksheet::thawPanes
  23. Worksheet::
    hideScreenGridlines
  24. Worksheet::setPortrait
  25. Worksheet::setLandscape
  26. Worksheet::setPaper
  27. Worksheet::setHeader
  28. Worksheet::setFooter
  29. Worksheet::setMerge
  30. Worksheet::
    centerHorizontally
  31. Worksheet::
    centerVertically
  32. Worksheet::setMargins
  33. Worksheet::setMargins_LR
  34. Worksheet::setMargins_TB
  35. Worksheet::setMarginLeft
  36. Worksheet::
    setMarginRight
  37. Worksheet::setMarginTop
  38. Worksheet::
    setMarginBottom
  39. Worksheet::repeatRows
  40. Worksheet::repeatColumns
  41. Worksheet::printArea
  42. Worksheet::hideGridlines
  43. Worksheet::
    printRowColHeaders
  44. Worksheet::fitToPages
  45. Worksheet::
    setHPagebreaks
  46. Worksheet::
    setVPagebreaks
  47. Worksheet::setZoom
  48. Worksheet::setPrintScale
  49. Worksheet::write
  50. Worksheet::writeNumber
  51. Worksheet::writeString
  52. Worksheet::writeNote
  53. Worksheet::writeBlank
  54. Worksheet::writeFormula
  55. Worksheet::writeUrl
  56. Worksheet::setRow
  57. Worksheet::mergeCells
  58. Worksheet::insertBitmap
  59. Worksheet::setOutline
  60. Spreadsheet_Excel_Writer
  61. send
  62. rowcolToCell
  63. Format::setAlign
  64. Format::setVAlign
  65. Format::setHAlign
  66. Format::setMerge
  67. Format::setLocked
  68. Format::setUnLocked
  69. Format::setBold
  70. Format::setBottom
  71. Format::setTop
  72. Format::setLeft
  73. Format::setRight
  74. Format::setBorder
  75. Format::setBorderColor
  76. Format::setBottomColor
  77. Format::setTopColor
  78. Format::setLeftColor
  79. Format::setRightColor
  80. Format::setFgColor
  81. Format::setBgColor
  82. Format::setColor
  83. Format::setPattern
  84. Format::setUnderline
  85. Format::setItalic
  86. Format::setSize
  87. Format::setTextWrap
  88. Format::setTextRotation
  89. Format::setNumFormat
  90. Format::setStrikeOut
  91. Format::setOutLine
  92. Format::setShadow
  93. Format::setScript
  94. Format::setFontFamily

Worksheet::insertBitmap

Worksheet::insertBitmap – 24 ビットのビットマップ画像をワークシートに挿入する

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

24 ビットのビットマップ画像をワークシートに挿入します。主な必須レコードは IMDATA ですが、その前に、位置を決定するための OBJ レコードが必要です。

Parameter

  • integer $row - ビットマップを挿入する行。

  • integer $col - ビットマップを挿入する列。

  • string $bitmap - ビットマップファイル名。

  • integer $x - セル内での画像の横位置 (オフセット)。

  • integer $y - セル内での画像の縦位置 (オフセット)。

  • integer $scale_x - 横方向の拡大率。

  • integer $scale_y - 縦方向の拡大率。

Note

This function can not be called statically.

Example

insertBitmap() の使用法

<?php

?>
Excel97/2000 用メソッド (Previous) アウトラインおよびグループ化のプロパティを設定する (Next)
Last updated: Fri, 29 Aug 2014 — Download Documentation
Do you think that something on this page is wrong? Please file a bug report or add a note.
View this page in:

User Notes:

Note by: alvaro@demogracia.com
Plese note that params $x and $y (horizontal/vertical position) are allowed to be negative.
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
/************************************************** **************************/