laravel excel setting header

When using Laravel Excel, setting the header is a very important task. Table headers are often used to specify the names of columns contained in Excel files and make the data set easier to understand and analyze. In this article, we will explain how to set the header.

Laravel Excel is an open source tool that we can use to read, operate and export Excel files. It provides a simple and elegant way to process Excel files and makes the generation process of Excel files More relaxed.

Laravel Excel exports data by setting table headers. Before we generate an Excel file, we need to define the header of the Excel file. This process is usually called defining the header row.

The following are some methods of setting headers, let’s get started!

1. Use the withHeadings() method

The withHeadings() method is a built-in method provided by Laravel Excel, which allows us to define table headers. This method accepts an array as a parameter, and each element of the array is the value of a header cell.

Sample code:

use MaatwebsiteExcelFacadesExcel;

Excel::create('my_excel_file', function($excel) {
    $excel->sheet('Sheet 1', function($sheet) {
        $header = ['Name', 'Email', 'Phone'];
        $data = [
            ['John Doe', 'johndoe@gmail.com', '123-456-7890'],
            ['Jane Doe', 'janedoe@gmail.com', '123-456-7890'],
            ['Bob Smith', 'bobsmith@gmail.com', '123-456-7890']
        ];

        $sheet->with($data)->withHeadings($header);
    });
})->download('xlsx');

In this example, we define a header array containing "Name", "Email" and "Phone" and pass it to withHeadings( )method.

2. Use fromArray() method

The fromArray() method is another way to set the table header. Unlike the withHeadings() method, we do not need to use the fromArray() method to specify the headers and data separately.

Sample code:

use MaatwebsiteExcelFacadesExcel;

Excel::create('my_excel_file', function($excel) {
    $excel->sheet('Sheet 1', function($sheet) {
        $data = [
            ['Name', 'Email', 'Phone'],
            ['John Doe', 'johndoe@gmail.com', '123-456-7890'],
            ['Jane Doe', 'janedoe@gmail.com', '123-456-7890'],
            ['Bob Smith', 'bobsmith@gmail.com', '123-456-7890']
        ];

        $sheet->fromArray($data);
    });
})->download('xlsx');

In this example, we define the entire table as an array, including the header and data, and pass it to the fromArray() method.

3. Extract data from the database and set the header

We can use Laravel Model to extract data from the database. We can use the withHeadings() method to set the headers.

Sample code:

use AppUser;
use MaatwebsiteExcelFacadesExcel;

Excel::create('my_excel_file', function($excel) {
    $excel->sheet('Sheet 1', function($sheet) {
        $users = User::select('id', 'name', 'email')->get()->toArray();
        $sheet->with($users)->withHeadings(['ID', 'Name', 'Email']);
    });
})->download('xlsx');

In this example, we use Eloquent to get the user data and convert it into an array. Next, we use the withHeadings() method to set the headers.

Conclusion

In this article, we introduced three methods of setting Laravel Excel header. Whether you use the withHeadings() method, fromArray() method or extract data from the database and set headers, Laravel Excel makes generating Excel files very simple. Hope this article can help you use Laravel Excel better.

The above is the detailed content of laravel excel setting header. For more information, please follow other related articles on the PHP Chinese website!