X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=JsonToExcel.php;h=75a24fe85c76eae82211dc3bf41aac0697f09bb3;hp=ce9d97b570f0107af24147cd64de08d5b0b1882c;hb=1524f8b36295809a3eedd6da3c6494f8aa0d86f5;hpb=72f50311d548aedfcb941b48267535cb723ee5db

diff --git a/JsonToExcel.php b/JsonToExcel.php
index ce9d97b5..75a24fe8 100644
--- a/JsonToExcel.php
+++ b/JsonToExcel.php
@@ -28,7 +28,7 @@ class Pman_Core_JsonToExcel extends Pman
         return true;
     }
 
-    function get()
+    function get($v, $opts=array())
     {
         $this->jerr("invalid get");
     }
@@ -46,6 +46,15 @@ class Pman_Core_JsonToExcel extends Pman
         }
         $json = json_decode($_POST['_json']);
         
+        
+        require_once 'Spreadsheet/Excel/Writer.php';
+        // Creating a workbook
+        $outfile2 = $this->tempName('xls');
+       // var_dump($outfile2);
+        $workbook = new Spreadsheet_Excel_Writer($outfile2);
+        //$workbook = new Spreadsheet_Excel_Writer();
+        $workbook->setVersion(8);
+        // sending HTTP headers
         $worksheet =  $workbook->addWorksheet("Sheet 1");
         if (is_a($worksheet, 'PEAR_Error')) {
             die($worksheet->toString());
@@ -60,11 +69,13 @@ class Pman_Core_JsonToExcel extends Pman
             }
             
         }
+         $workbook->close();
         
-        
-         
-          
+        require_once 'File/Convert.php';
+        $fc=  new File_Convert($outfile2, "application/vnd.ms-excel");
+        $fn = $fc->convert("application/vnd.ms-excel"); 
+        $fc->serve('attachment','excel-'.date('Y-m-d-H-i-s').'.xls'); // can fix IE Mess
+        unlink($outfile2); 
     }
-    
-    
+     
 }