phpexcelmysql导出_PHPEXCEL结合MYSQL+PHP实现数据库数据导出EXCEL实例

PS:这是本人在编写业务处理系统时&＃xff0c;结合PHPEXCEL官方实例&＃xff0c;编写的一个。感觉还不错。分享一下。

error_reporting(E_ALL);

date_default_timezone_set(&＃39;Europe/London&＃39;);

/** PHPExcel */

require_once &＃39;../phpclass/PHPExcel.php&＃39;;

// Create new PHPExcel object

$objPHPExcel &＃61; new PHPExcel();

// Set properties

$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")

->setLastModifiedBy("Maarten Balliauw")

->setTitle("Office 2007 XLSX Test Document")

->setSubject("Office 2007 XLSX Test Document")

->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")

->setKeywords("office 2007 openxml php")

->setCategory("Test result file");

$objPHPExcel->getActiveSheet()->mergeCells(&＃39;A1:G1&＃39;);

$objPHPExcel->getActiveSheet()->getStyle(&＃39;A1&＃39;)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

$objPHPExcel->getActiveSheet()->getColumnDimension(&＃39;C&＃39;)->setAutoSize(true);

$objPHPExcel->getActiveSheet()->getColumnDimension(&＃39;A&＃39;)->setWidth(20);

$objPHPExcel->getActiveSheet()->getColumnDimension(&＃39;E&＃39;)->setWidth(20);

// Add some data

$objPHPExcel->setActiveSheetIndex(0)

->setCellValue(&＃39;A1&＃39;, &＃39;通讯录&＃39;)

->setCellValue(&＃39;A2&＃39;, &＃39;账号&＃39;)

->setCellValue(&＃39;B2&＃39;, &＃39;姓名&＃39;)

->setCellValue(&＃39;C2&＃39;, &＃39;手机&＃39;)

->setCellValue(&＃39;D2&＃39;, &＃39;电话&＃39;)

->setCellValue(&＃39;E2&＃39;, &＃39;科室&＃39;)

->setCellValue(&＃39;F2&＃39;, &＃39;级别&＃39;)

->setCellValue(&＃39;G2&＃39;, &＃39;编号&＃39;);

//数据库连接

$db &＃61; mysql_connect("localhost", "ywcl", "ywcl");

mysql_select_db("ywcl",$db); //选择数据库&＃xff0c;这里为"ywcl"。

mysql_query("SET NAMES UTF8"); //设定编码方式为UTF8

$sqlgroups&＃61;"select * from user order by jibie";

$resultgroups&＃61;mysql_query($sqlgroups);

$numrows&＃61;mysql_num_rows($resultgroups);

if ($numrows>0)

{

$count&＃61;2;

while($data&＃61;mysql_fetch_array($resultgroups))

{

$count&＃43;&＃61;1;

$l1&＃61;"A"."$count";

$l2&＃61;"B"."$count";

$l3&＃61;"C"."$count";

$l4&＃61;"D"."$count";

$l5&＃61;"E"."$count";

$l6&＃61;"F"."$count";

$l7&＃61;"G"."$count";

$objPHPExcel->setActiveSheetIndex(0)

->setCellValue($l1, $data[&＃39;username&＃39;])

->setCellValue($l2, $data[&＃39;realname&＃39;])

->setCellValue($l3, $data[&＃39;mobile&＃39;])

->setCellValue($l4, $data[&＃39;bgdh&＃39;])

->setCellValue($l5, $data[&＃39;keshi&＃39;])

->setCellValue($l6, $data[&＃39;jibie&＃39;])

->setCellValue($l7, $data[&＃39;bianhao&＃39;]);

}

}

// Rename sheet

$objPHPExcel->getActiveSheet()->setTitle(&＃39;通讯录&＃39;);

// Set active sheet index to the first sheet, so Excel opens this as the first sheet

$objPHPExcel->setActiveSheetIndex(0);

// Redirect output to a client’s web browser (Excel5)

header(&＃39;Content-Type: application/vnd.ms-excel&＃39;);

header(&＃39;Content-Disposition: attachment;filename&＃61;"通讯录.xls"&＃39;);

header(&＃39;Cache-Control: max-age&＃61;0&＃39;);

$objWriter &＃61; PHPExcel_IOFactory::createWriter($objPHPExcel, &＃39;Excel5&＃39;);

$objWriter->save(&＃39;php://output&＃39;);

exit;

?>