Click here to Skip to main content
15,886,199 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I am using phpexcel with codeigniter. I want to insert an image to excel file.and i am using below code

but it gives the error for file. It says file not found. But that file exists in correct folder. And I gave correct path. Please help me.The file exists in assets folder.


What I have tried:

PHP
$objDrawing = new PHPExcel_Worksheet_Drawing();
				$objDrawing->setName('Logo');
				$objDrawing->setDescription('Logo');
				$logo = base_url() . 'images/logo.png'; // Provide path to your logo file
				$objDrawing->setPath($pr_file);
				$objDrawing->setOffsetX(8);    // setOffsetX works properly
				$objDrawing->setOffsetY(300);  //setOffsetY has no effect
				$objDrawing->setCoordinates('B1');
				$objDrawing->setHeight(75); // logo height
				$objDrawing->setWorksheet($this->excel->getActiveSheet());
Posted
Updated 26-Oct-20 18:49pm
v2
Comments
Richard MacCutchan 11-Sep-17 2:58am    
If the error says 'file not found' then you need to chalk exactly what path is being generated.
Mohibur Rashid 11-Sep-17 23:46pm    
Use file_exists function to check if file exists

Simple issue in your code :

$logo = base_url()


and your are using another variable here :
$objDrawing->setPath($pr_file);


replace $pr_file with $logo
 
Share this answer
 
you should replace base_url() with $_SERVER['DOCUMENT_ROOT']
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900