php phpexcel excelの作成

1448 ワード

public function createExcel($result=[],$fileName=''){
\think\Loader::import('extend.excel.PHPExcel',ROOT_PATH);
import('Org.Util.Util');
$Util = new \util\Util();
$objExcel = new \PHPExcel();
$objWriter = new \PHPExcel_Writer_Excel5($objExcel); //
$objExcel->setActiveSheetIndex(0);
$objActSheet = $objExcel->getActiveSheet();
// sheet
$objActSheet->setTitle('sheet1');
//
$objActSheet->setCellValue('A1', 'name');
$objActSheet->setCellValue('B1', 'sex');
foreach($result as $key => $value){
$number = $key+2;
$objActSheet->setCellValue("A".$number,$value['name'] ); // Excel A2
$objActSheet->setCellValue("B".$number,$value['sex']);
}
// excel
$fileId=md5(time() + rand() * 100000);
$filePath = getFilePath($fileId);
$fileId = iconv('utf-8','gbk',$fileName);
$filePath = '/home/examine/';
if (!is_dir($filePath)) {
@mkdir($filePath, 0777, true);
}
$fileName = $fileId.'.xls';
$excelLocalPath = $filePath . $fileName;
$objWriter->save($excelLocalPath);
echo $excelLocalPath;
}