How to export all records to Excel using upgraded Data Widgets, while the rows per page is less than the records that need to be exported.

0
Hi! I need to export records to Excel using upgraded Data Widgets (V 2.23.1), meaning from data grid 2 by using JavaScript action 'Export To Excel', with a single click. The rows per page of data grid is less than the total records to export, how can I export all records across pages with only a single click.
asked
2 answers
1

Hi Erli,

Datagrid2 excel to export js action exports all the rows which are available in your datagrid2 ( not only first page) unless you mention spme specific number on No of records parameter in that js action.

Suppose you have 10k record and then you apply some filter then it gets reduced to 5k and click to export then it will export 5k records

 

Hope it helps!

answered
1

Hi Erli,

 

Without any filter all the data will be visible in Datagrid2 by the time Export to Excel javascript action will export all the data I believe, for example my project having 5 lacks data Export is working as expected only 

image.png

image.png

Or another way go with Excel exporter

 

Hope it helps!

Thanks & Regards,

Manikandan K

answered