[QUESTION] How can I concatenate all the rows from identically formatted XSLX files into one Spreadsheet ?

[ftrudeau]

Prerequisites

• [ x] Have read and understood: https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/.github/SUPPORT.md
• [x ] Checked if your Laravel Excel version is still supported: https://docs.laravel-excel.com/3.1/getting-started/support.html#supported-versions
• [x ] Checked that your question isn't already asked before.
• [ x] Filled in the entire issue template

Versions

• PHP version: PHP 7.2.19 (cli) (built: May 29 2019 13:58:59) ( ZTS MSVC15 (Visual C++ 2017) x64 )
• Laravel version: 5.7.28
• Package version: 3.1.19

Description

I have hundreds of XLSX spreadsheets with those properties :

• Each spreadsheet has only one worksheet
• Each worksheet has exactly the same number of columns, formulas + formatting
• Each worksheet can contain a number of rows varying from 1 to 1000.

Essentially, I want to concatenate all the rows from all the spreadsheet into a single new spreadsheet, while retaining the formatting, headers, formulas, properties and etc.

Similar question was asked 2 years ago, but it is for version 2.x and the proposed solution seams to add a new sheet to the "merged" spreadsheet, which is not the desired behavior.

Any help would be appreciated, thanks !

[patrickbrouwers]

In 3.1 you need to use PhpSpreadsheet directly through one of the exposed events, we currently don't have out of the box support for it. Multiple proposals have been made to make similar things possible, so I'll close this one.