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 的方式崁入網...

PHP無法保存SESSION...

一天，客戶反應系統後台無法登入。 而這問題是發生在客戶電腦更換了IP位置。 而我這邊也只是開放新的I...

要如何知道ajax執行失敗原...

只要在error的function 更改為以下寫法即可： error: function (XMLH...