PHP Classes

PHP Merge Excel Files Merge Excel Files To One Per Column: Create an Excel file from other spreadsheet values

Recommend this page to a friend!
  Info   View files Example   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog (1)    
Last Updated Ratings Unique User Downloads Download Rankings
2023-05-29 (18 days ago) RSS 2.0 feedNot yet rated by the usersTotal: 56 This week: 5All time: 10,394 This week: 25Up
Version License PHP version Categories
mergeexcelfilestoone 1.0.0GNU General Publi...5Files and Folders
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.

Picture of Max Base
  Performance   Level  
Name: Max Base <contact>
Classes: 5 packages by
Country: United States United States
Innovation award
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

  Files folder image Files  
File Role Description
Plain text file excel-create.php Class Class source
Plain text file excel.php Class Class source
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file parser.php Example Example script
Accessible without login Plain text file README.md Doc. Documentation

 Version Control Unique User Downloads Download Rankings  
 100%
Total:56
This week:5
All time:10,394
This week:25Up