Hi, Could anyone help me out on how generate excel file given in attached image     Thanks in aadvance  
1 answers

Hi Adarsh,


The quickest way to do so is by creating a datagrid containing the four columns you need. Base it on an xpath datasource and add the “export to excel button. https://docs.mendix.com/refguide/control-bar/#export-to-excel-button  It does not match the requested layout exactly, but it does provide the data and you can realize it in minutes.

Other ways will take considerably more time, you can use the excel exporter marketplace module for example: https://marketplace.mendix.com/link/component/726 

In my experience, for most use cases it is best to go with what Mendix offers out of the box as much as possible, compared to exactly matching the requirements. The extra effort it takes to exactly implement the request in most cases just is not worth the effort. Although there are exeptions for every rule, of course.

I hope this helps.