Form Field data in mat-table is not present in Exported document

[abhip5369]

Hi,
I am having some form fields in my mat-data-table, which user can fill in runtime, however on export the fields are coming as blank.
Below is the stackbliz of the same :

https://stackblitz.com/edit/mte-demo-dwz9uo?file=src/app/app.component.html

Also is there a way to ignore any particular row in mat-data-table while exporting ?
I have a "No Data present" row in my table which gets conditionally displayed in case there in no data from backend, but this row comes in exported doc irrespective of data is present or not.

[ayandebbarman]

Commenting as facing the same issue

[ccosmincc]

@abhip5369 "Also is there a way to ignore any particular row in mat-data-table while exporting ?" - have you tried using MatTableExporterDirective's toggleRow method to select the rows which you want to be exported?

[abhip5369]

@ccosmincc Can you provide a stackbliz example for using toggleRow . I had tried it , but it throws error like toggleRow (1,2) is not a function.

Also toggleRow(index: number) is Called to mark the row for selection export, if the requirement is to export only selected rows. Having no rows selected means export everything. So if I want to exclude only 1 row dynamically how can I do that.

https://stackblitz.com/edit/mte-demo-1thybv?file=src/app/app.component.html

[ccosmincc]

@abhip5369 toggleRow method was introduced in one of the latest versions of the library. Your stackblitz uses
"cdk-table-exporter": "1.2.1",
"mat-table-exporter": "1.2.1"
First update those two packages (in package.json file) to version 9.0.2 to have toggleRow method available.
Then, in app.component.html replace the export button with the following line to only export the first row, for example:
<button mat-button (click)="exporter.toggleRow(0); exporter.exportTable('csv')">Export</button>
To obtain the desired behavior, just use the exporter.toggleRow(index) (index is 0-based) for all rows, except for the one that you want to exclude, and then call exporter.exportTable.
Here is a demo with row selection via checkbox column: https://stackblitz.com/edit/mte-demo-qtadtp?file=src/app/app.component.ts

[abhip5369]

@abhip5369 toggleRow method was introduced in one of the latest versions of the library. Your stackblitz uses
"cdk-table-exporter": "1.2.1",
"mat-table-exporter": "1.2.1"
First update those two packages (in package.json file) to version 9.0.2 to have toggleRow method available.
Then, in app.component.html replace the export button with the following line to only export the first row, for example:
<button mat-button (click)="exporter.toggleRow(0); exporter.exportTable('csv')">Export</button>
To obtain the desired behavior, just use the exporter.toggleRow(index) (index is 0-based) for all rows, except for the one that you want to exclude, and then call exporter.exportTable.
Here is a demo with row selection via checkbox column: https://stackblitz.com/edit/mte-demo-qtadtp?file=src/app/app.component.ts

I am using Angular 8 & on official doc , its written :
NOTE: For the previous major versions of Angular (Angular 8 and older versions) install version 1.2.5.

Is it possible to back propagate this feature ?

[HalitTalha]

Hi @abhip5369 unfortunatelly we are not planning to support prior major versions with the latest features..

[abhip5369]

Hi @abhip5369 unfortunatelly we are not planning to support prior major versions with the latest features..

Thanks @HalitTalha . Could we expect the above requested feature of having form fields data in the exported sheets in coming releases ?

[HalitTalha]

@abhip5369, yes sure it will. However I can not give an exact time for now.