<?php

defined('mxMainFileLoaded') or die('access denied');

global $user_prefix;

require_once 'Spreadsheet/Excel/Writer.php';
$workbook = new Spreadsheet_Excel_Writer();
$workbook->send('test.xls');
$workbook->setVersion(8);
$format_bold =& $workbook->addFormat();
$format_bold->setBold();
$worksheet =& $workbook->addWorksheet('International worksheet');

// $worksheet->setInputEncoding('utf-8');
$worksheet->setInputEncoding('ISO-8859-1');

//Feldnamen schreiben
$zeile  = 0;
$spalte = 0;
$header = '';
$data   = '';

$select = "SELECT * FROM " . $user_prefix . "_users";
$export = mysql_query($select) or die ('Sql error: ' . mysql_error());

$fields = mysql_num_fields($export);

for ($i = 0; $i < $fields; $i++) {
    $header = mysql_field_name($export, $i) . "\t";
    $worksheet->write($zeile, $spalte, $header, $format_bold);
    $spalte++; //nächste Spalte
}

//Inhalt schreiben
$zeile  = 1;
$spalte = 0;

while ($row = mysql_fetch_row($export)) {
    foreach ($row as $value) {
        $worksheet->write($zeile, $spalte, $value);
        $spalte++; //nächste Spalte
    }
    $zeile++; //neue Zeile
    $spalte = 0; //wieder in der ersten Spalte anfangen
}
$workbook->close();


if ($data == '') {
    include('header.php');
    OpenTable();
    echo 'Keine Eintr&auml;ge vorhanden';
    CloseTable();
    include('footer.php');
}
?>