mercredi 5 février 2020

how to set the columns in an excel using Maatwebsite using laravel 5.4

Hi i have this download csv. Now my problem is i want to get the certain columns for my excel file not all fields from the database to be pulled to csv. Now my download csv works good and could download the data. Now i want that only certain columns to be displayed into my csv file. the getCell code wont work. This is my code below

//download csv all pending
    public function downloadExcelAllPending($type){
        $data = BookingHistory::orderBy('checkin_date', 'desc')->get()->toArray();

        return Excel::create('booking_history', function($excel) use ($data) {

        $excel->sheet('mySheet', function($sheet) use ($data)
        {

            $sheet->getCell('A1')->setValue('first_name');
            $sheet->fromArray($data);


         });

        })->download($type);

Now this line of code here $sheet->getCell('A1')->setValue('first_name'); won't work. Can someone help me figured this thing out?. Any help is muchly appreciated. TIA.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire