PHP

 1. Connet php to odbc

https://www.daniweb.com/programming/web-development/threads/498913/connection-function-using-odbc-with-pdo-oop

2. multiple upload php 

https://makitweb.com/multiple-files-upload-at-once-with-php/

3. mengatasi blank saat export dari php ke excel 

this one worked for me.
ob_end_clean();
$writer->save('php://output');
exit();

4. tambahkan database 

<?php

include '../vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;

use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

// Koneksi ke database

$host = "localhost";

$username = "root";

$password = "";

$dbname = "database_name";

$conn = new mysqli($host, $username, $password, $dbname);

// Cek koneksi

if ($conn->connect_error) {

    die("Koneksi gagal: " . $conn->connect_error);

}

// Query untuk mengambil data dari tabel

$query = "SELECT nama, alamat, telepon FROM tabel_name";

$result = $conn->query($query);

// Membuat instance dari spreadsheet

$spreadsheet = new Spreadsheet();

$sheet = $spreadsheet->getActiveSheet();

// Menambahkan header pada spreadsheet

$sheet->setCellValue('A1', 'Nama');

$sheet->setCellValue('B1', 'Alamat');

$sheet->setCellValue('C1', 'No. Telepon');

// Menambahkan data dari database ke spreadsheet

$row = 2;

while($data = $result->fetch_assoc()) {

    $sheet->setCellValue('A'.$row, $data['nama']);

    $sheet->setCellValue('B'.$row, $data['alamat']);

    $sheet->setCellValue('C'.$row, $data['telepon']);

    $row++;

}

// Membuat instance dari writer

$writer = new Xlsx($spreadsheet);

// Menyimpan spreadsheet

$writer->save('data.xlsx');

// Menutup koneksi

$conn->close();

echo "Data berhasil ditambahkan";

?>

5. tambahkan auto number 
$sheet->setCellValue('A'.$row, '=ROW()-1');

6.tambahkan judul

$sheet->setCellValue('A1', 'Data Barang'); $sheet->getStyle('A1')->getFont()->setSize(14); $sheet->getStyle('A1')->getFont()->setBold(true); $sheet->getStyle('A1')->getFont()->getColor()->setARGB('FFFF0000');

7. tambahkan ukuran kolom

$sheet->getColumnDimension('A')->setWidth(20); $sheet->getColumnDimension('B')->setWidth(15); $sheet->getColumnDimension('C')->setWidth(30);

8. membuat marge cell dan center

$sheet->mergeCells('A1:H1'); $sheet->getStyle('A1:H1')->getAlignment()->setHorizontal('center');

9. memberi jarak antar baris di tambahkan di dalam data

$sheet->getRowDimension($row)->setRowHeight(20);

10.