I have multiple array and i want to write each array into each tab of excels sheets using PHP -

-

i have following array. want write array in excel sheets using php. 

 try{     $client = new soapclient(wsdl_url, array('cache_wsdl' => wsdl_cache, 'trace' => true, 'features' => soap_single_element_arrays, 'proxy_host' => soap_proxy_host, 'proxy_port' => soap_proxy_port));     $client->__setlocation(wsdl_endpoint_url);     $result = $client->maximiselostprospectdecision();     //print_r($result);     //exit;     if (!empty($result->lostprospect->lostprospectrow))      {       foreach ($result->lostprospect->lostprospectrow $prospect)       {            $fields   =   array();           foreach($prospect $key=>$prospect_details)           {              $fields[]=$prospect_details;            }                              }            } } 

<?php   ini_set('max_execution_time',0); error_reporting('all'); ini_set('display_errors','on'); ini_set('memory_limit', '51200m'); $email      = $argv[2]; $instance   = $argv[1];   require_once ('classes/phpexcel.php'); require_once ('classes/phpexcel/iofactory.php');  $_request['instance']   = $instance;  require_once dirname(__file__).'/../../boot/bootstrap.php';  $date_from      =   date('y-m-d', mktime(0, 0, 0, date("m"), date("d")-7, date("y"))); $date_to            =   date('y-m-d', mktime(0, 0, 0, date("m"), date("d")-1, date("y"))); $date=date('f y'); $objphpexcel = new phpexcel();  $allprospectarray=array();  try{     $client = new soapclient(wsdl_url, array('cache_wsdl' => wsdl_cache, 'trace' => true, 'features' => soap_single_element_arrays, 'proxy_host' => soap_proxy_host, 'proxy_port' => soap_proxy_port));      $client->__setlocation(wsdl_endpoint_url);            //*********** keep funation /.p file in array dynmaiclly call **************//          $allprospectarray['decision'] ='maximiselostprospectdecision';         $allprospectarray['duplicate']= 'maximiselostprospectduplicate';         $allprospectarray['exitingcustomer']= 'maximiselostprospectexisting_customer';         $allprospectarray['moveorclose']= 'maximiselostprospectmove_or_close';         $allprospectarray['noneed']= 'maximiselostprospectno_need';         $allprospectarray['optout']= 'maximiselostprospectopt_out';         $allprospectarray['ownerchange']= 'maximiselostprospectowner_change';         $allprospectarray['poordata']= 'maximiselostprospectpoor_data';         $allprospectarray['price']= 'maximiselostprospectprice';         $allprospectarray['servicequality']= 'maximiselostprospectservice_quality';             $tabcount=count($allprospectarray);          $tabindex=0;                foreach ($allprospectarray $key=> $resultval)              {                      $result=array() ; //*********** initialise array ************//                     $result=$client->$resultval(); //********* progress function/.p file call //                     if (!empty($result->lostprospect->lostprospectrow))                      {                           $fields=array();                           $datacontent=$result->lostprospect->lostprospectrow;                           foreach ($datacontent $prospect)                           {                              $fields[]=(array) $prospect;                           }                             $filename='';                             $filename='tmp/activity_csv/'.$key.'.xls';                             chmod($filename,0777);                             $tabindex++;                             $objphpexcel->setactivesheetindex(0);                                $objphpexcel->getactivesheet()->settitle($key);                             $objphpexcel->getactivesheet()->fromarray($fields, null, 'a1');                             $objwriter = phpexcel_iofactory::createwriter($objphpexcel, 'excel5');                             $objwriter->save(str_replace('maximiselostprospectbackup.php',$filename, __file__));                      }                }   //************ types prospects end//      }      catch (exception $e) {             echo "failed data. error: ".$e->getmessage();             print_r($e);             exit;             }             ?>

Comments

Post a Comment

Popular posts from this blog

html - Firefox flex bug applied to buttons? -

-
i'm trying apply flex button on firefox i'm having problem on chrome doesn't happens. this css: .button { display: inline-flex; align-items: center; } as can see in fiddle, "caret" word moved new line, happens if element <button> tag, <div> works expected. http://codepen.io/anon/pen/xblmgx is firefox bug or there css i'm missing? nevermind, looks "mr firefox" doesn't idea... <button> not implementable (by browsers) in pure css, bit of black box, perspective of css. means don't react in same way e.g. <div> would. this isn't specific flexbox -- e.g. don't render scrollbars if put "overflow:scroll" on button, , don't render table if put "display:table" on it. stepping further, isn't specific <button> . consider <fieldset> , <table> have special rendering behavior: data:text/html,<fieldset style="d...
Read more

html - Missing border-right in select on Firefox -

-
Image
when put select div width , padding-left, options have no border on right. more, happend if select have width 118px , parent have 15px of padding left! have idea, going on? my code: <!doctype html> <html> <head lang="en"> </head> <body> <div style="width: 1000px; padding-left: 15px;"> <select style="width: 118px;"> <option>a</option> <option>b</option> <option>c</option> </select> </div> </body> </html> and result: here plunker: click it happend on firefox on windows. tested on 40.0.2 version -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; box-sizing: border-box; source: https://stackoverflow.com/a/11390432/4431269 source of problem: https://bugzilla.mozilla.org/show_bug.cgi?id=924068 and use of google ! edit: (source of problem, explained) after rea...
Read more

python - build a suggestions list using fuzzywuzzy -

-
i building suggestion engine database. i'm using fuzzywuzzy module match user input string existing database shown below. if request.method == "get": display_dict = {} user_input = request.get["user_input"] # user input match_dict = {} food_items_obj = food_items.objects.all() # fetch objects table items in food_items_obj : match = fuzz.ratio(user_input.lower(),items.name.lower()) # try match user input existing names match_dict[match] = items.name # put 1 dictionary matched_dict = ordereddict(sorted(match_dict.items(),reverse = true)) # sort dictionary if max(matched_dict.keys()) == 100: # if exact match put in dict , return display_dict[100] = matched_dict[100] else : # if not found try best matching words.. ###########this part need help! ############# k,v in matched_dict.items(): if user_input in v : display_dict[k]...
Read more