PHPExcel Convert Whole Page to XLSX

Question

I'm trying to use PHPExcel to convert a report page to XLSX but i couldn't be able to do it. My PHP file as below;

error_reporting(E_ALL);
ini_set('display_errors', 0);
include("SqlSettings.php");
function date_tr($f, $zt = 'now'){
    $z = date("$f", strtotime($zt));
    $donustur = array(
        'Monday'    => 'Pazartesi',
        'Tuesday'   => 'Salı',
        'Wednesday' => 'Çarşamba',
        'Thursday'  => 'Perşembe',
        'Friday'    => 'Cuma',
        'Saturday'  => 'Cumartesi',
        'Sunday'    => 'Pazar',
        'January'   => 'Ocak',
        'February'  => 'Şubat',
        'March'     => 'Mart',
        'April'     => 'Nisan',
        'May'       => 'Mayıs',
        'June'      => 'Haziran',
        'July'      => 'Temmuz',
        'August'    => 'Ağustos',
        'September' => 'Eylül',
        'October'   => 'Ekim',
        'November'  => 'Kasım',
        'December'  => 'Aralık',
        'Mon'       => 'Pts',
        'Tue'       => 'Sal',
        'Wed'       => 'Çar',
        'Thu'       => 'Per',
        'Fri'       => 'Cum',
        'Sat'       => 'Cts',
        'Sun'       => 'Paz',
        'Jan'       => 'Oca',
        'Feb'       => 'Şub',
        'Mar'       => 'Mar',
        'Apr'       => 'Nis',
        'Jun'       => 'Haz',
        'Jul'       => 'Tem',
        'Aug'       => 'Ağu',
        'Sep'       => 'Eyl',
        'Oct'       => 'Eki',
        'Nov'       => 'Kas',
        'Dec'       => 'Ara',
    );
    foreach($donustur as $en => $tr){
        $z = str_replace($en, $tr, $z);
    }
    if(strpos($z, 'Mayıs') !== false && strpos($f, 'F') === false) $z = str_replace('Mayıs', 'May', $z);
    return $z;
}
date_default_timezone_set('Europe/Istanbul');
$timestamp = strtotime(date('H:i:s')) + 60*60;
$ssaat = date('H:i:s', $timestamp);
$dun=date('d.m.Y',strtotime("-1 days"));
$dun=date("Y-m-d", strtotime($dun));
$dun="2017-02-02";
?>


  Mürekkep Raporu


  




1)
{
print "



";
}//excele aktar parametresi kapalı
else
{

}//excele aktar parametresi açık
print "

";
$sorgu_renkler=mysql_query("select * from renkler where sipkod='".$_GET["sipkod"]."'") or die (mysql_error());
  while ($rinf=mysql_fetch_array($sorgu_renkler))
  {
print "

";    
  }//sorgu_renkler while
print " 

  
    İŞ EMRİ NO
    TARİH
    MÜŞTERİ
    ÜRÜN
    
    HAM MADDE
      
        
          ÖZELLİĞİ
          MİKTARI(Tabaka)
          GEÇİŞ SAYISI
          GEÇİŞ YÖNÜ
          
    


MÜREKKEP


LOT NO
RENK
MİKTAR (KG)
MİKTAR (GR)
  
    
    
    HAMMADDE Δ DEĞERİ
    MAKİNA
  

".$isemri."
".$tarih."
".$musteri."
".$urun."



".$hozellik."
".number_format($hmiktar, 0, ',', '.')."
".$hgecsay."
".$hgecyon."






".$rinf[2]."
".$rinf[1]."
".$rinf[3]."
".$rinf[4]."



0
".$makina."
  
";

I have downloaded PHPExcel's latest version from official web site and tried to make an XLSX file according to "01simple-download-xlsx" in the examples folder. But as a beginner in PHP i have failed. According to examples(as far as i understand) i need to format every cell and data in it before create an XLSX file but i couldn't understand how. I have searched via stackoverflow and found some examples which basicly creating a HTML file and make PHPExcel parse the data from it, i have tried those examples but it's breaking my design.

My design looks like this;

But when i create a XLSX file it returns to this;

Some of the characters went missing because of the language code of page and i know i can fix that with UTF-8 coding (usually i'm using latin5) but as you can see whole desing is breaking up.

Another thing i have tried that to copy XLSX example from examples folder and i have edited my code as below;

//added this codes to top of the page
require_once dirname(__FILE__) . '/Classes/PHPExcel.php';
$objPHPExcel = new PHPExcel();
Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="Murekkep_Raporu_'.$_GET["sipkod"].'.xls"');
header('Cache-Control: max-age=0');
If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');
If you're serving to IE over SSL, then the following may be needed
header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header ('Pragma: public'); // HTTP/1.0')

//and added this code bottom of the page
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;

With this modification it's creating XLSX file but when you try to open excel says file is either corrupted or can not readable.

Is there any way to convert whole page to XLSX file without breaking the design ?

Thanks in advance.

seboettg · Accepted Answer

I'm not familiar using phpexcel, but there is a really easy to use php library for Excel and OpenOffice sheets: https://github.com/box/spout

Using Spout, you can also setup Encoding.

I would suggest to try this library.

PHPExcel Convert Whole Page to XLSX

Answers (1)

Related Questions