Jinsi ya Kutengeneza Download Excel (XLSX/CSV) Kwa Kutumia HTML & PHP

Katika mifumo mingi ya kitaalamu kama:

Sales System

Expenditure System

School Management Systems

Employee Records

...watumiaji hutaka kupakua taarifa katika Excel.
Leo utaona jinsi ya kutengeneza Download Excel system rahisi na inayofanya kazi.

Kuna njia mbili:
1️⃣ Kutengeneza CSV file (rahisi)
2️⃣ Kutengeneza XLSX file (kitaalamu, kutumia PHPSpreadsheet)

⭐ SEHEMU YA 1: Download CSV (Rahisi & Inafanya Kila Browser)

CSV ni Excel file ya kawaida inayotumika popote.

HTML Button
<a href="download_csv.php" class="btn">Download Excel (CSV)</a>

download_csv.php
<?php

header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="report.csv"');

$output = fopen("php://output", "w");

// Row headings
fputcsv($output, ["Name", "Class", "Score"]);

// Sample data
fputcsv($output, ["Faustine", "Form 4", "89"]);
fputcsv($output, ["Anna", "Form 3", "76"]);
fputcsv($output, ["John", "Form 2", "92"]);

fclose($output);

?>

✔ Browser inatoa Excel moja kwa moja
✔ Haipati shida kwenye hosting yoyote
✔ Rahisi & haraka

⭐ SEHEMU YA 2: Download XLSX (Professional Excel File)

Hii hutumia PHPSpreadsheet — library maarufu ya PHP.

1. Install PHPSpreadsheet (kama uko kwenye hosting au local XAMPP)
composer require phpoffice/phpspreadsheet

HTML Button
<a href="download_xlsx.php" class="btn">Download Excel (XLSX)</a>

download_xlsx.php
<?php
require "vendor/autoload.php";

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();

// Headings
$sheet->setCellValue('A1', 'Name');
$sheet->setCellValue('B1', 'Class');
$sheet->setCellValue('C1', 'Score');

// Data
$sheet->setCellValue('A2', 'Faustine');
$sheet->setCellValue('B2', 'Form 4');
$sheet->setCellValue('C2', 89);

$sheet->setCellValue('A3', 'Anna');
$sheet->setCellValue('B3', 'Form 3');
$sheet->setCellValue('C3', 76);

$writer = new Xlsx($spreadsheet);

// Headers for download
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename="report.xlsx"');

$writer->save("php://output");
exit;
?>

✔ Hii inatengeneza Excel (.xlsx) halisi
✔ Inafaa kwa report za mauzo, data nyingi, exports za kitaalamu
✔ Ina support ya formulas, styles, charts n.k.

⭐ SEHEMU YA 3: Download Excel Kutoka MySQL (Bonus)

Ikiwa unataka, naweza kukuandalia pia:

Download Excel kutoka database

Download by date, month, year

Download expenditure

Download sales report

Niambie tu na nitakutengenezea full system.

🎯 Faida za Kutumia Excel Download

Watumiaji wanaweza kuchambua data

Rahisi kuchapisha reports

Inafaa kwenye Mifumo ya Shule, Mauzo, Miradi, Payroll

Inaongeza ubora wa mfumo wako

🔗 Links Za Kujifunza Zaidi

🌐 Faulink Official Website:
https://www.faulink.com/

📘 Jifunze Web Design & Programming (Tutorials / Mifumo):
https://www.faulink.com/excel_mifumo.php

📲 Piga / WhatsApp kwa msaada wa haraka:
https://wa.me/255693118509