#CACHE{0}
<?php

if (!$_COOKIE["spip_admin"]) die ("Accès interdit");

$repertoire = sous_repertoire(_DIR_IMG, 'cache-auditeurs');
$files = glob($repertoire.'*');
foreach($files as $file){ // iterate files
  if(is_file($file))
    unlink($file); // delete file
}


$fichier = $repertoire.md5("auditeurs".rand(1,1000000)).".xlsx";



include_once("squelettes/xlsxwriter.class.php");

$header = array(
  'Promo'=>'string',
  'Prénom'=>'string',
  'Particule'=>'string',
  'Nom'=>'string',
  'Organisme'=>'string',
  'Email'=>'string',
  'Email secondaire'=>'string',
  'Fonction'=>'string',
  'Biographie'=>'string',
  'Région' => 'string',
  'Tél. perso' => 'string',
  "Adresse perso" => "string",
  "Adresse perso 2" => "string",
  "Code postal perso" => "string",
  "Ville perso" => "string",
  'Tél. pro' => 'string',
  "Adresse pro" => "string",
  "Adresse pro 2" => "string",
  "Code postal pro" => "string",
  "Ville pro" => "string",
);

<BOUCLE_mots(MOTS){id_groupe=2}{titre==Cycle}{par titre}{inverse}>
			<BOUCLE_auditeurs(AUTEURS){id_mot}{par nom}>
$data[] = array(
	"#_mots:TITRE",
	"[(#NOM|nettoyer_nom{prenom})]",
	"[(#NOM|nettoyer_nom{particule})]",
	"[(#NOM|nettoyer_nom{nom})]",
	"[(#ORGANISME|replace{\",\"})]",
	"[(#EMAIL)]",
	"[(#EMAIL_SECOURS)]",
	"[(#FONCTION|replace{\",\"})]",
	"[(#BIO*|replace{\",\"})]",
	"[(#LISTER_VALEURS{region})]",
	"[(#TELEPHONE_PERSO|espace_telephone)]",
	"[(#ADRESSE_PERSO*|replace{\",\"})]",
	"[(#ADRESSE_PERSO_2*|replace{\",\"})]",
	"[(#CP_PERSO*|replace{\",\"})]",
	"[(#VILLE_PERSO*|replace{\",\"})]",
	"[(#TELEPHONE_PRO|espace_telephone)]",
	"[(#ADRESSE_PRO*|replace{\",\"})]",
	"[(#ADRESSE_PRO_2*|replace{\",\"})]",
	"[(#CP_PRO*|replace{\",\"})]",
	"[(#VILLE_PRO*|replace{\",\"})]",

);
			</BOUCLE_auditeurs>
</BOUCLE_mots>


$writer = new XLSXWriter();
$writer->writeSheetHeader('Sheet1', $header );
foreach($data as $row)
	$writer->writeSheetRow('Sheet1', $row );
$writer->writeToFile($fichier);


die ("<a href='$fichier'>Récupérer le fichier</a>");

?>