popy-dev/php-csv

PHP的CSV操作工具

dev-master 2018-02-10 10:02 UTC

This package is not auto-updated.

Last update: 2024-09-25 14:27:38 UTC


README

这是一个完全面向对象的CSV读取(即将支持写入)工具包,提供各种类以简化CSV文件操作

安装

使用php composer.phar require popy-dev/php-csv:dev-master进行安装

文档

  1. 基本用法
  2. 工厂

基本用法

<?php

use Popy\Csv\Reader\SplFileInfoReader;

$file = new SplFileInfo('/path/to/file.csv');
$reader = new SplFileInfoReader($file);

foreach ($reader as $key => $value) {
  // ...
}

如何处理Microsoft编码?

<?php
use Popy\Csv\Reader\CharsetConverterReader;

$rawReader = ...; // Initialize any reader you want (SplFileInfoReader for instance)
$reader = new CharsetConverterReader($rawReader, 'Windows-1252', 'UTF-8');

foreach ($reader as $key => $value) {
  // ...
}

需要命名列吗?

固定列标题

<?php
use Popy\Csv\Reader\NamedColumnReader;

$rawReader = ...; // Initialize any reader you want (SplFileInfoReader for instance)
$reader = new NamedColumnReader($rawReader, array('col1', 'col2'));

foreach ($reader as $key => $value) {
  // ...
}

替代方法:使用第一行作为列名

<?php
use Popy\Csv\Reader\AutoNamedColumnReader;

$rawReader = ...; // Initialize any reader you want (SplFileInfoReader for instance)
$reader = new AutoNamedColumnReader($rawReader);

foreach ($reader as $key => $value) {
  // ...
}