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

mysql 查詢數據資料是否...

pexelsphoto5 有沒有試過資料庫裡上萬筆資料卻不知道是不是有重複的數據? 這時你一定要試試...

PHP使用array_pro...

arrayproduct()是PHP中的一個內建函數，可以返回陣列中所有元素的乘積。 例如 $arr...

分享 不得不用的15個神奇熱...

好吧~我學到了，看看有沒有機會用上。 我承認切換桌面跟把視窗快速隱藏的熱鍵是蠻好用的。 不想被發現的...