//Create Product Sheet $ws_name = $product_counter . ' - ' . $p->code; $obj_ws = $obj_excel->createSheet($product_counter); $obj_ws->setTitle($ws_name); $obj_ws->getColumnDimension('A')->setWidth($el_colwidth); $obj_ws->getColumnDimension('B')->setWidth($el_colwidth); $obj_ws->getColumnDimension('C')->setWidth($el_colwidth * 3); $obj_ws->getColumnDimension('D')->setWidth($el_colwidth); $obj_ws->getColumnDimension('E')->setWidth($el_colwidth); $obj_ws->getColumnDimension('F')->setWidth($el_colwidth); $obj_ws->getColumnDimension('G')->setWidth($el_colwidth * 2); $obj_ws->getColumnDimension('H')->setWidth($el_colwidth * 2); $obj_ws->getColumnDimension('I')->setWidth($el_colwidth * 2); $obj_ws->getStyle('A1:A2')->getFont()->setSize(14)->setBold(true); $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) {