PHP Code Can Insert Image to Excel File and Open It Correctly in Ms Excel

Adding Image to the Excel in phpexcel in php

Specifying coordinates for the image might help, as per the examples and the documentation

$objDrawing->setCoordinates('A3');

Note that an image isn't in a cell/column/row, but overlaid over the main sheet at the same position as that cell/column/row

Insert Image in csv file using php script

No, that is not possible straight away. By the specs, CSV files are text-based, they do not have anything like images or other type of binary data.

So unless both the generator and the reader agree on a format, such as a Data-URI, there is no way to include graphic data.

You might want to create a different kind of file, like a spreadsheet (.odt, .xls/.xlsx), however those are not CSV files you ask for.

Adding a logo to an excel sheet using php excel

Adding logo is so simple, try below code.

$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); 

PhpExcel write/save onto existing excel file

excel5 is for xls ( excel2007 is for xlsx)

Hence, change the write to excel block to

$fetched->fromArray($exceldatas, null, 'A1', true);
$objWriter = PHPExcel_IOFactory::createWriter($readphpexcel, 'Excel2007');// Excel 2010
$objWriter->save("polimer_uzex.xlsx");

Export HighChart as an image in excel file together with the other page contents

1. Here is link on highcharts documentation. Thats will help u to export image and store it.
   

2. a) Documentation #1
   
   b) Documentation #2
   
   That will help u with PHPExcel classs API.

3. And finally exapmle of image paste to a sheet, using PHPExcel class: one or two;

Have more questions? See that links: one, two.

And official PHPExcel examples: here.

Good luck!

---

Related Topics