X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=GnumericToExcel.php;h=824db5be5491c5ee92579984fafd65611e3d694f;hb=4f0a32091fae216359f985b9e6bf33af903035eb;hp=cae40372bb5c48e2a25c625e80288fe3aa3c2e80;hpb=1253749931e3419b8001fcec732f482dc2b6e60b;p=Pman.Core diff --git a/GnumericToExcel.php b/GnumericToExcel.php index cae40372..824db5be 100644 --- a/GnumericToExcel.php +++ b/GnumericToExcel.php @@ -55,7 +55,7 @@ class Pman_Core_GnumericToExcel extends Pman //$this->addEvent("DOWNLOAD", false, isset($_REQUEST['title']) ? $_REQUEST['title'] : '???'); - if (!empty($_POST['format']) && $_POST['format']=='gnumeric') { + if (!empty($_POST['format']) && $_POST['format']=='gnumeric') { if (empty($_POST['debug'])) { header('Content-type: application/x-gnumeric'); header('Content-Disposition: attachment; filename="' .addslashes($fname). '.gnumeric"'); @@ -65,8 +65,20 @@ class Pman_Core_GnumericToExcel extends Pman echo $xml; exit; } + + $ext = '.xls'; + $outfmt = 'Gnumeric_Excel:excel_biff8'; + $mime = 'application/vnd.ms-excel'; + if (!empty($_POST['format']) && $_POST['format']=='xlsx') { + $outfmt = 'Gnumeric_Excel:xlsx'; + $ext = '.xlsx'; + $mime = 'aapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet'; + } + + + $srcTmp = ini_get('session.save_path') . '/' .uniqid('gnumeric_').'.gnumeric'; - $targetTmp = ini_get('session.save_path') . '/' .uniqid('gnumeric_').'.xls'; + $targetTmp = ini_get('session.save_path') . '/' .uniqid('gnumeric_') . $ext; // write the gnumeric file... $fh = fopen($srcTmp,'w'); fwrite($fh, $xml); @@ -79,7 +91,7 @@ class Pman_Core_GnumericToExcel extends Pman $ss = System::which('ssconvert'); $cmd = $xvfb . " -a " . $ss. " --import-encoding=Gnumeric_XmlIO:sax" . - " --export-type=Gnumeric_Excel:excel_biff8 " . + " --export-type={$outfmt} " . $srcTmp . ' ' . $targetTmp . ' 2>&1'; // echo $cmd; //passthru($cmd);exit; @@ -97,7 +109,7 @@ class Pman_Core_GnumericToExcel extends Pman } $fname .= preg_match('/\.xls/i', $fname) ? '' : '.xls'; // make sure it ends in xls.. - header('Content-type: application/vnd.ms-excel'); + header('Content-type: ' . $mime); header('Content-Disposition: attachment; filename="' .addslashes($fname). '"'); header('Content-length: '. filesize($targetTmp)); header("Content-Transfer-Encoding: binary");