innstory

PHP輸出到WORD跟EXCEL 簡易做法

Temperature: 0 °C

2018-03-27 Mark Chang

WORD:

$filename="test.doc";

header('Pragma: public');

header("Content-disposition: attachment; filename=".$filename.";charset=utf-8");

header("Expires: Sat, 26 Jul 1997 05:00:00 GMT");

header('Last-Modified: '.gmdate('D, d M Y H:i:s') . ' GMT');

header('Cache-Control: no-store, no-cache, must-revalidate');

header('Cache-Control: pre-check=0, post-check=0, max-age=0');

header ("Pragma: no-cache");

header("Expires: 0");

header('Content-Transfer-Encoding: utf-8');

header("Content-Type: application/vnd.ms-word");

EXCEL:

$filename="test.xls";

header('Pragma: public');

header("Content-disposition: attachment; filename=".$filename.";charset=utf-8");

header("Expires: Sat, 26 Jul 1997 05:00:00 GMT");

header('Last-Modified: '.gmdate('D, d M Y H:i:s') . ' GMT');

header('Cache-Control: no-store, no-cache, must-revalidate');

header('Cache-Control: pre-check=0, post-check=0, max-age=0');

header ("Pragma: no-cache");

header("Expires: 0");

header('Content-Transfer-Encoding: utf-8');

header('Content-Type: application/vnd.ms-excel');

 

https://innstory.com/story-PHP輸出到WORD跟EXCEL_簡易做法-1533

• 
• 
• 
• 
• 

PHP

Prev

 解決svchostexe消耗記憶體問題

Next

修改php設定 

About the Author

Mark Chang

離不開電腦的宅男

Visitor message

Leave some footprints to prove that you visited me

Recommended reading

Author's other related stories

在PHP強制顯示錯誤訊息的方...

若是單一檔案，只需要在每個PHP檔案裡添加下列行： iniset(&#;displayerrors&...

修改php.ini更改允許上...

使用vi或vim開啟php.ini ＃vim /etc/php/apache/php.ini 找到以...

php使用PDO獲取結果的方...

fetch() 式例如下： mixed PDOStatement::fetch([int fetch...