$obj_ws->setCellValue('A1', 'Product Code: ' . $p->code); $obj_ws->setCellValue('A2', $p->getCategory()->getName(LANGUAGEID) . ' ' . $p->getNameRaw(LANGUAGEID)); //Product Images $row_products_images = '4'; $p_image = DIR_WS_IMAGES . $p->image; if (is_file($p_image)) { $img_path = thumbimage($p_image, $pi2_width, $pi2_height, 1, 1, DIR_WS_IMAGES . 'imagecache'); $obj_excel_draw = new PHPExcel_Worksheet_Drawing(); $obj_excel_draw->setWorksheet($obj_ws); $obj_excel_draw->setPath($img_path); $obj_excel_draw->setCoordinates('A' . $row_products_images); $obj_excel_draw->setOffsetX($img_offset); $obj_excel_draw->setOffsetY($img_offset); $obj_ws->getRowDimension($row_products_images)->setRowHeight($pi2_rowheight); } $total_additional_image = $p->getAdditionalImageTotal(); if ($total_additional_image > 0) { if ($total_additional_image > 4) { $total_additional_image = 4; } $column_ai = array(); $column_ai[0] = 67; //C $column_ai[1] = 68; //B $column_ai[2] = 70; //B $column_ai[3] = 72; //B $offset_ai = array(); $offset_ai[0] = 50;