可以使用PHPExcel库来导出Excel表格,下面是一个简单的示例代码:
// 引入PHPExcel库
require_once "PHPExcel/PHPExcel.php";
// 创建Excel对象
$objPHPExcel = new PHPExcel();
// 设置当前的工作表
$objPHPExcel->setActiveSheetIndex(0);
// 设置表头
$objPHPExcel->getActiveSheet()->setCellValue("A1", "姓名");
$objPHPExcel->getActiveSheet()->setCellValue("B1", "年龄");
$objPHPExcel->getActiveSheet()->setCellValue("C1", "性别");
// 设置表格内容
$objPHPExcel->getActiveSheet()->setCellValue("A2", "张三");
$objPHPExcel->getActiveSheet()->setCellValue("B2", 20);
$objPHPExcel->getActiveSheet()->setCellValue("C2", "男");
$objPHPExcel->getActiveSheet()->setCellValue("A3", "李四");
$objPHPExcel->getActiveSheet()->setCellValue("B3", 25);
$objPHPExcel->getActiveSheet()->setCellValue("C3", "女");
// 设置表格样式
$objPHPExcel->getActiveSheet()->getStyle("A1:C1")->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle("A1:C3")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
// 设置表格列宽
$objPHPExcel->getActiveSheet()->getColumnDimension("A")->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension("B")->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension("C")->setWidth(10);
// 导出Excel表格
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment;filename="example.xls"");
header("Cache-Control: max-age=0");
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, "Excel5");
$objWriter->save("php://output");
以上示例代码将创建一个包含姓名、年龄和性别信息的Excel表格,并将其导出为一个名为example.xls
的文件。同时,该代码也设置了表格的样式和列宽,以使其更易于阅读。