From 72f50311d548aedfcb941b48267535cb723ee5db Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 21 Jan 2013 12:13:14 +0800 Subject: [PATCH] JsonToExcel.php --- JsonToExcel.php | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) diff --git a/JsonToExcel.php b/JsonToExcel.php index 2a842a03..ce9d97b5 100644 --- a/JsonToExcel.php +++ b/JsonToExcel.php @@ -44,7 +44,7 @@ class Pman_Core_JsonToExcel extends Pman header("HTTP/1.0 400 Internal Server Error"); die("Missing json attribute"); } - $_json = $_POST['_json']; + $json = json_decode($_POST['_json']); $worksheet = $workbook->addWorksheet("Sheet 1"); if (is_a($worksheet, 'PEAR_Error')) { @@ -53,6 +53,14 @@ class Pman_Core_JsonToExcel extends Pman //print_R($worksheet); $worksheet->setInputEncoding('UTF-8'); + for ($r = 0; $r < count($json); $r++) { + $row = $json[$r]; + for ($c = 0; $c < count($row); $c++) { + $worksheet->write($r, $c, $row[$c]); + } + + } + -- 2.39.2