如何高效、规范地处理CSV文件？Keboola/CSV助你告别繁琐细节

<code class="bash">composer require keboola/csv</code>

<code class="php">require 'vendor/autoload.php';</code>

<pre class="brush:php;toolbar:false;">use Keboola\Csv\CsvReader;

$csvFile = new CsvReader(__DIR__ . '/_data/test-input.csv');

echo "读取CSV文件内容：\n";
foreach ($csvFile as $row) {
    var_dump($row);
}
// 假设 test-input.csv 内容为：
// header1,header2
// value1,value2
// "another value",with,comma
/* 输出示例：
array(2) {
  [0]=>
  string(7) "header1"
  [1]=>
  string(7) "header2"
}
array(2) {
  [0]=>
  string(6) "value1"
  [1]=>
  string(6) "value2"
}
array(2) {
  [0]=>
  string(13) "another value"
  [1]=>
  string(9) "with,comma"
}
*/

<pre class="brush:php;toolbar:false;">use Keboola\Csv\CsvReader;

$csvFile = new CsvReader(
    __DIR__ . '/_data/test-input.csv',
    CsvReader::DEFAULT_DELIMITER,
    CsvReader::DEFAULT_ENCLOSURE,
    CsvReader::DEFAULT_ESCAPED_BY,
    1 // 跳过第一行
);

echo "\n跳过第一行后读取CSV文件内容：\n";
foreach ($csvFile as $row) {
    var_dump($row);
}
// 此时输出将从 'value1,value2' 开始

<pre class="brush:php;toolbar:false;">use Keboola\Csv\CsvWriter;

$outputPath = __DIR__ . '/_data/test-output.csv';
$csvWriter = new CsvWriter($outputPath);

$rowsToWrite = [
    ['Header A', 'Header B'],
    ['First Row Col1', 'First Row Col2'],
    ['Second Row Col1', 'Second Row Col2 with,comma'], // 自动处理逗号
];

echo "\n写入CSV文件：\n";
foreach ($rowsToWrite as $row) {
    $csvWriter->writeRow($row);
}
echo "数据已写入到 {$outputPath}\n";
// test-output.csv 内容示例：
// "Header A","Header B"
// "First Row Col1","First Row Col2"
// "Second Row Col1","Second Row Col2 with,comma"

<pre class="brush:php;toolbar:false;">use Keboola\Csv\CsvWriter;

$fileName = __DIR__ . '/_data/test-append.csv';
// 确保文件存在，或者先写入一些初始数据
file_put_contents($fileName, "Initial A,Initial B\n");

$fileHandle = fopen($fileName, 'a'); // 以追加模式打开文件
$csvWriter = new CsvWriter($fileHandle);

$rowsToAppend = [
    ['Appended Row1 Col1', 'Appended Row1 Col2'],
    ['Appended Row2 Col1', 'Appended Row2 Col2'],
];

echo "\n追加数据到CSV文件：\n";
foreach ($rowsToAppend as $row) {
    $csvWriter->writeRow($row);
}
fclose($fileHandle); // 记得关闭文件句柄
echo "数据已追加到 {$fileName}\n";
// test-append.csv 内容示例：
// Initial A,Initial B
// "Appended Row1 Col1","Appended Row1 Col2"
// "Appended Row2 Col1","Appended Row2 Col2"

<pre class="brush:php;toolbar:false;">use Keboola\Csv\CsvWriter;

$outputPathWindows = __DIR__ . '/_data/test-output-windows.csv';
$csvWriter = new CsvWriter(
    $outputPathWindows,
    CsvWriter::DEFAULT_DELIMITER,
    CsvWriter::DEFAULT_ENCLOSURE,
    "\r\n" // 指定Windows风格的换行符
);

$rowsForWindows = [
    ['Col1 Win', 'Col2 Win'],
    ['Col3 Win', 'Col4 Win'],
];

echo "\n写入Windows风格换行符的CSV文件：\n";
foreach ($rowsForWindows as $row) {
    $csvWriter->writeRow($row);
}
echo "数据已写入到 {$outputPathWindows} (使用Windows换行符)\n";