thinkphp5 導出excel

需要用到phpoffice/phpspreadsheet拓展

在composer.json添加

或者composer require phpoffice/phpspreadsheet

use PhpOffice\PhpSpreadsheet\Spreadsheet;

use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

前台資料傳遞 ：

$('#excel').click(function () {

var rank = $('#rank').val();

var special_rank = $('#special_rank').val();

var start_pv = $('#start_pv').val();

var end_pv = $('#end_pv').val();

var keyword = $('#keyword').val();

var url = $(this).attr('ex_url');

window.open(url+"?rank="+rank+"&special_rank="+special_rank+"&start_pv="+start_pv+"&end_pv="+end_pv+"&keyword="+keyword);

});

背景列印：

$result = 資料;

$spreadsheet = new Spreadsheet();

$sheet = $spreadsheet->getActiveSheet();

$grade = config('grade.grade');

$headLetter = ['A','B','C'];

$headName = ['id','真實姓名','身份證号'];

foreach($headLetter as $k => $v){

$sheet->setCellValue($v.'1', $headName[$k]);、

//自動寬度

$sheet->getColumnDimension($v)->setAutoSize(true);

}

$j = 2;

foreach ($result['data'] as $k => $v) {

$sheet->setCellValue('A' . $j, $v['id'])

->setCellValue('B' . $j, $v['name'])

->setCellValue('C' . $j, $v['id_card'])

$j++;

}

//請求清單資料接口

//$result = sendGetApi('userExcelList');

//設定檔案儲存的命名、編碼、同時開放儲存路徑的權限

//命名

$fileName = "列印檔案" . date("Y-m-d", time()) . ".xlsx";

//編碼

header('Content-Type:application/vnd.ms-excel;charset=utf-8');

//告訴浏覽器要輸出的名稱

header("Content-Disposition:attachment;filename=$fileName");

//禁止浏覽器緩存

header('Cache-Control:max-age=0');

//生成excel檔案

$writer = new Xlsx($spreadsheet);

//徹底開放儲存路徑

$writer->save('php://output');

exit();

去除科學記數法：在數字字元串前加一個空格使之成為字元串

$objPHPExcel = new PHPExcel();

$objPHPExcel->setActiveSheetIndex(0);

$objPHPExcel->getActiveSheet()->setTitle('Simple');$objPHPExcel->getActiveSheet()->setCellValue('D1', ' ' . 123456789033);