Adding style to sheets

[ghotgalkar]

How do you use the view across all the sheets? Currently only the first sheet has the styles in the view applied to it. The code I use is below:

$excel_file = Excel::loadView("export.excel")
->sheet('Daily')->with( $daily_array )->setColumnWidth( $widths )->setColumnFormat( $formats )
->sheet('Hourly')->with( $hourly_array )->setColumnWidth( $widths )->setColumnFormat( $formats )
->setTitle('WebsiteExport');

$excel_file->export('xls');

The Column width and format works fine.

[ghotgalkar]

I have currently sorted this by using the PHPExcel object inside laravel4-PHPExcel object

[MaatwebsiteSupport]

Sorry for the late answer, soon we will look into a more Laravalesque way of doing it :)

[MaatwebsiteSupport]

Example usages:

Excel::loadView('excel.reports')
    ->sheet('Daily', function($sheet) use($dailyReports) {

        $sheet->withReports($dailyReports);

    })->sheet('Weekly', function($sheet) use($weeklyReports) {

        $sheet->withReports($weeklyReports);

    })->setTitle('Reports')->export('xls');