Ignore column on export

[OrakFR]

First of all, I'd like to express my appreciation for livewire-powergrid and to thank you @luanfreitasdev and the entire community for your dedication to developing and maintaining it.

I have a question regarding the export functionality:
Is there a way to exclude specific columns from being exported to Excel or CSV in PowerGrid, even if they are visible on the screen? While I know that hiding the columns can accomplish this, I'm looking for a method to selectively force control the visibility of columns specifically for export purposes.

Any assistance would be appreciated.

[dansysanalyst]

Hi @OrakFR,

You can use visibleInExport.

For example:

//MyPowergridTable.php

 public function columns(): array
 {
    return [
        Column::make('ID', 'id')
            ->searchable()
            ->visibleInExport(false) //Hide in export
            ->sortable(),

        Column::make('Name', 'name')
            ->searchable()
            ->hidden()
            ->visibleInExport(true)  //Show in export
            ->sortable(),

        Column::make('Created At', 'created_at_formatted') // By default, shows in export.
    ];
  }

[OrakFR]

Thank you @dansysanalyst! I missed it in the documentation...