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 (4 months ago) RSS 2.0 feedNot enough user ratingsTotal: 70 All time: 10,172 This week: 101Up
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.

Innovation Award
PHP Programming Innovation award winner
June 2023
Winner
Excel is a popular tool for creating spreadsheets. It saves spreadsheet data in XML-based format, which usually is called XLSX.

This XML format makes it easy for PHP developers to process and create spreadsheet files in Excel XSLX format.

This package provides a script that uses an Excel parser and generator classes to show how to parse several Excel spreadsheet files and combine their values to generate a new spreadsheet that merges the importance of all spreadsheets in a single spreadsheet.

This way, other developers can learn to process multiple spreadsheets and combine them in a way that is convenient for their application purposes.

Manuel Lemos
Picture of Max Base
  Performance   Level  
Name: Max Base <contact>
Classes: 5 packages by
Country: United States United States
Age: ???
All time rank: 2626361 in United States United States
Week rank: 179 Up19 in United States United States Up
Innovation award
Innovation award
Nominee: 3x

Winner: 1x

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:70
This week:0
All time:10,172
This week:101Up