SimpleExcel.php
authorAlan Knowles <alan@roojs.com>
Fri, 22 Feb 2013 03:18:22 +0000 (11:18 +0800)
committerAlan Knowles <alan@roojs.com>
Fri, 22 Feb 2013 03:18:22 +0000 (11:18 +0800)
SimpleExcel.php

index 86be1d7..ee527f3 100644 (file)
@@ -254,55 +254,56 @@ class Pman_Core_SimpleExcel extends Pman
         
     }
     
-    function addLine($worksheet_name, $data)
+    function addLine($worksheet_name, $clo)
     {
         $cfg = $this->workSheetCfg[$worksheet_name];
         $start_row = &$this->start_row;
         
-        foreach($data as $r=>$clo) {
-            $cl = $clo;
-            if (is_object($clo)) {
-                $cl = (array)$clo; // lossless converstion..
-            }
+        $r = 0;
+       
+        $cl = $clo;
+        if (is_object($clo)) {
+            $cl = (array)$clo; // lossless converstion..
+        }
+        
+        if (isset($cfg['row_height'])) {
+            $worksheet->setRow($start_row +$r, $cfg['row_height']);
+        }
+        
+        foreach($cfg['cols']  as $c=>$col_cfg) {
             
-            if (isset($cfg['row_height'])) {
-                $worksheet->setRow($start_row +$r, $cfg['row_height']);
+            if(isset($cl[$col_cfg['dataIndex']])){
+                $v = $cl[$col_cfg['dataIndex']];
+            }else{
+                if(isset($col_cfg['fillBlank'])){
+                    $worksheet->write($start_row+$r, $c, '', $formats[$col_cfg['fillBlank']]);
+                }
+                continue;
             }
             
-            foreach($cfg['cols']  as $c=>$col_cfg) {
-                
-                if(isset($cl[$col_cfg['dataIndex']])){
-                    $v = $cl[$col_cfg['dataIndex']];
-                }else{
-                    if(isset($col_cfg['fillBlank'])){
-                        $worksheet->write($start_row+$r, $c, '', $formats[$col_cfg['fillBlank']]);
-                    }
-                    continue;
-                }
-                
-                if (empty($cl[$col_cfg['dataIndex']])) {
-                    continue;
-                }
-                if (isset($col_cfg['txtrenderer'])) {
-                    $v = call_user_func($col_cfg['txtrenderer'], 
-                            $cl[$col_cfg['dataIndex']], $worksheet, $r+1, $c, $clo);
-                    if ($v === false) {
-                        continue;
-                    }
-                  //  var_dump($v);
-                }
-                if (isset($col_cfg['renderer'])) {
-                    $hasRender = true;
+            if (empty($cl[$col_cfg['dataIndex']])) {
+                continue;
+            }
+            if (isset($col_cfg['txtrenderer'])) {
+                $v = call_user_func($col_cfg['txtrenderer'], 
+                        $cl[$col_cfg['dataIndex']], $worksheet, $r+1, $c, $clo);
+                if ($v === false) {
                     continue;
                 }
-                
-                $v = @iconv('UTF-8', 'UTF-8//IGNORE', $v);
-                
-                $format = isset($col_cfg['format']) ? $formats[$col_cfg['format']] : false;
-                
-                $worksheet->write($start_row+$r, $c, $v, $format);
+              //  var_dump($v);
+            }
+            if (isset($col_cfg['renderer'])) {
+                $hasRender = true;
+                continue;
             }
+            
+            $v = @iconv('UTF-8', 'UTF-8//IGNORE', $v);
+            
+            $format = isset($col_cfg['format']) ? $formats[$col_cfg['format']] : false;
+            
+            $worksheet->write($start_row+$r, $c, $v, $format);
         }
+        $this->start_row++;
         
         
     }