I am using 'ExportToExcel' button in a data grid. And this is generating an excel of data in the grid but it is putting comma in some empty fields and extra comma in some field at the end of the value. I am not able to understand why and how to solve this issue. Please help. EDIT: The entity of the attribute whose field is having extra comma is many to many relationship with grid's entity. Hence this issue. Irrespective of any datatype this issue happens(I see Enumeration and String types)
Help us to help you by giving more info. Best option is to create a test-project and share it with us in the mendix cloud. So we can see ourselves what is happening.
Tell us about the datatypes that are having this issue and any specific circumstances.