I have written a java action to export the data to an excel file. I used 50 formula fields in that java action. When I try to execute the process, it is taking more than 60sec time to complete the export. How can I reduce this time? Is there any alternative to reduce the process time. Hope you got my question. Thanks in advance.
Since this is not a Mendix specific question, you can find similar discussions on stack overflow. Perhaps this one can help
I have seen this happen when the file format is XLSX, did you try XLS? (i know the latter is an older version but worth a try and it anyways has good support and community still uses it)