Need help with php-csv?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

keboola
126 Stars 35 Forks MIT License 129 Commits 6 Opened issues

Description

CSV reader/writer

Services available

!
?

Need anything else?

Contributors list

Keboola CSV reader/writer Build Status

Latest Stable Version License Total Downloads Maintainability Test Coverage

The library provides a simple reader and writer for CSV files according to RFC4180. The library is licensed under the MIT license. The library provides classes

CsvReader
and
CsvWriter
for reading and writing CSV files. The classes are designed to be immutable and minimalistic.

Usage

Read CSV

$csvFile = new Keboola\Csv\CsvReader(__DIR__ . '/_data/test-input.csv');
foreach($csvFile as $row) {
    var_dump($row);
}

Skip lines

Skip the first line:

$csvFile = new \Keboola\Csv\CsvFile(
    $fileName,
    CsvFile::DEFAULT_DELIMITER,
    CsvFile::DEFAULT_ENCLOSURE,
    CsvFile::DEFAULT_ESCAPED_BY,
    1
)
foreach($csvFile as $row) {
    var_dump($row);
}

Write CSV

$csvFile = new Keboola\Csv\CsvWriter(__DIR__ . '/_data/test-output.csv');
$rows = [
    [
        'col1', 'col2',
    ],
    [
        'first column', 'second column',
    ],
];

foreach ($rows as $row) { $csvFile->writeRow($row); }

Append to CSV

$fileName = __DIR__ . '/_data/test-output.csv';
$file = fopen($fileName, 'a');
$csvFile = new Keboola\Csv\CsvWriter($file);
$rows = [
    [
        'col1', 'col2',
    ],
    [
        'first column', 'second column',
    ],
];

foreach ($rows as $row) { $csvFile->writeRow($row); } fclose($file);

Write CSV With Windows new-lines

$csvFile = new Keboola\Csv\CsvWriter(
    'test-output.csv',
    CsvWriter::DEFAULT_DELIMITER,
    CsvWriter::DEFAULT_ENCLOSURE,
    "\r\n"
)
$rows = [
    [
        'col1', 'col2',
    ],
    [
        'first column', 'second column',
    ],
];

foreach ($rows as $row) { $csvFile->writeRow($row); }

Installation

The library is available as composer package. To start using this library in your project follow these steps:

Install package:

composer require keboola/csv

Add autoloader in your bootstrap script:

require 'vendor/autoload.php';

Read more in Composer documentation

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.