hi
can you help me!
how can i get all record of grid that paged. Now i only get record of current page
thanks for help!
Hello Cuong,
Thank you foe posting in our community.
Sample project illustrating how igGrid could be exported could be found at:
http://www.igniteui.com/infragistics-excel/overview
This sample shows how an igGrid with paging enabled could be exported in both ways - only the current page and the whole data source.
Additionally, I believe you may find the following thread in our forum helpful:
http://es.infragistics.com/community/forums/t/90984.aspx
Also there is an article in our documentation regarding client side Excel library which could be found at:
http://help.infragistics.com/Doc/jQuery/2014.2/CLR4.0?page=Client_Side_Excel_Library_Overview.html
I hope you will find this information helpful.
Please let me know if you have any additional questions regarding this matter.
Please let me know if you need any further assistance with this matter.
thanks for suported but i want to use client export for all record in the gridview that was paged
Thank you for your clarification.
What I can suggest in case that you are looking for client side export only is having a look at the following sample illustrating how an excel worksheet could be created in browser.
http://www.igniteui.com/client-side-excel-library/create-excel-worksheet-in-browser
In this sample only the rendered rows will be exportedsince rows = $(gridId).igGrid("rows") returns only visible rows. In case that you would like to export all rows you will have to retrieve the rows from the grid`s data source instead of the grid itself. For example, rows = $("#grid").data("igGrid").dataSource.data(). However, when rows are retrieved directly from the data source the formatting that comes from the grid will be lost and only data is going to be accessible for export.
Please keep in mind that this sample uses CTP(Community Technical Preview) features. The API and behavior may change when these features are released with full support.