mostafazs/php-excel2any

Convert Excel to CSV

1.0.2 2022-09-29 19:28 UTC

Requires

• php: >=7.2.1
• phpoffice/phpspreadsheet: ^1.19

Requires (Dev)

• phpunit/phpunit: 6.*

MIT

• Mostafa Ziasistani

• excel
• csv
• convert
• converter

README

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

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