unicframework / csv-parser
CSVParser parse csv data to array, object, and json.
v1.1.1
2021-05-13 05:27 UTC
Requires
- php: >=5.6
README
CSVParser library parse csv data to array, object, and json format. CSVParser convert array, object, json to csv format.
Features
- Parse data from csv file, array, json and objects.
- Parse csv to array and array to csv.
- Parse csv to object and object to csv.
- Parse csv to json and json to csv.
- Set custom headers to csv file.
Installation
- Install
composer
if you have not installed.
composer require unicframework/csv-parser
Parse Data
use CSVParser\CSV; $csv = new CSV(); //Parse data from csv file $csv->parse('data.csv'); //Parse array data $csv->parse($arrayData); //Parse object data $csv->parse($jsonData); //Parse json data $csv->parse($objectData);
Get Parsed Data
//Get header $header = $csv->getHeader(); //Get parsed data to array format $data = $csv->toArray(); //Select data from parsed data $data = $csv->toArray(['Name', 'Email']); //Get parsed data to object format $data = $csv->toObject(); //Select data from parsed data $data = $csv->toObject(['Name', 'Email']); //Get parsed data to json format $data = $csv->toJson(); //Select data from parsed data $data = $csv->toJson(['Name', 'Email']); //Get parsed data to csv format $data = $csv->toCsv(); //Select data from parsed data $data = $csv->toCsv(['Name', 'Email']);
Get Row Count
//Get row count $rows = $csv->rowCount(); //Get header count $cols = $csv->headerCount();
Select Data Limit
//Select 10 records $csv->limit(10); $data = $csv->toArray(); //Select from 5 to 10 records $csv->limit(5, 10); $data = $csv->toArray();
Set CSV Header
//Ignore header from csv file $csv->ignoreHeader(true); //Ignore csv header cse $csv->ignoreHeaderCase(true); //Ignore csv enclosure $csv->ignoreEnclosure(true); //Set header offset of csv file $csv->headerOffset(0); //Set custom header to csv file $csv->setHeader(['Name', 'Email']);
Set CSV Delimiter
Default csv delimiter is ,
but we can set other delimiter for csv file.
//Set delimiter $csv->setDelimiter('|'); //Set enclosure $csv->setEnclosure('"'); //Set escape character $csv->setEscape('//'); //Parse csv file data $csv->parse('data.csv'); //Get data from parsed data $data = $csv->toArray();
Aggregate Functions
//Parse csv file data $csv->parse('data.csv'); //Get total sum of given field $total_price = $csv->sum('price'); //Get minimum from given field $min_price = $csv->min('price'); //Get maximum from given field $max_price = $csv->max('price'); //Get average of given field $average_price = $csv->average('price');