Laravel-excel: [QUESTION] how do i set custom headers when downloading?

[G3z]

as stated above.. is it possible to set custom response headers ?

[patrickbrouwers]

Second param of ->export(fileType, [headers]) accepts an array of headers

[CHOMNANP]

Any example please.
Thanks.

[singuyen306]

Hello,

I've set second param as array for export function. But not working. Please see my code bellow.
Please help me. Thanks.

Source:
public function example(){
$action = new ActionRepository();
$items = $action->all('ev_no asc');
Excel::create('items', function($excel) use($items) {
$excel->sheet('ExportFile', function($sheet) use($items) {
$sheet->fromArray($items, null, 'A1', false, false);
});
})->export('csv', ['イベントNo', 'メッセージ', '商品分類コード', '登録単位', '設定値', 'タイミング']);
}

Result:
"1001","最終購入から[設定値]ヶ月以上経過してます。状況を把握してください。","","月","12"
"1101","最終購入から[設定値]年経過しました。メンテナンスを勧めてみませんか？","","年","3"
"1102","最終購入から[設定値]年経過しました。メンテナンスを勧めてみませんか？","","年","3"
"2001","次の活動予定日が入力されていません。","","",""
"2101","次の活動予定日から[設定値]日以上経過しています。完了している場合は完了日を入力してください。","","日","2"
"3001","来月、決算月を迎える顧客です。","","日","10"
"3102","来月、設立1周年を迎える顧客です。","","周年","1"
"3103","来月、設立3周年を迎える顧客です","","周年","3"
"3201","来月、設立5×n周年を迎える顧客です。","","周年","5"
"3301","顧客情報の更新タイミングです。","","日","1"

[andreshg112]

How can I do this with version 3.1?

[patrickbrouwers]

@andreshg112 from the docs: You can customize the download headers with the optional 3rd parameter $headers (https://docs.laravel-excel.com/3.1/exports/export-formats.html#export-formats)

[andreshg112]

@patrickbrouwers, thank you! What about if I use IlluminateContracts\Support\Responsable? My controller looks like this:

[patrickbrouwers]

@andreshg112 that's not supported on the current release yet. Next release will have ability to set the headers inside the export class.