PHP Excel2Any
Convert Excel to CSV
installation
Use composer for installation
composer require mostafazs/php-excel2any
or
Require the package using composer in composer.json file of your project:
"require": {
"mostafazs/php-excel2any": "1.*"
}Usage
<?php
include("./vendor/autoload.php");
use excel2any\excel2any;
use excel2any\RealRead;
use excel2any\Formats\FormatCSV;
use excel2any\Saver\SaveCSV;
$filename = __DIR__."/Products.xlsx";//Excel file name
$config = [
"startRow"=>1,//Excel file start row
"endRow"=>37,//Excel file end row
"inputFileType"=>"Xlsx",//dont change
"inputFileName"=>$filename,//Excel file name
"sheetname"=>"Sheet1",//Default sheet name
"range_start"=>"A",//Column start from
"range_end"=>"AM",//Column end to
];
$excel = new excel2any();
//Read excel file
$excel_read = new RealRead($config);
$readed = $excel_read->Read();
//Select Format Output Format..and pass read data
$csvFormat = new FormatCSV();
$csvdata = $csvFormat->Format($readed);
//Save Saver Class
$savecsv = new SaveCSV();
//Save File..pass $savecsv , $csvdata and input file name
$result = $excel->convert()->save($savecsv,$csvdata,$config['inputFileName']);
if($result){
echo "CSV File created";
}
?>Issue
Test
> phpunit tests
License
MIT
TODO
Write test
Donation
Your Stars Matter
If you find this package useful and you want to encourage me to maintain and work on it, Just press the star button to declare your willing.
Reward me with a cup of tea
Send me as much as a cup of tea worth in your country, so I'll have the energy to maintain this package.
Ethereum: 0x311B3d573CC839f79CB48D01b67eA09CCfA5aC48
