Created
January 31, 2019 10:50
-
-
Save alOneh/abf16eb08f07661bd2322283ce7c5498 to your computer and use it in GitHub Desktop.
A CsvReader with utf8 encoding
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php declare(strict_types=1); | |
namespace App\CSV; | |
use League\Csv\Reader; | |
use League\Csv\Statement; | |
use voku\helper\UTF8; | |
class CsvReader | |
{ | |
/** @var Reader */ | |
private $reader; | |
/** | |
* Returns a new CsvReader instance initialized with $content. | |
* $content is clean from UTF-8 weird characters. | |
* | |
* @param string $content | |
*/ | |
public function __construct(string $content) | |
{ | |
if (!$content) { | |
$content = ''; | |
} | |
$this->reader = Reader::createFromString(UTF8::clean($content, true, true, true)); | |
} | |
/** | |
* Returns the header of the CSV. | |
* | |
* @return array | |
*/ | |
public function getHeader(): array | |
{ | |
$this->reader->setHeaderOffset(0); | |
return $this->reader->getHeader(); | |
} | |
/** | |
* Extract a data sample of $length rows from the CSV. | |
* | |
* @param int $length | |
* | |
* @return array | |
*/ | |
public function extractSample(int $length): array | |
{ | |
$stmt = new Statement(); | |
$stmt = $stmt->offset(1)->limit($length); | |
$records = []; | |
foreach ($stmt->process($this->reader)->getRecords() as $record) { | |
$records[] = $record; | |
} | |
return $records; | |
} | |
public function getRecords(array $columns): iterable | |
{ | |
$this->reader->setHeaderOffset(0); | |
$records = (new Statement())->process($this->reader, $columns); | |
return $records; | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment