SuryaElite

# This program will merge all the csv files to a single large file. Headers should be same.
# sampleFile.csv = Provide a file that contains the header of csv.

{ head -n1 sampleFile.csv; for f in *.csv; do tail -n+2 "$f"; done; } > largeFile.csv

SuryaElite

<?php

function convertXLStoArray($infile, $outfile){
 
    if(!file_exists($infile) || !is_readable($infile) || !file_exists($outfile) || !is_readable($outfile))
    return FALSE;
 
    $fileType = PHPExcel_IOFactory::identify($infile);
    $objReader = PHPExcel_IOFactory::createReader($fileType);