-
- require_once 'System.php';
- $ss = System::which('ssconvert');
- $cmd = $ss.
- " --import-encoding=Gnumeric_XmlIO:sax" .
- " --export-type=Gnumeric_Excel:excel_biff8 " .
- $srcTmp . ' ' . $targetTmp . ' 2>&1';
- // echo $cmd;
- //passthru($cmd);exit;
- //exit;
- $out = `$cmd`;
- clearstatcache();
-
- if (!file_exists($targetTmp) || !filesize($targetTmp)) {
- header("HTTP/1.0 400 Internal Server Error - Convert error");
- die("ERROR CONVERTING?:" . $cmd ."\n<BR><BR> OUTPUT:". htmlspecialchars($out));
- }
- // unlink($srcTmp);
- if (empty($fname)) {
- $fname = basename($targetTmp);
- }
- $fname .= preg_match('/\.xls/i', $fname) ? '' : '.xls'; // make sure it ends in xls..
-
- header('Content-type: application/vnd.ms-excel');
- header('Content-Disposition: attachment; filename="' .addslashes($fname). '"');
- header('Content-length: '. filesize($targetTmp));
- header("Content-Transfer-Encoding: binary");
- if ($file = fopen($targetTmp, 'rb')) {
- while(!feof($file) and (connection_status()==0)) {
- print(fread($file, 1024*8));
- flush();
+ for ($r = 0; $r < count($json); $r++) {
+ $row = $json[$r];
+ for ($c = 0; $c < count($row); $c++) {
+ $worksheet->write($r, $c, $row[$c]);