Ttdfjt

I want remove columns while exporting order grid data in magento 2. I google it but didn't find solution. Like I want to remove these fields from exported csv.

1. Payment Method


2. Total Refunded


3. Customer Group


4. Grand Total (Base)


5. Purchase Point

Try following way:

Create Vendor/Module/view/adminhtml/ui_component/sales_order_grid.xml

<?xml version="1.0" encoding="UTF-8"?>
<listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc/ui_configuration.xsd">
 <listingToolbar name="listing_top">
 <exportButton name="export_button" class="VendorModuleComponentExportButton" />
 </listingToolbar>
</listing>

And Create Vendor/Module/Component/ExportButton.php

namespace VendorModuleComponent;

use MagentoFrameworkViewElementUiComponentContextInterface;
use MagentoFrameworkUrlInterface;

class ExportButton extends MagentoUiComponentAbstractComponent

 /**
 * Component name
 */
 const NAME = 'exportButton';

 /**
 * @var MagentoFrameworkUrlInterface
 */
 protected $urlBuilder;

 /**
 * @param ContextInterface $context
 * @param UrlInterface $urlBuilder
 * @param array $components
 * @param array $data
 */
 public function __construct(
 ContextInterface $context,
 UrlInterface $urlBuilder,
 array $components = [],
 array $data = []
 ) 
 parent::__construct($context, $components, $data);
 $this->urlBuilder = $urlBuilder;
 

 /**
 * Get component name
 *
 * @return string
 */
 public function getComponentName()
 
 return static::NAME;
 

 /**
 * @return void
 */
 public function prepare()
 
 $config = $this->getData('config');
 if (isset($config['options'])) 
 $config['options'] = [];
 $this->setData('config', $config);
 
 parent::prepare();
 

Clear cache.

Right now it is not possible to change columns for export. See: https://github.com/magento/magento2/issues/3079

Extend MagentoUiModelExportConvertToCsv file in to your custom module to extend model file create di.xml

and in your extended file add below conditions to remove unwanted columns and column value in order export CSV Format.

if($component->getName()=='sales_order_grid')

 $fieldsVal = $this->metadataProvider->getFields($component);
 $removeFieldsArr = array('column names which you want to remove goes here ..');

 foreach($fieldsVal as $key=>$val) 
 if(in_array($val,$removeFieldsArr))
 unset($fieldsVal[$key]);
 
 
 $fields = array_values($fieldsVal);

 else
 $fields = $this->metadataProvider->getFields($component);
 

Let me do that for you with step by step. 
First Step: Register your export button in your: view/adminhtml/ui_component/[grid-view-id].xml

<exportButton name="export_button" class="NamespaceAdvancedReportComponentExportButton">
 <argument name="data" xsi:type="array">
 <item name="config" xsi:type="array">
 <item name="component" xsi:type="string">Magento_Ui/js/grid/export</item>
 <item name="displayArea" xsi:type="string">dataGridActions</item>
 <item name="options" xsi:type="array">
 <item name="cvs" xsi:type="array">
 <item name="value" xsi:type="string">csv</item>
 <item name="label" xsi:type="string" translate="true">CSV</item>
 <item name="url" xsi:type="string">my_advancedreport/export/gridToCsv</item>
 </item>
 </item>
 </item>
 </argument>
</exportButton>

Of course, you need a controller to do this thing: 

namespace NamespaceAdvancedReportControllerAdminhtmlExport;

class GridToCsv extends MagentoUiControllerAdminhtmlExportGridToCsv

 const ADMIN_RESOURCE = 'My_AdvancedReport::advanced_invoice_report';

Second Step: Modify your controller class to use custom Export Model. /code/Namespace/AdvancedReport/etc/di.xml (scope global or Adminhtml)

<type name="NamespaceAdvancedReportModelExportConvertToCsv">
 <arguments>
 <argument name="metadataProvider" xsi:type="object">NamespaceAdvancedReportModelExportMetadataProvider</argument>
 </arguments>
</type>
<type name="NamespaceAdvancedReportControllerAdminhtmlExportGridToCsv">
 <arguments>
 <argument name="converter" xsi:type="object">NamespaceAdvancedReportModelExportConvertToCsv</argument>
 </arguments>
</type>

Custom data provider to get what are selected columns user have selected on Admin.
app/code/Namespace/AdvancedReport/Model/Export/MetadataProvider.php
about the idea I have used MagentoUiModelBookmarkManagement. to get stored grid for Admin User while User Edit selected or sort-ordered columns of the Report Grid.

namespace NamespaceAdvancedReportModelExport;


use MagentoFrameworkViewElementUiComponentInterface;
use MagentoUiComponentMassActionFilter;
use MagentoFrameworkLocaleResolverInterface;
use MagentoFrameworkStdlibDateTimeTimezoneInterface;

class MetadataProvider extends MagentoUiModelExportMetadataProvider

 /**
 * @var MagentoUiModelBookmarkManagement
 */
 protected $_bookmarkManagement;

 /**
 * MetadataProvider constructor.
 * @param Filter $filter
 * @param TimezoneInterface $localeDate
 * @param ResolverInterface $localeResolver
 * @param string $dateFormat
 * @param MagentoUiModelBookmarkManagement $bookmarkManagement
 * @param array $data
 */
 public function __construct(
 Filter $filter,
 TimezoneInterface $localeDate,
 ResolverInterface $localeResolver,
 MagentoUiModelBookmarkManagement $bookmarkManagement,
 $dateFormat = 'M j, Y H:i:s A',
 array $data = [])
 
 parent::__construct($filter, $localeDate, $localeResolver, $dateFormat, $data);
 $this->_bookmarkManagement = $bookmarkManagement;
 

 protected function getActiveColumns($component)
 $bookmark = $this->_bookmarkManagement->getByIdentifierNamespace('current', $component->getName());

 $config = $bookmark->getConfig();
 $columns = $config['current']['columns'];
 $_activeColumns = [];
 foreach ($columns as $column => $config)
 if(true === $config['visible'] && $column != 'ids')
 $_activeColumns[] = $column;
 
 
 return $_activeColumns;
 
 /**
 * @param UiComponentInterface $component
 * @return UiComponentInterface[]
 * @throws Exception
 */
 protected function getColumns(UiComponentInterface $component)
 
 if (!isset($this->columns[$component->getName()])) 

 $activeColumns = $this->getActiveColumns($component);

 $columns = $this->getColumnsComponent($component);
 foreach ($columns->getChildComponents() as $column) 
 if ($column->getData('config/label') && $column->getData('config/dataType') !== 'actions') 
 if(in_array($column->getName(), $activeColumns)) 
 $this->columns[$component->getName()][$column->getName()] = $column;
 
 
 
 
 return $this->columns[$component->getName()];
 

Done.