XLSX Document type in Excel Exporter

0
Hi, Does mendix 5.9.1 support xlsx document type while using excel exporter? I am trying to export report in xlsx format, however I am getting error. Below is the error and stack message: Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (1/163) java.util.concurrent.ExecutionException: com.mendix.modules.microflowengine.MicroflowException: com.mendix.core.CoreRuntimeException: org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (2/163) at Reporting.IVKGeneratePatientReport (JavaAction : 'GenerateExcelDoc') Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (4/163) Advanced stacktrace: Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (5/163) at java.util.concurrent.FutureTask.report(Unknown Source) Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (6/163) at java.util.concurrent.FutureTask.get(Unknown Source) Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (12/163) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(SourceFile:158) Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (13/163) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(SourceFile:36) Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (14/163) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(SourceFile:160) Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (15/163) at scala.util.Try$.apply(Try.scala:191) Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (16/163) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(SourceFile:154) Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (17/163) at akka.actor.Actor$class.aroundReceive(Actor.scala:465) Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (18/163) at com.mendix.core.session.Worker.aroundReceive(SourceFile:147) Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (19/163) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516) Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (20/163) at akka.actor.ActorCell.invoke(ActorCell.scala:487) Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (21/163) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238) Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (29/163) Caused by: com.mendix.modules.microflowengine.MicroflowException: com.mendix.core.CoreRuntimeException: org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException Sep 15 10:58:32.906 127.0.0.1 tr10000: ERROR - Connector: (30/163) at Reporting.IVKGeneratePatientReport (JavaAction : 'GenerateExcelDoc') Regards, Savita
asked
1 answers
0

Hi Savita,

If you mean the Excel Exporter from the AppStore? Then the answer is yes. Do make sure that your configuration is 100% correct, if you moved/renamed entities to other modules or removed/renamed associations/attributes it is possible that your configuration is not correct anymore (if it existed before the changes).

The validation on the Excel Exporter is not updating unless you actually change the configuration. Recently I had issues with this where the Excel Exporter gave a similar gibberish error and it was caused because I moved an entity to another module, released the new version to production with an existing Excel Export configuration. It showed all fine and until I opened a column record I did not notice that the attribute configuration was missing. Do make sure to also update the MX Model reflection cache otherwise you won't notice this either.

Hope this helps.

Regards, Mitchel

answered