when selected check boxes rows should export to excel only those selected

Ameur Mezaache posted over 4 years ago

I'm using IGX-GRID that has check boxes and want click export to excel want to show on excel only the selected ones.

Any help implementing this feature will be appreciate it.

Top Replies

15

Offline Ameur Mezaache posted over 4 years ago in reply to Martin Asenov +1
Thanks a lot it did work for me, however if I don't select any thing and hit export it firing and empty excel. Any way to not display it in case no...view reply »
15

Offline Ameur Mezaache posted over 4 years ago in reply to Martin Asenov +1
Maybe enable export button only when rows selected how this will be achieved please
1080

Offline Martin Asenov posted over 4 years ago in reply to Ameur Mezaache +1 suggested
Hello Ameur, My suggestion is to use a conditional statement to check if there is a selected row: public exportButtonHandler() { if (this.grid.selectedRows...view reply »

1080

Offline Martin Asenov posted over 4 years ago
Hello Ameur,

Thank you for posting in our community.

You can achieve the required by getting the selected rows using selectedRows method of the igxGrid and then passing the data to the IgxExcelExporterService's exportData method:

public exportButtonHandler() { this.excelExportService.exportData(this.grid.selectedRows(), new IgxExcelExporterOptions("ExportFileFromGrid")); }

I have created sample for your reference.
Cancel
Reply

Cancel
15

Offline Ameur Mezaache posted over 4 years ago in reply to Martin Asenov

Thanks a lot it did work for me, however if I don't select any thing and hit export it firing and empty excel.

Any way to not display it in case no selection made?

Thanks
Cancel
Reply

Cancel
15

Offline Ameur Mezaache posted over 4 years ago in reply to Martin Asenov

Maybe enable export button only when rows selected how this will be achieved please
Cancel
Reply

Cancel

1080

Suggested Answer

Offline Martin Asenov posted over 4 years ago in reply to Ameur Mezaache

Hello Ameur,

My suggestion is to use a conditional statement to check if there is a selected row:

public exportButtonHandler() {
	if (this.grid.selectedRows().length > 0) {
		this.excelExportService.exportData(this.grid.selectedRows(), new IgxExcelExporterOptions("ExportFileFromGrid"));
	} else {
		this.excelExportService.export(this.grid, new IgxExcelExporterOptions("ExportFileFromGrid"));
	} 
}

I have updated the sample for your reference.

0

Offline Shankargouda Goudati posted over 4 years ago in reply to Martin Asenov

What if we want to export selective columns and not all columns in grid? Please assist on this.
Cancel
Reply

Cancel