$sheet->mergeCells('A2:H2'); $sheet->setCellValue('A2', 'KELUARGA INTI / KELUARGA LAINNYA'); $sheet->getStyle('A2')->getFont()->setItalic(true); $sheet->getStyle('A2')->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER);
// ------------------------------- // 4. Empty Rows (for 10 family members) // ------------------------------- for ($i = 1; $i <= 10; $i++) $dataRow = $row + $i; $sheet->setCellValue("A$dataRow", $i); for ($colIdx = 'B'; $colIdx <= 'H'; $colIdx++) $sheet->setCellValue($colIdx . $dataRow, ''); Download Blangko Kartu Keluarga Kosong Excel
$row++; $sheet->setCellValue("A$row", 'Kab/Kota:'); $sheet->setCellValue("B$row", ' '); $sheet->setCellValue("D$row", 'Provinsi:'); $sheet->setCellValue("E$row", ' '); $sheet->setCellValue("G$row", 'Kode Pos:'); $sheet->setCellValue("H$row", '_____'); 'KELUARGA INTI / KELUARGA LAINNYA')
wb.save("Blangko_KK_Kosong.xlsx") <button onclick="downloadKK()">📥 Download Blangko KK Kosong (Excel)</button> <script> function downloadKK() window.location.href = 'download_kk_blank.php'; $i++) $dataRow = $row + $i