php 把数据导入excel表格中

最新推荐文章于 2024-07-13 09:47:45 发布

花落乱了流年

最新推荐文章于 2024-07-13 09:47:45 发布

阅读量638

点赞数

分类专栏：常用函数项目心得

本文链接：https://blog.csdn.net/hualuo_/article/details/73649790

版权

常用函数同时被 2 个专栏收录

5 篇文章 0 订阅

订阅专栏

项目心得

5 篇文章 0 订阅

订阅专栏

function exportToExcel($datas){
//实例化

include_once("PHPExcel/PHPExcel.php");
include_once("PHPExcel/PHPExcel/IOFactory.php");

$title=_lang_resume_excel_title;
// echo get_include_path() . PATH_SEPARATOR . _SITE_ROOT . 'server/include/class/PHPExcel';
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");
$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");
$objPHPExcel->getProperties()->setKeywords("office 2007 openxml php");
$objPHPExcel->getProperties()->setCategory($title);

// 設定標題部分
$objPHPExcel->setActiveSheetIndex(0);
//$objPHPExcel->getActiveSheet()->setCellValue('A1', $title);
// $objPHPExcel->getActiveSheet()->setCellValue('A2', $date);
//標題必須合併欄位否則下面的寬度無法限制!!
//$objPHPExcel->getActiveSheet()->mergeCells('A1:J1');
//$objPHPExcel->getActiveSheet()->mergeCells('A2:J2');
//設定寬度
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
//設置表頭
$objPHPExcel->getActiveSheet()->setCellValue('A1', "活动名称");
$objPHPExcel->getActiveSheet()->setCellValue('B1', "报名人");
$objPHPExcel->getActiveSheet()->setCellValue('C1', "参加者");
$objPHPExcel->getActiveSheet()->setCellValue('D1', "联系方式");
$objPHPExcel->getActiveSheet()->setCellValue('E1', "报名时间");



$i=1;
foreach ($datas as $v){
// $is_full_time=($v['is_full_time']==1)?_lang_full_time_job:_lang_not_full_time_job;
$i++;
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $v['title']); //活动名称
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $v['u_name']); //报名人
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $v['name']); //参加者
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $v['mobile']); //联系方式
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $v['c_datetime']); //联系方式
}
//
$objPHPExcel->getActiveSheet()->setTitle($title);
$objPHPExcel->setActiveSheetIndex(0);
//temporary

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$excel_file = _SITE_TEMPORARY_PATH."/Excel/".time().".xls";
$objWriter->save($excel_file);
$d_file_name = "job".time().".xls";

header("Content-type: application/x-download");
header("Content-Disposition:attachment; filename=".$d_file_name);
readfile($excel_file);
//unlink(_SITE_ROOT . $excel_file);
}