Laravel excel объединение ячеек

Обновлено: 06.01.2025

Laravel Excel v2.3.* for Laravel 5.x, 6.x, 7.x and 8.x

Laravel Excel brings the power of PHPOffice's PHPExcel to Laravel 5 with a touch of the Laravel Magic. It includes features like: importing Excel and CSV to collections, exporting models, array's and views to Excel, importing batches of files and importing a file by a config file.

Import into Laravel Collections
Export Blade views to Excel and CSV with optional CSS styling
Batch imports
A lot of optional config settings
Easy cell caching
Chunked and queued importer
ExcelFile method injections
Editing existing Excel files
Advanced import by config files
and many more.

Require this package in your composer.json and update composer. This will download the package and PHPExcel of PHPOffice.

In Laravel 5.5 or higher, this package will be automatically discovered and you can safely skip the following two steps.

If using Laravel 5.4 or lower, after updating composer, add the ServiceProvider to the providers array in config/app.php

You can use the facade for shorter code; if using Laravel 5.4 or lower, add this to your aliases:

The class is bound to the ioC as excel

To publish the config settings in Laravel 5 use:

This will add an excel.php config file to your config folder.

Support only through Github. Please don't mail us about issues, make a Github issue instead.

ALL bug fixes should be made to appropriate branch (e.g. 2.0 for 2.0.* bug fixes). Bug fixes should never be sent to the master branch.

This package is licensed under MIT. You are free to use it in personal and commercial projects. The code can be forked and modified, but the original copyright author should always be included!

Supercharged Excel exports and imports

A simple, but elegant Laravel wrapper around PhpSpreadsheet exports and imports.

Easily export collections to Excel. Supercharge your Laravel collections and export them directly to an Excel or CSV document. Exporting has never been so easy.

Supercharged exports. Export queries with automatic chunking for better performance. You provide us the query, we handle the performance. Exporting even larger datasets? No worries, Laravel Excel has your back. You can queue your exports so all of this happens in the background.

Supercharged imports. Import workbooks and worksheets to Eloquent models with chunk reading and batch inserts! Have large files? You can queue every chunk of a file! Your entire import will happen in the background.

Export Blade views. Want to have a custom layout in your spreadsheet? Use a HTML table in a Blade view and export that to Excel.

🎓 Learning Laravel Excel

You can find the full documentation of Laravel Excel on the website.

Laravel Excel is created with love and care by Spartner (formerly known as Maatwebsite) to give back to the Laravel community. It is completely free (MIT license) to use, however the package is licensed as Postcardware. This means that if it makes it to your production environment, we would very much appreciate receiving a postcard from your hometown.

Spartner
Markt 2
6231 LS Meerssen
The Netherlands.

Created by Spartner (formerly Maatwebsite)

We are a strategic development partner, creating web-based custom built software from Laravel. In need of a digital solution for your challenge? Give us a call.

Supercharged Excel exports and imports

A simple, but elegant Laravel wrapper around PhpSpreadsheet exports and imports.

Easily export collections to Excel. Supercharge your Laravel collections and export them directly to an Excel or CSV document. Exporting has never been so easy.

Export Blade views. Want to have a custom layout in your spreadsheet? Use a HTML table in a Blade view and export that to Excel.

🎓 Learning Laravel Excel

You can find the full documentation of Laravel Excel on the website.

Spartner
Markt 2
6231 LS Meerssen
The Netherlands.

Created by Spartner (formerly Maatwebsite)

We are a strategic development partner, creating web-based custom built software from Laravel. In need of a digital solution for your challenge? Give us a call.

Импорт файла excel следующим образом:

См изображение ниже где проблема:

2 ответа

Я не могу обновить существующие ячейки excel, они объединены и граничат. Я создал файл Excel со стилем и использую его в качестве шаблона. В моем коде - > сначала прочтите этот файл Excel и обновите ячейки, которые я хочу. Никакие ячейки слияния не были в порядке . Но объединенные ячейки не могут.

Я получил сотни листов Excel, содержащих объединенные ячейки. Отправитель настаивает на использовании Excel и слиянии ячеек - я ничего не могу с этим поделать. Как я могу прочитать их, используя R? Например, упрощенная версия проблемной области входного листа может выглядеть примерно так, где.

Вам придется читать этот файл по-другому, вы не можете использовать простые методы импорта. Вы должны прочитать его по координате, пример собственных методов PHPExcel:

Надеюсь, это поможет.

Просто проверил конфигурацию, и мы можем установить 'slugged_with_count' в заголовке, так что результаты становятся похожими на картинку ниже. Или отключите заголовок и полагайтесь на порядок столбцов.