Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function actionHahahaha()
- {
- $excel = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
- $excel->getProperties()
- ->setCreator("Aplikasi Tes")
- ->setLastModifiedBy("Aplikasi Tes")
- ->setTitle("Report 123")
- ->setKeywords("Report 123")
- ->setCategory("Report 123");
- $excel->getActiveSheet()->setTitle("Report 123");
- $sheet = $excel->getActiveSheet();
- //Header
- $header = [
- 'NIP',
- 'Nama',
- 'Jenis Jabfung',
- 'Unit Kerja',
- 'TMP Jabfung',
- 'Periode',
- 'Nilai Dupak'
- ];
- $sheet->fromArray($header, NULL, 'A1');
- //Isi
- $data = [];
- for($i=0; $i <= 10; $i++)
- $data[$i] = [
- '123',
- 'udin',
- 'jenis 1',
- 'unit 1',
- '20-01-2019',
- '20-01-2019',
- 10000
- ];
- }
- $sheet->fromArray($data, NULL, 'A2');
- //Contoh Column Size
- $sheet->getColumnDimension('A')->setWidth(28);
- $sheet->getColumnDimension('B')->setWidth(35);
- $sheet->getColumnDimension('C')->setWidth(35);
- $sheet->getColumnDimension('D')->setWidth(35);
- $sheet->getColumnDimension('E')->setWidth(20);
- $sheet->getColumnDimension('F')->setWidth(20);
- $sheet->getColumnDimension('G')->setWidth(15);
- $filename = "excel123-".time().".xlsx";
- //Versi Download
- // header('Content-Type: application/vnd.ms-excel');
- // header('Content-Disposition: attachment;filename="' . $filename . '"');
- // header('Cache-Control: max-age=0');
- // $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($excel);
- // $writer->save('php://output');
- //Versi HTML
- // $writer = new \PhpOffice\PhpSpreadsheet\Writer\Html($excel);
- // $writer->save('php://output');
- //Versi Save to File
- $rootPath = Yii::getAlias('@app');
- $path = $rootPath . "web/tmp/" .$filename;
- $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($excel);
- $writer->save($path);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement