Hi Team
is there any possibilities like if filter is applied on grid, export only filtered data if at all data is distributed in 5 pages.
for example in 8000 data if 3000 is filtered data export all 3000 data only.
Thanks
Hi,
Thank you for posting in the Infragistics community !
To export only the filetred rows you need to specify filteredRowsOnly value to the filtering option, as follows:
$.ig.GridExcelExporter.export($("#grid"), { fileName: "igGrid", gridFeatureOptions: { "filtering": "filteredRowsOnly" } });
Please see the attached sample and let me know if you have further questions on the matter, I will be glad to help.
Hi Hristo
Thanks for your reply i will checked that and will let you know meanwhile I have another issue can you please help me on this its very urgent.
we are using your licensed version and recently updated to 2015.1 version for using export to excel feature of infragistics.
we are facing one problem we have one column where we are using formatter. In export to excel we are exporting allrows what problem we are seeing in exported excel the columns which has formatter only export data for current page. while debugging we saw in cellExporting event after current page no of rows the data is coming as blank.
Could you please help me on this its stopping our client deliverable.
Prakash
This is a known issue for the 15.1 version. However this is fixed in 15.2 release, which is scheduled to be rolled out on 25th September. In the meantime I will try to workaround this by handling the cellExporting event and will keep you posted with my findings. I will respond in this case within 24 hours from this post.
Thanks Hristo
if any Quick Fix that will also work fro me time being. eagerly waiting for your reply.
Actually this is fixed in the latest version of 15.1, which is available for you to download at Infragistics website. After you download and install it issue will be fixed. I am also attaching my sample using cdn references to the latest version of 15.1, which is 15.1.20151.2112. The grid has a column that uses a formatter function and paging as your described scenario.
You will see that exporting properly gets the data for the column using a formatter function.
Please review it and let me know if you have further questions on the matter.