DataObjects/core.sql

[Pman.Core] / SimpleExcel.php

diff --git a/SimpleExcel.php b/SimpleExcel.php
index 4c9edd4..a0128fe 100644 (file)
--- a/SimpleExcel.php
+++ b/SimpleExcel.php
@@ -18,6 +18,7 @@
             [ "a", "b" ]
             [],
             [ "A", "B" ]
+            [ "a",  ["test", "left"]  ] << sub array [text, formatname]
         ],
  *     cols :  array(
             array(
@@ -86,6 +87,15 @@ class Pman_Core_SimpleExcel extends Pman
          
     }
     
+    
+    static function date($str)
+    {
+        
+        return (strtotime($str . ' UTC') +  (86400 *  25569)) / 86400;
+        
+    }
+    
+    
     function buildpage($workbook,  $formats , $data,$cfg)
     {
         //echo '<PRE>';        print_R($cfg);
@@ -105,6 +115,12 @@ class Pman_Core_SimpleExcel extends Pman
         if (!empty($cfg['head'])) {
             foreach($cfg['head'] as $row) { 
                 foreach($row as $c => $col) {
+                    if (is_array($col)) {
+                        $format = isset($formats[$col[1]] ) ? $formats[$col[1]] : false;
+                        $worksheet->write($start_row, $c, $col[0], $format);
+                        continue;
+                    }
+                    
                     $worksheet->write($start_row, $c, $col);
                     
                 }
@@ -199,6 +215,11 @@ class Pman_Core_SimpleExcel extends Pman
             foreach($cfg['foot'] as $row) { 
                 foreach($row as $c => $col) {
                     // if it's an array? - formated ???
+                    if (is_array($col)) {
+                        $format = isset($formats[$col[1]] ) ? $formats[$col[1]] : false;
+                        $worksheet->write($start_row, $c, $col[0], $format);
+                        continue;
+                    }
                     $worksheet->write($start_row, $c, $col);
                     
                 }