php - How to get row id using color code in phpexcel -


i have excel file contains rows color want row id of particular color code unable .. searched found nothing below code phpexcel

$cellcolor = $objphpexcel->getactivesheet()->getstyle($cell->getcoordinate())->getfill()->getstartcolor()->getrgb();

this give me color code , value have $cell->getvalue() $cell variable $celliterator

  foreach ($worksheet->getrowiterator() $row) {     $celliterator = $row->getcelliterator();     $celliterator->setiterateonlyexistingcells(false);              foreach ($celliterator $cell)              {               $cellcolor = $objphpexcel->getactivesheet()->getstyle($cell->getcoordinate())->getfill()->getstartcolor()->getrgb();              if (!empty($cell->getcalculatedvalue())) {                    if ($cellcolor == 'yellow') {                         echo ($cellcolor.'======'.$cell->getvalue());                    }                }             }    }

$cell->getvalue() give me value of particular color code
but, problem if have 2 rows color yellow $cell->getvalue() give 2 value
0-> yellow1
1-> yellow2
but after deleting 1st yellow colour data in excel result
0-> yellow2
which wrong need
0->''
1-> yellow2
thats why need row id particular color can identify row.

after hours of practicing got expected result

$objphpexcel = phpexcel_iofactory::load('somefile.xls'); foreach ($objphpexcel->getworksheetiterator() $worksheet) {      //$worksheettitle = $worksheet->gettitle();     $highestrow = $worksheet->gethighestrow();     $highestcolumn = $worksheet->gethighestcolumn();     $highestcolumnindex = phpexcel_cell::columnindexfromstring($highestcolumn);     //$nrcolumns = ord($highestcolumn) - 64;      $groupcount = array();     $standardsetcount = array();     $standardcount = array();     $learningtargetcount = array();      ($row = 1; $row <= $highestrow; ++$row) {         ($col = 0; $col < $highestcolumnindex; ++$col) {             $cell = $worksheet->getcellbycolumnandrow($col, $row);             $colorcode = $objphpexcel->getactivesheet()->getstyle($cell->getcoordinate())->getfill()->getstartcolor()->getrgb();              /*              * yellow               */              if ($colorcode == 'ffff00') {                 $val = $cell->getvalue();                 //$datatype = phpexcel_cell_datatype::datatypeforvalue($val);                 $groupcount[] = $val;   // $groupcount[] = $datatype;             }              /*              * gold              */              if ($colorcode == 'cc9900') {                 $val = $cell->getvalue();                 $standardsetcount[] = $val;             }              /*              * red              */              if ($colorcode == 'ff3333') {                 $val = $cell->getvalue();                 $standardcount[] = $val;             }              /*              * green              */              if ($colorcode == '00cc33') {                 $val = $cell->getvalue();                 $learningtargetcount[] = $val;             }         }     }      $group = (array_chunk($groupcount, $highestcolumnindex));     $standardset = (array_chunk($standardsetcount, $highestcolumnindex));     $standard = (array_chunk($standardcount, $highestcolumnindex));     $learningtarget = (array_chunk($learningtargetcount, $highestcolumnindex));      echo '<pre>';     print_r($learningtarget); }

Comments

Post a Comment

Popular posts from this blog

html - Outlook 2010 Anchor (url/address/link) -

i'm trying link specific pdf page msoutlook'10 or msword'10, #page=... anchor particularly useful , works fine elsewhere. unfortunately when click [ctr-k] in outlook or winword, links re-formatted assuming unc path. pdf file located on shared drive. using "file:" prefix links open pdf in adobe reader (outside of browser), , "http:" open inside browser. issue seem need open in browser "file:" prefix in order anchor work. know anchors work inside browser. outlook uses windows/explorer default program (based on file extension) seems open in adobe reader neglecting anchor. is aware of solution, link specific page or bookmark of shared-pdf ms outlook and/or winword link? common references: mailermailer.com/...anchor-tags-html-emails campaignmonitor.com/...anchor-links-in-email-newsletters/ stackoverflow.com/...anchor-in-pdf-document
Read more

javascript - Why does running this loop 9 times take 100x longer than running it 8 times? -

consider code: test = function() { } t = new test(); (var = 0; < 8; i++) { result = t instanceof test; } if change number of iterations 8 9 , loop take 100 times longer complete in latest version of firefox (41.0.1). tested on 2 different pcs , magic limit 8. here jsperf test used: http://jsperf.com/instanceof-8-times-vs-9-times does have idea why might happen? seems specific instanceof . not happen if else object, example check property. note: filed bugzilla bug this. jan de mooij mozilla team has posted details in bugzilla thread . here's simplistic interpretation of highly technical answers: in i < 8 case, firefox smart enough hoist result = t instanceof test; statement out of loop (according tests, doesn't seem omit altogether). in i < 9 case, apparently doesn't optimization . why? reason not clear, related fact 9 iterations threshold above function considered "hot" enough run through jit compiler. i < 8 cas...
Read more

Getting gateway time-out Rails app with Nginx + Puma running on Digital Ocean -

following this guide setup app on digital ocean droplet, not working. site not loading , it's throwing: "gateway time-out". the puma server works, since ps aux | grep puma prints: root 15878 0.0 0.4 376832 2168 ? sl 12:50 0:00 puma 2.13.4 (unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock) [20150930164940] root 15881 0.0 0.7 903676 3692 ? sl 12:50 0:06 puma: cluster worker 0: 15878 [20150930164940] root 24654 0.0 0.1 11748 916 pts/2 s+ 18:00 0:00 grep --color=auto puma my nginx config: user root; worker_processes 1; events { worker_connections 1024; } http { upstream puma { server unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock; } server { listen 80; server_name myapp.com; root /var/www/myapp/current/public; access_log /var/www/myapp/current/log/access.log; error_log /...
Read more