Wallogit.com
2017 © Pedro Peláez
Convert CSV to array (Excel style is fully suppoted!)
Convert CSV to array/Iterator (Excel style is fully suppoted!), (*1)
, (*2)
As you know, PHP has built-in fgetcsv function.
But has some probrems:, (*3)
PHP5.3.3 or later, (*4)
Create or modify your composer.json, (*5)
``` json { "require": { "kzykhys/php-csv-parser": ">1.4" } }, (*6)
And run ``` sh $ php composer.phar install
1,"some text",150 2,"some multi line text",2000
``` php <?php, (*7)
require('./vendor/autoload.php');, (*8)
$parser = \KzykHys\CsvParser\CsvParser::fromFile('./test.csv'); $result = $parser->parse();, (*9)
var_dump($result);, (*10)
This is the same as: ``` php <?php require('./vendor/autoload.php'); $iterator = new \SplFileObject('./test.csv'); $parser = new \KzykHys\CsvParser\CsvParser($iterator); $result = $parser->parse(); var_dump($result);
``` php <?php, (*11)
require('./vendor/autoload.php');, (*12)
$parser = \KzykHys\CsvParser\CsvParser::fromString($string); $result = $parser->parse();, (*13)
var_dump($result);, (*14)
### Parse from array/Iterator ``` php <?php require('./vendor/autoload.php'); $parser = \KzykHys\CsvParser\CsvParser::fromArray(array('a,b,c,d', 'e,f,g,h')); $result = $parser->parse(); $iterator = new ArrayIterator(array('a,b,c,d', 'e,f,g,h')); $parser2 = new \KzykHys\CsvParser\CsvParser($iterator); $result2 = $parser2->parse(); var_dump($result); var_dump($result2);
The class \KzykHys\CsvParser\CsvParser itself is Traversable.
so You can convert CSV lines on-the-fly., (*15)
Following example is the best choice for performance:, (*16)
``` php <?php, (*17)
require('./vendor/autoload.php');, (*18)
$parser = \KzykHys\CsvParser\CsvParser::fromFile('./test.csv');, (*19)
foreach ($parser as $record) { // handles each record var_dump($record); } ```, (*20)
You can pass the options to 2nd argument of each static methods., (*21)
Available options are:, (*22)
| Option | Type | Description | Default |
|---|---|---|---|
| delimiter | string | The field delimiter (one character only) | , |
| enclosure | string | The field enclosure character (one character only) | " |
| encoding | string | The type of encoding | CP932 |
| offset | integer (>=0) | The sequence will start at that offset | 0 |
| limit | integer (>=-1) | Limit maximum count of records | -1 (unlimited) |
| header | array or false | Use the specified index instead of the column number | false |
Just run phpunit (PHPUnit is required), (*23)
Kazuyuki Hayashi (@kzykhys), (*24)
see CHANGELOG, (*25)
The MIT License, (*26)
Convert CSV to array (Excel style is fully suppoted!)
MIT
Convert CSV to array (Excel style is fully suppoted!)
MIT
Convert CSV to array (Excel style is fully suppoted!)
MIT