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

使用CSS讓Youtube自...

pexelsphotomedia 在播放Youtube影音的時候，常使用 iframe 的方式崁入網...

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

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

使用.htaccess關閉特...

以特定檔案為例 ＜Files page.php＞ FileETag None Header unse...