怎么用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打开没问题。 仅供参考
