// Add some data
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'Hello')
            ->setCellValue('B2', 'world!')
            ->setCellValue('C1', 'Hello')
            ->setCellValue('D2', 'world!');

<?php
/**
 * PHPExcel
 *
 * Copyright (C) 2006 - 2013 PHPExcel
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 *
 * @category   PHPExcel
 * @package    PHPExcel
 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
 * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL
 * @version    1.7.9, 2013-06-02
 */

/** Error reporting */
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Europe/London');

if (PHP_SAPI == 'cli')
	die('This example should only be run from a Web Browser');

/** Include PHPExcel */
require_once '../Classes/PHPExcel.php';


// Create new PHPExcel object
$objPHPExcel = new PHPExcel();

// Set document properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
							 ->setLastModifiedBy("Maarten Balliauw")
							 ->setTitle("Office 2007 XLSX Test Document")
							 ->setSubject("Office 2007 XLSX Test Document")
							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
							 ->setKeywords("office 2007 openxml php")
							 ->setCategory("Test result file");


// Add some data
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'Hello')
            ->setCellValue('B2', 'world!')
            ->setCellValue('C1', 'Hello')
            ->setCellValue('D2', 'world!');

// Miscellaneous glyphs, UTF-8
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A4', 'Miscellaneous glyphs')
            ->setCellValue('A5', 'éàèùâêîôûëïüÿäöüç');

// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('Simple');


// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);


// Redirect output to a client’s web browser (Excel2007)
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="01simple.xlsx"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
exit;

<?php
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: xlsx" . date("Y-m-d") . ".xlsx");
header( "Content-disposition: filename= test1.xlsx");
include('config_export.php');// gere les login et pass de la BDD
include ('data_export.php');
 
$link=database_connect($db); // on se connecte à la base de donnée grâce à data_export.php
 
$table = 'excel'; /* Remplacez par le nom de votre table à exporter ! */
$file = 'export';
$result = mysql_query("SHOW COLUMNS FROM ".$table."");
$xls_output='';
$i = 0;
if (mysql_num_rows($result) > 0)
{
while ($row = mysql_fetch_assoc($result))
{
/* erreur ligne 19*/     $xlsx_output .= $row['Field']."; ";   // erreur ligne 19
$i++;
}
}
 
$xlsx_output .= "\n";
 
$values = mysql_query("SELECT * FROM ".$table."");
while ($rowr = mysql_fetch_row($values))
{
for ($j=0;$j<$i;$j++)
{
$xlsx_output .= $rowr[$j]."; ";
}
$xlsx_output .= "\n";
}
 
$filename = $file."_".date("Y-m-d_H-i",time());
 
print $xlsx_output;
exit;
?>

<?php
/*
* fonction pour se connecter a la base de donnée
 
*@param $db(array) de config_export.php
 
*@return $link
*/
// On dis que la variable $db va prendre la valeur du tableau de $db ecris dans config.php
function database_connect($db) {
 $link=mysql_connect($db['host'],$db['user'],$db['pass'])or die ("connexion impossible : erreur ! ");
 mysql_select_db($db['base']);
 mysql_query('SET NAMES UTF8');
 return $link; // return va juste dire : true si ca a marché, ou ce qu'il y a marqué dans 'or die' si ca a foiré
 }
 
/**
 * fonction de deconnection de base de donnee
 * @param $link lien de base
 * @return rien
 */
function database_disconnect($link){
 mysql_close($link);
}
?>

<?php
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: xls" . date("Y-m-d") . ".xls");
header( "Content-disposition: filename= test1.xls");
include "config_export.php"; // gere les login et pass de la BDD
include "data_export.php";
 
$link=database_connect($db); // on se connecte à la base de donnée grâce à data_fn.php
 
$table = 'excel'; /* Remplacez par le nom de votre table à exporter ! */
$file = 'export';
$result = mysql_query("SHOW COLUMNS FROM ".$table."");
$i = 0;
if (mysql_num_rows($result) > 0)
{
while ($row = mysql_fetch_assoc($result))
{
$xls_output .= $row['Field']."; ";
$i++;
}
}
 
$xls_output .= "\n";
 
$values = mysql_query("SELECT * FROM ".$table."");
while ($rowr = mysql_fetch_row($values))
{
for ($j=0;$j<$i;$j++)
{
$xls_output .= $rowr[$j]."; ";
}
$xls_output .= "\n";
}
 
$filename = $file."_".date("Y-m-d_H-i",time());
 
print $xls_output;
exit;
?>

Salut,

Ce script ne peu fonctionner que sur ton ordi vu le nom de fichier et l'utilisation de la lib com.

Ensuite il faut que tu utilise la fonction header pour envoyer le fichier au navigateur. (Exemple dans la doc, c'est pdf mais le principe est la).

Ensuite c'est assez simple si ce script est la cible du formulaire (action) qui contient le bouton le tour est joué

@+