Last Updated | | Ratings | | Unique User Downloads | | Download Rankings |
2023-05-29 (18 days ago) | | Not yet rated by the users | | Total: 56 This week: 5 | | All time: 10,394 This week: 25 |
|
Description | | Author |
This package can create an Excel file from other spreadsheet values.
It provides a script that uses Excel reader classes to parse multiple Excel spreadsheets in XLSX format to extract the values of their cells.
The script can combine the values of all the parsed spreadsheets and generates a single spreadsheet file in Excel XLSX format that merges the importance of all spreadsheets into one with a sheet with the values of other spreadsheets in multiple columns. | |
|
|
Innovation award
Nominee: 3x |
|
Details
Merge Excel Files to single excel file per columns
Using
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
|
Applications that use this package |
|
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.