Set your directory name at https://github.com/BaseMax/MergeExcelFilesToOnePerColumns/blob/main/parser.php#L14, and number of files at https://github.com/BaseMax/MergeExcelFilesToOnePerColumns/blob/main/parser.php#L20.
Your directory should look like: 1.xlsx, 2.xlsx, 3.xlsx, 4.xlsx, etc....
Now convert all excel files to a single file by running:
php parser.php
Next open res.xlsx file in your excel or libreoffice...
© Copyright 2021 Max Base