各位前輩你們好 想請教PhpSpreadsheet套件產出Excel格式問題
目前遇到程式技術上困難。

開發系統環境(自己家裡的環境)
OS Windows 10
php version 7.4.28
PhpSpreadsheet-1.20.0 version
Microsoft Excel 365 version

p.s. 開發系統環境(公司系統)
|OS|PHP version|PHPExcel|PHPMailer|Microsoft Excel version|
|---- |---|
|CentOS7|7.0.33 |1.8.0 |5.2.26 |2016

這是利用PhpSpreadsheet套件產出的格式

附上我的程式碼

<?php

    // Load Composer's autoloader
    require_once 'D:\06.programming\php\vendor\autoload.php';

    // Import PhpSpreadsheet classes into the global namespace
    // These must be at the top of your script, not inside a function
    use PhpOffice\PhpSpreadsheet\Spreadsheet;
    use PhpOffice\PhpSpreadsheet\Writer\Xlsx;


    // Connecting to SQL Server
    require_once 'D:\06.programming\php\Config\connect-sqlserver.php';
    
    // ========== 建立工作表一 ==========
    
    $spreadsheet = new Spreadsheet();
    $sheet = $spreadsheet->getActiveSheetIndex(0);
    $sheet = $spreadsheet->getActiveSheet(0);

    // Excel 儲存格 A2~C2填入文字
    $TitleData = ['國家代碼', '國家地區', '人口數量'];
    $sheet->fromArray($TitleData, NULL, 'A2');
    
    // Excel 設定儲存格格式
    $styleArray = [
        'alignment' => [
            'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
        ],
        'fill' => [
            'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_GRADIENT_LINEAR,
            'startColor' => [
                'rgb' => 'ffff00',
            ],
            'endColor' => [
                'rgb' => 'ffff00',
            ],
        ],
    ];
    $sheet->getStyle('A2:C2')->applyFromArray($styleArray);

    // 設定儲存格，寬度
    $sheet->getColumnDimension('A')->setWidth(10);
    $sheet->getColumnDimension('B')->setWidth(15);
    $sheet->getColumnDimension('C')->setWidth(10);

    // ============== END ==============

    // ========== 連接資料庫取得資料 ==========

    $conn = OpenConnection();
    // SQL Server 撈取資料
    $tsql = "
        SELECT
            CountryCode
            ,District
            ,MAX(Population) AS Population
        FROM city
        WHERE District LIKE 'C%' OR District LIKE 'D%'
        GROUP BY CountryCode, District
        ORDER BY CountryCode, District
    ";

    $result = sqlsrv_query($conn, $tsql);
    if ($result == false) {
        die(sqlsrv_errors());
    } else {
        // $rowsheet從Excel儲存格第3列開始填入資料
        $rowsheet = 3;
        while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC))
        {
            $sheet->setCellValue('A'.$rowsheet, $row['CountryCode'])
                    ->setCellValue('B'.$rowsheet, $row['District'])
                    ->setCellValue('C'.$rowsheet, $row['Population']);
            $rowsheet++;
        }
    }

    // ============== END ==============

    // ========== Save Excel on Windows D disk ==========

    $writer = new Xlsx($spreadsheet);
    $writer->save('test.xlsx');

    // ========== END ==========

    sqlsrv_close($conn);

?>

假如想要呈現這樣的Excel格式呢?

問題?國家人口數量要怎麼呈現?卡住?

我的想法
反推儲存格文字的第幾欄?第幾列?
利用陣列?取得Excel儲存格欄位在哪裡?填入國家人口數量?

更改我的程式碼，我直接擷取重點程式片段

// ========== 連接資料庫取得資料 ==========

    $conn = OpenConnection();
    
    $tsql = "
        SELECT
            CountryCode
            ,District
            ,MAX(Population) AS Population
        FROM city
        WHERE District LIKE 'C%' OR District LIKE 'D%'
        GROUP BY CountryCode, District
        ORDER BY CountryCode, District
    ";

    $tsql2 = "
        SELECT
            CountryCode
        FROM city
        WHERE District LIKE 'C%' OR District LIKE 'D%'
        ORDER BY CountryCode
    ";

    $tsql3 = "
        SELECT
            District
        FROM city
        WHERE District LIKE 'C%' OR District LIKE 'D%'
        ORDER BY District
    ";

    $result = sqlsrv_query($conn, $tsql);
    $result2 = sqlsrv_query($conn, $tsql2);
    $result3 = sqlsrv_query($conn, $tsql3);
    if ($result == false) {
        die(sqlsrv_errors());
    } else {

        // 開始顯示國家人口數量??
        /*
        $rowsheet = 3;
        while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC))
        {
            ??
        }
        */

        // 第3列開始以下顯示國家代碼
        $rowsheet = 3;
        while ($row = sqlsrv_fetch_array($result2, SQLSRV_FETCH_ASSOC))
        {
            $sheet->setCellValue('A'.$rowsheet, $row['CountryCode']);
            $rowsheet++;
        }

        // 第B欄開始往右顯示國家地區
        $colsheet = "B";
        while ($row = sqlsrv_fetch_array($result3, SQLSRV_FETCH_ASSOC))
        {
            $sheet->setCellValue($colsheet.'2', $row['District']);

            $colsheet++;
        }


    }

    // ============== END ==============

為甚麼要搞這麼麻煩?
抱歉，因為公司上層和各單位使用者要求我必須呈現這種格式...
煩請各位了，謝謝...