PHPExcel export images issue when hide or delete the column
<p>Firstly i want to show screenshots about the issue.</p>

<h3>Exported Default Excel</h3>

<p><a href="https://i.stack.imgur.com/v3UNL.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/v3UNL.jpg" alt="enter image description here"></a></p>

<h3>Hiding A Column</h3>

<p>A column hidden but images still showing.</p>

<p><a href="https://i.stack.imgur.com/Kclj6.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Kclj6.jpg" alt="enter image description here"></a></p>

<h3>Delete A Column</h3>

<p>Titles and content deleted but images still showing</p>

<p><a href="https://i.stack.imgur.com/CKyuu.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CKyuu.jpg" alt="enter image description here"></a></p>

<p>I want to export all products with images. But images in cell doesnt hiding or deleting actions.</p>

<p><strong>My tried codes:</strong></p>

<pre><code>$column = "A{$i}";          
$gdImage = imagecreatefromjpeg('img/hello_world.jpg');
$objDrawing = new PHPExcel_Worksheet_MemoryDrawing();
$objDrawing-&gt;setName('Sample image');
$objDrawing-&gt;setDescription('Sample image');
$objDrawing-&gt;setImageResource($gdImage);
$objDrawing-&gt;setRenderingFunction(PHPExcel_Worksheet_MemoryDrawing::RENDERING_JPEG);
$objDrawing-&gt;setMimeType(PHPExcel_Worksheet_MemoryDrawing::MIMETYPE_DEFAULT);
$objDrawing-&gt;setWidth(50);
$objDrawing-&gt;setHeight(50);
$objDrawing-&gt;setCoordinates($column);
$objDrawing-&gt;setWorksheet($objPHPExcel-&gt;getActiveSheet());

$objPHPExcel-&gt;getActiveSheet()-&gt;getStyle($column)-&gt;getNumberFormat()-&gt;setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
</code></pre>

<h3>Updated</h3>

<p>I found the solution with ms excel that images have <code>move and size with cells</code> option. If i can set this option <code>move and size with cells</code> from PHPExcel, issue will solve.</p>

<p>Any ideas? </p>