PhpSpreadsheet设置单元格常用操作汇总

<?php require 'vendor/autoload.php'; $spreadsheet = new PhpOfficePhpSpreadsheetSpreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $sheet->getDefaultColumnDimension()->setWidth(40); $sheet->getColumnDimensionByColumn(2)->setWidth(100); $sheet->setCellValue('A2', 'Hello World !'); for ($i = 1; $i < 10; $i++) { $sheet->setCellValueByColumnAndRow($i, 1, 'Col'.$i); } $fileName = '01simple.xlsx'; header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Disposition: attachment;filename="'. $fileName .'"'); header('Cache-Control: max-age=0'); header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified header('Cache-Control: cache, must-revalidate'); // HTTP/1.1 header('Pragma: public'); // HTTP/1.0 $writer = new PhpOfficePhpSpreadsheetWriterXlsx($spreadsheet); $writer->save('php://output'); exit;

（编辑：焦作站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!