php - PHPExcel more than one image in a cell -


i need create excel document 2 col. first 1 contain multiple images 150px large , seconde 1 contain web code. reason 1 image added , file appears currupted. not sure doing wrong ...

<?php include("../../init.php");  if (is_numeric($_get[groupe])){    define( 'pclzip_temporary_dir', $_config['upload']['root'].'/cache' );    // filename download   $groupe = mysql_query("select * photographe_groupe id='$_get[groupe]'");     $records = "groupe - $groupe[nom].xlsx";    header('content-type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');   header('content-disposition:inline;filename='.$records);    $workbook = new phpexcel;   $sheet = $workbook->getactivesheet();    $i=0;   $select = mysql_query("select * photographe_images sid='$_get[groupe]' group `paire`");   while($photo = mysql_fetch_array($select)){     // table header     if ($i=="1"){         $sheet->setcellvalue("a1",'photo(s)');         $sheet->setcellvalue('b1','code web');         $i++;     }      // set images in col 1     $select1 = mysql_query("select * photographe_images paire='$photo[paire]'");     while($photo1 = mysql_fetch_array($select1)){          $objdrawing = new phpexcel_worksheet_drawing();         $objdrawing->setname($photo1[img]);         $objdrawing->setdescription($photo1[img]);         $objdrawing->setworksheet($workbook->getactivesheet());         $objdrawing->setpath($_config['upload']['root'].'/userfiles/photos/'.$photo1[img]);         $objdrawing->setwidth(150);         $objdrawing->setcoordinates('a'.$i);      }      // set web code in col 2     $sheet->setcellvalue("b$i",$photo[code_web]);     $i++;   }  } $workbook->getactivesheet()->getrowdimension(1)->setrowheight(-1); $writer = new phpexcel_writer_excel2007($workbook); phpexcel_settings::setzipclass(phpexcel_settings::pclzip); $writer->save('php://output'); ?>

you can download , output demo here

just few points note before try taking @ file:

the first point note here excel doesn't store images in cells, "overlays" images, , doesn't particularly care cell boundaries occur, image can fixed size irrespective of how many cells overlays

when specify coordinate image, you're relating top-left corner of image placed @ top-left corner of cell.... bottom and/or right corner of image lies isn't determined cells @ all. setting row height or column width autosize not affected image in way, because image overlaid, not content of cell

you can, offset image top-left corner of related cell using drawing object's setoffsetx() , setoffsety() methods.

you can link more 1 image placed relative same cell's top-left corner using different offset values don't overlap, need work out offsets size of images


Comments

Post a Comment

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

i working on custom magento extension. working around adminhtml part , i've created custom form there. here form code: <?php class vivasindustries_smsnotification_block_adminhtml_sms_sendmass_edit_form extends mage_adminhtml_block_widget_form { public function _preparelayout() { $extensionpath = mage::getmoduledir('js', 'vivasindustries_smsnotification'); $head = $this->getlayout()->getblock('head'); $head->addjs('jquery.js'); $head->addjs('vivas.js'); return parent::_preparelayout(); } protected function _prepareform() { $form = new varien_data_form(array( 'id' => 'edit_form', 'action' => $this->geturl('*/*/save', array('id' => $this->getrequest()->get...
Read more

php - Bypass Geo Redirect for specific directories -

i'm trying bypass redirect specific url within site. wondering if might able help. the code below code use, original urls replaces example.com i'd able access http://example.com/admin without redirect occuring. is there way this, , there way using own ip? function country_geo_redirect() { $country = getenv('http_geoip_country_code'); if ($country == "us" ) { wp_redirect("http://usa.example.com/"); exit; } else if ($country == "gb" ) { wp_redirect("http://uk.example.com/"); exit; } } add_action('init', 'country_geo_redirect'); you can bypass redirection code if server found ip address. if ip address == <my ip address> ' nothing here else country_georedirect() end if
Read more

php - .htaccess mod_rewrite for dynamic url which has domain names -

i want convert url ex:( example.com/link.php?url=facebook.com ) ( example.com/facebook.com.php ) how can using .htaccess. or there other process make job easier ? i tried adding script .htaccess file options +followsymlinks rewriteengine on rewriterule url-(.*)\.htm$ link.php?url=$1 but converting url adding "url-" ( example.com/url-facebook.com.php ) i want remove "url-" , want make ( example.com/facebook.com.php ) rewriteengine on rewritecond %{the_request} ^get.*link\.php\?url\= [nc] rewritecond %{request_uri} !/system/.* [nc] rewriterule (.*?)link\.php\?url\=/*(.*) /$1$2 [r=301,ne,l] not sure how above work edit of used use remove index.php url
Read more