我正在尝试使用下面的代码列表在生成的Excel工作表上添加徽标图像,但由于某种原因它什么都不做
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcel = $objReader->load("workbooks/" . $labref . "/" . $labref . ".xlsx");
$objPHPExcel->getActiveSheet(2);
$objWorkSheet = $objPHPExcel->createSheet();
$objWorkSheet->setTitle("Sample Summary");
$dir1 = "exclusive_image";
$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setName("name");
$objDrawing->setDescription("Description");
$objDrawing->setPath(base_url().'exclusive_image/nqcl.png');
$objDrawing->setCoordinates('A1');
$objDrawing->setWorksheet($objWorkSheet->getActiveSheet(2));
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save("workbooks/" . $labref . "/" . $labref . ".xlsx");
添加徽标非常简单,请尝试以下代码.
$objPHPExcel = new PHPExcel();
$sheet = $objPHPExcel->setSheetIndexAndTitle(1,"YOUR_SHEET_TITLE"); // first sheet
$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setName('logo');
$objDrawing->setDescription('logo');
$logo = base_path() . '/images/logo.png'; // Provide path to your logo file
$objDrawing->setPath($logo);
$objDrawing->setoffsetX(8); // setoffsetX works properly
$objDrawing->setoffsetY(300); //setoffsetY has no effect
$objDrawing->setCoordinates('B1');
$objDrawing->setHeight(75); // logo height
$objDrawing->setWorksheet($sheet);