<?php
    require_once('Classes/PHPExcel.php');
//  $q = new mysqli('localhost', 'hvorostin', 'xeHirvlz', 'hvorostin_hdegermanyde');
    $q = new mysqli('localhost', 'root', 'draddrad', 'hde');
    if ($q->connect_errno) {
        exit('Database Error');
    }
    $phpexcel = new PHPExcel();
    $page = $phpexcel->setActiveSheetIndex(0);
    $select = $q->query('SELECT * FROM hdegermanym_catalog_products LIMIT 1');

    $product = mysqli_fetch_assoc($select); // Берем массив для добавления
    // названий полей

//  Генерим алфавит для ячеек
    $letters = array();
    $p = 'photo';
    unset($product[$p]);
    for ($i = 0; $i < 26; $i++) {
        $letters[] = chr($i + 65);
        $p = 'photo' . $i;
        unset($product[$p]);
    }
    $letters[] = 'AA'; // Костыльнем
    $letters[] = 'AB';
//

//  Заносим названия полей
    $i = 0;
    $fields = array();
    foreach ($product as $field => $val) {
        $fields[]= $field;
        $page->setCellValue($letters[$i] . 1, $field);
        $i++;
    }
//
//
    $fields = implode(",", $fields);
    $select = $q->query("SELECT {$fields} FROM hdegermanym_catalog_products");
//

    $i = 2;
    $y = 0;
    while ($products = mysqli_fetch_object($select)) {
        $y = 0;
        foreach ($products as $field => $val) {
                $page->setCellValue($letters[$y] . $i, $val);
                $y++;
        }
        $i++;
    }
    $page->setTitle('Test');
    $objWriter = PHPExcel_IOFactory::createWriter($phpexcel, 'Excel2007');
    $objWriter->save('files/products.xlsx');

    ?>
<a href="files/products.xlsx">Скачать</a>