导出表格就是这些简单,一看就会。并附带PHPExcel库,有需要的可自行下载使用。
//因为大规模数据处理 内存占用得接触一定限制
ignore_user_abort(true);
ini_set('memory_limit', '2024M');
ini_set('pcre.backtrack_limit', 100000000);
$arr = [];
$objPHPExcel = new \PHPExcel();
//输出表头
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1','公司名称');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B1','行业名称');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C1','公司性质');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D1','公司人数');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('D')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('E1','岗位种类');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('E')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('F1','岗位类型');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('F')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('G1','岗位名称');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('G')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('H1','薪资');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('H')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('I1','城市');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('I')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('J1','区县');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('J')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('K1','工作经验');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('K')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('L1','学历');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('L')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('M1','岗位描述');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('M')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('N1','发布时间');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('N')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('O1','招聘人数');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('O')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('P1','岗位标签');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('P')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('Q1','技能标签');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('Q')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('R1','福利标签');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('R')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('S1','原本的公司名称');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('S')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('T1','原本的公司人数');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('T')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('U1','招聘平台提供的公司详情页面');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('U')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('V1','招聘平台提供的岗位详情页面');
// $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('V')->setWidth(20);
//输出内容
$a = 0;
for($b=0;$b<count($arr);$b++){
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('A'.($a+2),$arr[$b]['companyName'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('B'.($a+2),$arr[$b]['industryName'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('C'.($a+2),$arr[$b]['property'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('D'.($a+2),$arr[$b]['companySize'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('E'.($a+2),$arr[$b]['subJobTypeLevelName'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('F'.($a+2),$arr[$b]['termStr'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('G'.($a+2),$arr[$b]['name'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('H'.($a+2),$arr[$b]['salaryReal'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('I'.($a+2),$arr[$b]['workCity'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('J'.($a+2),$arr[$b]['cityDistrict'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('K'.($a+2),$arr[$b]['workingExp'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('L'.($a+2),$arr[$b]['education'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('M'.($a+2),$arr[$b]['jobSummary'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('N'.($a+2),$arr[$b]['firstPublishTime'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('O'.($a+2),$arr[$b]['recruitNumber'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('P'.($a+2),$arr[$b]['positionCommercialLabel'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('Q'.($a+2),$arr[$b]['skillLabel'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('R'.($a+2),$arr[$b]['welfareTagList'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('S'.($a+2),$arr[$b]['proxiedOrgName'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('T'.($a+2),$arr[$b]['proxiedOrgSize'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('U'.($a+2),$arr[$b]['companyUrl'],\PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('V'.($a+2),$arr[$b]['positionURL'],\PHPExcel_Cell_DataType::TYPE_STRING);
$a++;
}
$ExcelTmpDir = 'uploads/excel_temp';
$dirName = date('Ymd');//目录名
$fileName = date('YmdHis');//文件名
$objPHPExcel->getActiveSheet()->setTitle($fileName);
$objPHPExcel->setActiveSheetIndex(0);
$callStartTime = microtime(true);
if(!is_dir($ExcelTmpDir.'/'.$dirName)){
$ret=mkdir($ExcelTmpDir.'/'.$dirName, 0755, true);
if(!$ret)die('directory create faild!');
}
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save($ExcelTmpDir.'/'.$dirName.'/'.$fileName.'.xlsx');
//
$strUrl="/".$ExcelTmpDir.'/'.$dirName.'/'.$fileName.'.xlsx';
本人也是为了找个地方记录一下,方便下次使用的时候,好直接复制。
有问题的话可以发布评论,一起探讨一下。