ExtractData_Site_2-Array.php

<?php
require '../vendor/autoload.php';

use GuzzleHttp\Client;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PHPHtmlParser\Dom;

$idStrings = ['3853', '3861', '3855']; // Replace with your desired IDs

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

foreach ($idStrings as $id) {
    $res = $client->request('GET', 'https://www.duurzaamloket.nl/SolKey_X014/Spec_Collector.php?ID='. $id .'&SchemeNo=0&Offset=1&SearchText=&PageCnt=500');

    $dom = new DOMDocument();
    @$dom->loadHTML($res->getBody());

    $divs = $dom->getElementsByTagName('div');

    foreach ($divs as $div) {
        $id = $div->getAttribute('id');
        if ($id == 'tblTestResults_1') {
            $tables = $div->getElementsByTagName('table');
            foreach ($tables as $table) {
                $class = $table->getAttribute('class');
                if ($class == 'LicDetails') {
                    $rows = $table->getElementsByTagName('tr');
                    foreach ($rows as $row) {
                        $cols = $row->getElementsByTagName('td');
                        $rowValues = [];
                        foreach ($cols as $col) {
                            $rowValues[] = trim($col->nodeValue);
                        }
                        if (!empty($rowValues)) {
                            $sheet->fromArray($rowValues, null, 'A' . $sheet->getHighestRow()+1);
                        }
                    }
                }
            }
        }
    }
}

$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('tabledetails1.xlsx');
?>