Is it possible to hide a column?

[alexv96]

I have a project where is a code for 2 different customers, the issue is that by default I register in the exporter the columns, and I would like to know if there is a way to hide or remove columns.

For example:
Customer 1 must see the column and the product code.
Customer 2 should not see the column and the product code.

This is my code

class LeadsSellerExport implements FromCollection,WithHeadings,ShouldAutoSize,WithEvents
{
    protected $leads;

    function __construct($leads) {
        $this->leads = $leads;
    }
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        return $array = $this->leads->map(function ($lead, $key){
            return [
                //'id'                => $lead->id,
                'contact_id'        => ($lead->contact_id != null ? $lead->contact->full_name : ''),
                'rut'               => ($lead->contact_id != null ? $lead->contact->rut : null ),
                'phone'             => ($lead->contact_id != null ? $lead->contact->phone : '' ),
                'email'             => ($lead->contact_id != null ? $lead->contact->email : '' ),
                'score'             => (Project::checkType($lead->contact->project_id) ? $lead->contact->score : ''),
                'live_leases'       => ($lead->ticket_id === null ? 'Vivir' : ($lead->ticket->live_leases == 2 ? 'Vivir' : ($lead->ticket->live_leases == 1 ? 'Arrendar' : 'Vivir'))),
                'purchase_date'     => ($lead->contact_id === null ? 'Aún no lo defino' : ($lead->contact->purchase_date ? $lead->contact->purchase_date : 'Aún no lo defino')),
                'approved_credit'   => ($lead->ticket_id === null ? 'No' : ($lead->ticket->approved_credit == 2 ? 'Si' : ($lead->ticket->approved_credit == 1 ? 'No' : 'No'))), 
                'source'            => ($lead->ticket_id === null || $lead->ticket->source_id === null ? '' : Source::find($lead->ticket->source_id)->name),
                'project_id'        => ($lead->contact->project_id != null ? \App\Project::find($lead->contact->project_id)->name : ''),
                'user_id'           => ($lead->user_id != null ? $lead->user->getFullName() : ''),
                'status_id'         => ($lead->status_id != null ? $lead->status->name : ''),
                'reason_id'         => ($lead->reason_id != null ? \App\LostReason::find($lead->reason_id)->motive : ''),
                'last_lead'         => ($lead->last_lead != null ? Carbon::parse($lead->last_lead)->format('d-m-Y') : ''),
                
                //if (1>2) {
                    'level_interest'    => ($lead->ticket->field_data != null ? Field::getValueInterest($lead->ticket->field_data) : '' ),
                //}
                
                'last_comment'      => ($lead->comments != null ? Comment::lastComment($lead->id) : '')
            ];
        });
    }

    /**
     * @return array
     */
    public function registerEvents(): array
    {
        return [
            AfterSheet::class    => function(AfterSheet $event) {
                $cellRange = 'A1:W1'; 
                $event->sheet->getDelegate()->getStyle($cellRange)->getFont()->setSize(14);
                
                $event->sheet->getDelegate()->setAutoFilter('A1:O1');
            },
        ];
    }

    public function headings():array{
        return [
            //'#',
            'Contact',
            'Rut',
            'Phone',
            'Email',
            'Score',
            'Live',
            'Purchase date',
            'Credit Card',
            'Source',
            'Project',
            'User',
	    'Status',
            'Lost',,
            'updated_at',
            'LEVEL', //This data is optional, show  only if the data is enabled
            'Comment',
        ];
    }
}

[patrickbrouwers]

setVisible just collapses the column. If you want the data to really be invisible for customer 2, you can better remove that data from the export when requested by customer 2.

[alexv96]

@patrickbrouwers I have tried to eliminate it or at least to put a conditional so that it does not show it to me, but in the return it throws error to me it does not allow me to put conditionals.

I attach the complete code,

[patrickbrouwers]

You can't add an if-statement inside an array.

Do something like

$array = [

];

if ($customer is 2)
$array['level_interest'] = '';
}

return $array;