怎么用php+mysql打印数据这块不多说了。只说数据怎么导出到excel
ob_end_clean();//
$file_name='数据.xls';
$userBrowser = $_SERVER['HTTP_USER_AGENT'];
if ( preg_match( '/MSIE/i', $userBrowser ) ) {
$filename = urlencode($filename);
}
$filename = iconv('UTF-8', 'gb2312', $filename);
header("<meta http-equiv='X-UA-Compatible' content='IE=Edge'>");
header("<meta http-equiv='content-type' content='text/html;charset=uft-8'>");
header("Content-Type: application/vnd.ms-excel");
header("Expires:0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("content-disposition: attachment;filename={$file_name}");
header( "Cache-Control: public" );
header( "Pragma: public" );
header( "Content-type: text/csv" ) ;
header( "Content-Dis; filename={$file_name}" ) ;
echo "姓名"."\t";
echo "电话"."\t";
echo "\t\n";
$dsql->SetQuery($sql);//将SQL查询语句格式化
$dsql->Execute();//执行SQL操作
//这里通过循环输出执行查询中的结果。可以根据你的程序循环出数据
while($row = $dsql->GetArray()){
echo $row['title']."\t";
echo $row['tel']."\t";
echo "\t\n";
}
这个导出的数据,类似csv格式的,用wps打开没问题。
仅供参考