blob: bc272408e8a820e29685196a3d09b036c3b38471 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
<?php
use League\Csv\Reader;
use League\Csv\Writer;
use lib\FilterTranscode;
require '../vendor/autoload.php';
//the current CSV is UTF-8 encoded with a ";" delimiter
$csv = Reader::createFromPath(__DIR__.'/data/prenoms.csv');
//To be open in MacOS Excel a CSV must
// - be encoded in UTF16-LE
// - use tab delimiter
//let's convert the CSV to be UTF-16_LE encoded with a tab delimiter.
//we must use `createFromPath` to be able to use the stream capability
//we must use a temp file to be able to rewind the cursor file without losing
//the modification
$writer = Writer::createFromPath('/tmp/toto.csv', 'w');
//adjust the output BOM to be used
$writer->setOutputBOM(Writer::BOM_UTF16_LE);
// we register a Transcode Filter class to convert the CSV into the proper encoding charset
stream_filter_register(FilterTranscode::FILTER_NAME."*", "\lib\FilterTranscode");
$writer->appendStreamFilter(FilterTranscode::FILTER_NAME."UTF-8:UTF-16LE");
//we set the tab as the delimiter character
$writer->setDelimiter("\t");
//we insert csv data
$writer->insertAll($csv);
//let's switch to the Reader object
//Writer::output will failed because of the open mode
//The BOM settings are all copied to the Reader object
$reader = $writer->newReader();
$reader->output('toto-le-heros.csv');
|
