//writer 類
$writer = new XLSXWriter();
 //文件名
$filename = "example.xlsx";
//設(shè)置 header，用于瀏覽器下載
header('Content-disposition: attachment; filename="'.XLSXWriter::sanitize_filename($filename).'"');
header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
header('Content-Transfer-Encoding: binary');
header('Cache-Control: must-revalidate');
header('Pragma: public');

//導(dǎo)出的數(shù)據(jù)
$string = array (
 0 => 
 array (
 'payc_bill_time' => '2017-07-12 16:40:44',
 'payt_received_date' => '2017-07-12',
 'ci_name' => '租金',
 'payt_num' => 'YRZB(2012)A0047',
 'payt_scsr_name' => '李巧紅',
 'payt_received' => '300.00',
 'paytd_type' => '現(xiàn)金',
 'emp_name' => '鄭振標(biāo)',
 ),
 1 => 
 array (
 'payc_bill_time' => '2017-07-12 16:39:55',
 'payt_received_date' => '2017-07-12',
 'ci_name' => '租金',
 'payt_num' => 'YRZB(2012)A0046',
 'payt_scsr_name' => '22222',
 'payt_received' => '45.00',
 'paytd_type' => '現(xiàn)金',
 'emp_name' => '鄭振標(biāo)',
 )
 );
 //每列的標(biāo)題頭
$title = array (
 0 => '開單時(shí)間',
 1 => '收款時(shí)間',
 2 => '開票項(xiàng)目',
 3 => '票據(jù)編號',
 4 => '客戶名稱',
 5 => '實(shí)收金額',
 6 => '收款方式',
 7 => '收款人',
);
//工作簿名稱
$sheet1 = 'sheet1';

//對每列指定數(shù)據(jù)類型，對應(yīng)單元格的數(shù)據(jù)類型
foreach ($title as $key => $item){
 $col_style[] = $key ==5 ? 'price': 'string';
}

//設(shè)置列格式，suppress_row: 去掉會多出一行數(shù)據(jù)；widths: 指定每列寬度
$writer->writeSheetHeader($sheet1, $col_style, ['suppress_row'=>true,'widths'=>[20,20,20,20,20,20,20,20]] );
//寫入第二行的數(shù)據(jù)，順便指定樣式
$writer->writeSheetRow($sheet1, ['xxx財(cái)務(wù)報(bào)表'],
['height'=>32,'font-size'=>20,'font-style'=>'bold','halign'=>'center','valign'=>'center']);

/*設(shè)置標(biāo)題頭，指定樣式*/
$styles1 = array( 'font'=>'宋體','font-size'=>10,'font-style'=>'bold', 'fill'=>'#eee',
'halign'=>'center', 'border'=>'left,right,top,bottom');
$writer->writeSheetRow($sheet1, $title,$styles1);
// 最后是數(shù)據(jù)，foreach寫入
foreach ($data as $value) {
 foreach ($value as $item) { $temp[] = $item;}
 $rows[] = $temp;
 unset($temp);
}
$styles2 = ['height'=>16];
foreach($rows as $row){
 $writer->writeSheetRow($sheet1, $row,$styles2);
}

//合并單元格，第一行的大標(biāo)題需要合并單元格
$writer->markMergedCell($sheet1, $start_row=0, $start_col=0, $end_row=0, $end_col=7);
//輸出文檔
$writer->writeToStdOut();
exit(0);

use Component；
$writer = new XLSXWriter();