« Programmation PHP/PHPExcel » : différence entre les versions

Contenu supprimé Contenu ajouté
Ligne 39 :
 
== Conversion ==
Conversion d'un CSV en XLSX :
{{...}}
<source lang=php>
$xlsx = PHPExcel_IOFactory::load('./HelloWorld1.xlsx');
$writer = PHPExcel_IOFactory::createWriter($xlsx, 'CSV');
$writer->setDelimiter(";");
$writer->setEnclosure("");
$writer->save('./HelloWorld1.csv');
</source>
 
Conversion d'un XLSX en CSV :
<source lang=php>
$objReader = PHPExcel_IOFactory::createReader('CSV');
$objReader->setDelimiter(';');
$objReader->setEnclosure(' ');
$objPHPExcel = $objReader->load('./HelloWorld1.csv');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('./HelloWorld4.xlsx');
</source>
 
== Références ==