Download Blangko Kartu Keluarga Kosong Excel -
// ------------------------------- // 1. Header: KARTU KELUARGA // ------------------------------- $sheet->mergeCells('A1:H1'); $sheet->setCellValue('A1', 'KARTU KELUARGA'); $sheet->getStyle('A1')->getFont()->setBold(true)->setSize(16); $sheet->getStyle('A1')->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER);
$row++; $sheet->setCellValue("A$row", 'RT/RW:'); $sheet->setCellValue("B$row", '____ / ____'); $sheet->setCellValue("D$row", 'Kel/Desa:'); $sheet->setCellValue("E$row", ' '); $sheet->setCellValue("G$row", 'Kecamatan:'); $sheet->setCellValue("H$row", ' '); Download Blangko Kartu Keluarga Kosong Excel
$sheet->getStyle("A$dataRow:H$dataRow")->getBorders()->getAllBorders()->setBorderStyle(Border::BORDER_THIN); // ------------------------------- // 1
// Auto-size columns foreach (range('A', 'H') as $col) $sheet->getColumnDimension($col)->setAutoSize(true); '____ / ____')
</script> This feature is production-ready, maintains an official look, and allows citizens or operators to manually fill family data before printing.
// ------------------------------- // 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, '');
$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", '_____');