Laravel-Excel | Supercharged Excel exports and imports in Laravel | CSV Processing library

I have a full working export using latest laravel-excel (3.1.34).

I need to add some text before first data rowm, so I want to write header row starting from row 3

How can I do this?

The headingRows method is used internally only when importing and ignored while exporting.

As workaround, can I 'add rows manually' in the 'after sheet' event?

When using Laravel Excel 3.1 for exporting data it should format dates to dates and time to time. However both date and time are turned into Custom.

I have the following export:

I use this library to export data from collection to excel file. By default I et columns names as namesd of table fields.

How to replace names of colums on own?

I have own abstract class:

I'm using Laravel 5.8 and laravel-excel for exporting some data into an Excel file.

So I added this method to the Model:

I need to export huge amount of rows to Excel. I am using Laravel-excel. I followed all the suggestions given in documentation for exporting large database.

I'm trying to export xlsx file that includes around 100,000 rows for 12 months each sheet take one month in laravel 8 using Maatwebsite Excel This process takes around 15~30 mint, So I use a queue in laravel excel in order to keep the job run in the background and notify the user when it finishes. During the process php artisan queue:work --memory=10240 it stops and it shows this error in terminal

If I run php artisan queue:work the process will stop and the job still in jobs table when I run it again it fail and it shows in failed_jobs table with this error

Illuminate\Queue\MaxAttemptsExceededException: Maatwebsite\Excel\Jobs\AppendQueryToSheet has been attempted too many times or run too long. The job may have previously timed out.

What I try to dose and not work with me

1- changing memory_limit post_max_size upload_max_filesize in php.ini I use WAMP SERVER

2- changing th memory_limit => 6000000 and chunk_size => 1100 in config/excel.php.

Also, I notice all exported files stop at size 555KB

The code to export use queue

class MarkupAccountsYears

I have an excel with multiple sheets but i only want read one sheet:

My problem is that i have multiple sheets, and they do not have the same order or the same number of pages. Then, i must identify the sheet by name on my import class (laravel import).

Here is my import class:

I'm pretty new to working with json and importing csv/excel files, so perhaps there is a super simple answer to this question.

I have a json field in my database and I can export all data without issues. In my CSV file the data from that particular field looks like below:

I'd like to ask.

I want to make excel import feature using laravel-excel package. Which, the data I imported has relational values ​​to another table.

so, when i import excel it will save the data in two tables.

the first table, stores data such as name and file path. And the second table, saves the details of the imported excel file and adds the relationship to the first table.

below are the two tables that I have

booked_vouchers:

• id
• name
• path

booked_voucher_details:

• id
• booked_voucher_id
• voucher_code
• course_code
• user_name

and below are the codes that I have made in the controller, view and import files.

Form