How can i export filtered data from data grid 2 to excel ?

-2
I have a data grid   with data and filters , since the data is alot i need to filter the required data and need to export the same in excel, how can i achieve this.  I cannot use data grid 1 as i have few columns which aren't on the screen but are present in the excel export.
asked
3 answers
0

Hi Nikhil, 

Did you check this section of the documentation?. It explains the capabilities of export to excel from the Datagrid 2. Be aware that this behavior is only possible with the DataGrid 2 variant that is part of the Data Widgets Module. If you are using an older version: read this on how to upgrade

 

Update:

Filtered data based on SchoolYear

Example of the DataGrid, Nanoflow button and XLS file

image.png

Below you can see the Datagrid in Structure mode

image.png

And this is the associated nanoflow

image.png

answered
0

The regular datagrid has the export option as well (when using xpath as your datasource)

image.png

answered
0

You can add additional columns to your datagrid and hide them. When you export to Excel, these are still included.

Two ways of hiding them are: Select 0 width

image.png

or add the class 'hidden' to the column you don't want to display

image.png

answered