Ability to export specific columns

[catfireparty]

I'm submitting a ...

[ x] feature request

I'd like the capability to export only selected columns from the DataTable.

e.g. dt.exportCSV(['columnTwo', 'columnFour'])

As it currently stands, it is impossible to select only the content of a single column for cut and paste, custom export would solve this in lieu of cell selection (and probably be easier to implement)

[pchristou]

@cagataycivici any plans on including something like this in a future release? I checked the roadmap and the only thing I saw related to export was "More export options like pdf and excel"

[pchristou]

Any update on this?

[cagataycivici]

Planned for 4.1.1.

[kenisteward]

@cagataycivici @jdpearce

Just to give info on my research of the component I'll lay this here. You can currently actually say which columns you want to export but it is slightly hacky (in my opinion) and definitely not recorded in the docs.

As you can see here
https://github.com/primefaces/primeng/blob/master/src/app/components/datatable/datatable.ts#L2137

the exportCsv function is base don the data table and specifically makes sure you have data AND a column with the FIELD property that is truthy (e.g. not null / undefined /empty string).

Because of this you can actually do something sneaky and say

in html

    <p-dataTable #dt [value]="data" exportFilename="data-objects">
      <p-header>
          <button type="button" pButton icon="fa-download" iconPos="left" label="Download CSV" (click)="export(dt)"></button>
      </p-header>
      <p-column *ngFor="let col of cols" [hidden]="col.hide" [sortable]="col.sortable" [field]="col.field [header]="col.header">
      </p-column>
    </p-dataTable>

in component

  public export(e: DataTable) {
     // store the columns you want to not export
    const hiddenColumns: any[] = [];
    e.columns.forEach((c) => {
       // search for whatever criteria you care for.  in my use case if the column is hidden i don't want to export that data
      if (c.hidden === true ) {
        hiddenColumns.push({field: c.field, col: c});
        c.field = '';
      }
    });

    e.exportCSV();
    // restore their fields so databinding and such still works in the future
    hiddenColumns.forEach((hc) => {
      hc.col.field = hc.field;
    });
  }

so instead of just calling dt.exportCSV() I've done some pre processing the datatable's data that it uses in the export function.

What would probably be preferable is there are API settings that hook into this function that only show fields based on either callback criteria or setting criteria. But this works fine currently.

[pantonis]

Any news on this feature?

[cagataycivici]

Planned for 4.1.1

[pantonis]

Thanks

[pantonis]

Was this implemented in 4.1.1?

[Mrtcndkn]

No, We rescheduled it for another release 4.1.2

Regards

[kenisteward]

I made a response about being able to export a specific column. Basically if it is hidden it won't get exported so you can. Loop though on export and hide the ones you don't want exported

…

On Thu, Jul 20, 2017, 7:04 AM Mertcan Diken ***@***.***> wrote: No, We rescheduled it for another release 4.1.2 Regards — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#1567 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AMPLtbjqTtdSX8eZDu1ouHXbDXC9uWBKks5sPzQogaJpZM4LKsK2> .

[pantonis]

@kenisteward although it works is not ideal

[kenisteward]

It gives you the funtional you want that was thought to not exist. That makes it ideal for me at least. Until either they start accepting pr or they implement it themselves

…

On Thu, Jul 20, 2017, 7:15 AM pantonis ***@***.***> wrote: @kenisteward <https://github.com/kenisteward> although it works is not ideal — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#1567 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AMPLtc_UAbsrNb59ZEYcmP6_B9mhIYFbks5sPza5gaJpZM4LKsK2> .

[pantonis]

@Mrtcndkn did you implement it in 4.1.2?

[saunandrea]

Is this a feature now? I haven't been able to find the documentation.

Update: noticed the link to the check-in, got it.
@Input() exportable: boolean = true;

so for example if anyone else finds their way here:

this.cols = [
      { field: "ID", header: "Id", exportable: true },

[pantonis]

@saunandrea exactly