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

Linux下查看版本號指令

lsbrelease a ssss5 其他指令查詢方式 [root@localhost ~]# un...

設置屬性 PHP PDO s...

PDO::ATTRCASE：強制列名為指定的大小寫。 PDO::CASELOWER：強制列名小寫。 ...

使用JavaScript的s...

使用JavaScript的split 函式可以用來切割字串。 根據設定的切割點執行切開的動作。 以下...