1. 規定導出字段
$title = array(
'id' => '序號',
'finishTime' => '運單完成時間',
'business_name' => '負責商家',
'site_name' => '站點名稱',
'waybill_number' => '運單號',
'order_total_price' => '訂單金額',
'income' => '商家實收',
);
$info = array();
$info['title'] = $title;
$info['creator'] = $nickname;
$info['sheetName'] = '商家賬單';
得到$info
2.獲取數據源，二維數組，數組需包含$info中的title字段，字段順序也需一致；得到$data
3.調用類的方法：
~~~
$objWriter = PHPExcelToolkit::export($data, $info);
~~~
4.設置頭部
~~~
$this->_setHeader($filename);
protected function _setHeader($filename)
{
header('Content-Type: application/vnd.ms-excel');
header("Content-Disposition: attachment;filename={$filename}");
header('Cache-Control: max-age=0');
header('Cache-Control: max-age=1');
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
}
~~~
5.定義文件名，保存
~~~
$filename = '騎手賬單'. $start .'-'.$end .'.xls';
$objWriter->save('php://output');
~~~
