php下載excel表格（php導出excel表格）

本文目錄一覽：

• 1、PHP請問我需要在頁面上顯示 EXCEL表格，並且能下載怎麼做呢
• 2、php導出excel表、壓縮成文件下載到本地如何實現？
• 3、php導出excel表後，打包成壓縮包，然後下載到本地如何實現？

PHP請問我需要在頁面上顯示 EXCEL表格，並且能下載怎麼做呢

$retdata=array(); //內容 //二維數組

$filename= “文件.csv”;

//生成頭文件

$now = gmdate(“D, d M Y H:i:s”);

header(“Expires: Tue, 03 Jul 2001 06:00:00 GMT”);

header(“Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate”);

header(“Last-Modified: {$now} GMT”);

header(“Content-Type: application/force-download”);

header(“Content-Type: application/octet-stream”);

header(“Content-Type: application/download”);

header(“Content-Disposition: attachment;filename={$filename}”);

header(“Content-Transfer-Encoding: binary”);

//生成表格

$title=array(‘”金額”‘,'”會員”‘,'”餘額”‘); //每列的標題

$str=implode(‘,’,$title) . PHP_EOL;

foreach ($retdata as $row) {

// print_r($row);

$str_arr = array();

foreach ($row as $column) {

$str_arr[] = ‘”‘ . str_replace(‘”‘, ‘””‘, $column) . ‘”‘;

}

$str.=implode(‘,’, $str_arr) . PHP_EOL;

}

print(chr(0xEF).chr(0xBB).chr(0xBF));

echo $str;

php導出excel表、壓縮成文件下載到本地如何實現？

你好!你所提出的三個問題.我沒怎麼看懂.如果以第二個為主.我倒可以說說我的看法.

一.如何把數據賦到excel中?

答:sorry.沒怎麼明白.見諒.

二.導出為excel表?

答:有兩種方法實現.1.phpexcel.(稍顯複雜) 2.簡單的(我講這個.簡單^_^)直接上代碼.自己改一下名字 和字段名.就成.

?php

error_reporting(0); //屏蔽警告和NOTICE等所有提示.包括error

Header( “Content-type: application/octet-stream “);

Header( “Accept-Ranges: bytes “);

Header( “Content-type:application/vnd.ms-excel;charset=Big5”); //此處寫編碼,如,UTF-8….

Header( “Content-Disposition:attachment;filename=abnormal_Report.xls “); //自己寫文件名 *.xls

require “conn_mysql.php”; //連接mysql

$sql = “select * from `netart`.`abnormal_records` order by record_abtime desc”;

$result = mysql_query($sql,$conn);

echo “table width=’100%’ border=’1′ “;

echo”tr”;

echo “td style=’color:red’ font size=4 ID /font/td”;

echo “td style=’color:red’ font size=4異常時間 /font/td”;

echo “td style=’color:red’ font size=4異常地點 /font/td”;

echo “td style=’color:red’ font size=4詳細內容 /font/td”;

echo “td style=’color:red’ font size=4提交人 /font/td”;

echo “td style=’color:red’ font size=4提交時間 /font /td”;

echo “/tr”;

while ($rs=mysql_fetch_array($result)){

echo “tr”;

echo “td width=’30’ {$rs[‘record_id’]}/td”; //用width 控制表格的寬度.自己改變.

echo “td width=’150′ {$rs[‘record_abtime’]}/td”;

echo “td width=’80’ {$rs[‘record_abplace’]}/td”;

echo “td width=’700′ {$rs[‘record_content’]} /td”;

echo “td width=’60’ {$rs[‘record_username’]} /td”;

echo “td width=’120′ {$rs[‘record_uptime’]} /td”;

echo “/tr”;

}

echo “/tbale”;

?

//以上代碼.自己去改一下名字.和字段名就可以運行了.

==========================================================================

下面的代碼針對MSSQL:(基本跟 Mysql一樣啦.只是改用了ODBC)

?php

error_reporting(0);

Header( “Content-type: application/octet-stream”);

Header( “Accept-Ranges: bytes “);

Header( “Content-type:application/vnd.ms-excel;charset=Big5”);

Header( “Content-Disposition:attachment;filename=Syslog_view.xls “);

require “conn_mssql.php”;

session_start();

$flag1=@$_SESSION[‘flag_1’];

$flag2=@$_SESSION[‘flag_2’];

$flag3=@$_SESSION[‘flag_3’];

$content=@$_SESSION[‘content’];

$ip=@$_SESSION[‘ip’];

$content_2=@$_SESSION[‘content_2’];

$ip_2=@$_SESSION[‘ip_2’];

$time=@$_SESSION[‘time’];

if($flag1==1)

{ $sql_s=”select SysLog.DateTime,SysLog.IP,SysLog.Message from NetPerfMon.dbo.SysLog where IP=’$ip’ and convert(varchar(10),DateTime,120)=’$time’ order by DateTime desc”;}

if($flag2==2)

{ $sql_s=”select SysLog.DateTime,SysLog.IP,SysLog.Message from NetPerfMon.dbo.SysLog where IP=’$ip’ and convert(varchar(10),DateTime,120)=’$time’ order by DateTime desc”;}

if($flag3==3)

{$sql_s=”select SysLog.DateTime,SysLog.IP,SysLog.Message from NetPerfMon.dbo.SysLog where IP=’$ip’ and Message like ‘%$content%’ and convert(varchar(10),DateTime,120)=’$time’ order by DateTime desc”;}

$res=odbc_do($link,$sql_s);

echo “table width=’100%’ border=’1′”;

echo”tr”;

echo “td style=’color:red’ font size=4 DateTime /font/td”;

echo “td style=’color:red’ font size=4 Switch IP /font/td”;

echo “td style=’color:red’ font size=4 Content/font/td”;

echo “/tr”;

while ($rs=odbc_fetch_array($res))

{

echo “tr”;

echo “td width=’130′ {$rs[‘DateTime’]}/td”;

echo “td width=’110′ {$rs[‘IP’]}/td”;

echo “td width=’800′ {$rs[‘Message’]}/td”;

echo “/tr”;

}

echo “/tbale”;

session_stop();

?

三.壓縮成文件下載到本地？

答:此處也沒怎麼明白.因為,你做個按鈕/鏈接至上面的代碼.不就可以保存成excel到本地了..還要做什麼壓縮呢.

綜:回答完畢.希望能幫到你.

php導出excel表後，打包成壓縮包，然後下載到本地如何實現？

用PHPExcel，PHPExcel是相當強大的 MS Office Excel 文檔生成類庫。

你上它的官/網把程序包下/載下來，裏面有 PHPExcel 的程序、還有30個實例程序和三個文檔。

看一下其中的開發文檔你就會用了。

讀取（這段在開發文檔里有的，在13頁）：

require_once ‘../Classes/PHPExcel/IOFactory.php’;

$objReader = PHPExcel_IOFactory::createReader(‘Excel2007’);

$objReader-setReadDataOnly(true);

$objPHPExcel = $objReader-load(“test.xlsx”);

$objWorksheet = $objPHPExcel-getActiveSheet();

echo ‘table’ . “\n”;

foreach ($objWorksheet-getRowIterator() as $row) {

echo ‘tr’ . “\n”;

$cellIterator = $row-getCellIterator();

$cellIterator-setIterateOnlyExistingCells(false);

foreach ($cellIterator as $cell) {

echo ‘td’ . $cell-getValue() . ‘/td’ . “\n”;

}

echo ‘/tr’ . “\n”;

}

echo ‘/table’ . “\n”;

?