19/03/2010 Written by Cyril GRANDJEAN

As you can notice, my website has a new design to bring more sobriety and professionalisme.

I was able to count on Antoine Lenoir’s support for the creation of the new graphics standards (www.studio-khaz.com).

01/09/2009 Written by Cyril GRANDJEAN

During my work for the company Planet Bourgogne, I had to create an XLS file using PHP and MySQL. I’ve also discovered a PHP library for reading and writing XLSX files.

The format XLSX is supported by Excel 2007 and later. For the previous versions, it requires the installation of the following module : http://www.microsoft.com/downloads/details.aspx?displaylang=fr&FamilyID=941b3470-3ae9-4aee-8f43-c6bb74cd1466.

Here are some lines of codes which are going to allow you to create your first file XLS by using PHP.

  1. Download and copy the library PHPExcel in your PHP Project
  2. Create a PHP file by using the following syntax :
/** Errors report */

/** Include path **/
set_include_path(get_include_path() . PATH_SEPARATOR . 'PHPExcel/Classes/');

/** PHPExcel */
include 'PHPExcel.php';

/** PHPExcel_Writer_Excel2007 */
include 'PHPExcel/Writer/Excel2007.php';

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

//We add contents
//Warning, a utf8_encode() is necessary for the character like 'é', 'è', ..
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Ligne 1 Colonne 1');
$objPHPExcel->getActiveSheet()->setCellValue('A2', utf8_encode('Durée'));

//Manage the size of the column

//Manage font style

//Make a border style

// Save our file xlsx
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);

This tutorial is only the bases necessary for the creation of a simple file XLSLX. For advanced used : click here.

31/10/2008 Written by Cyril GRANDJEAN

Agora Immobilier

Here is the website which I realised for the real estate agency Agora Immobilier.

On this website, you can find all announcements of rents, sales and investments.

For each property, you can find a description of the property, photos. Agora Immobilier is the first real estate agency in Aube to display videos of properties. Then, if you want to rent, to buy or to invest, do not hesitate to consult this website.