Excel Export dynamic multiple sheets

0
Hello Everyone! I try to export excel with multiple sheets with use of ExcelExport module. I don’t know how many sheets will be there as i need to create sheets based on input data – i have list of countries and i need to create each sheet for each region and put countries with this region there. What i was tried to do is create some template and configure some template sheet for it. Then i receive this sheet in the microflow and try to use deepcopy element to copy this sheet to new one with all references and associations it has. But when it comes to GenerateExcel function i always get error below, related to styles… Maybe someone did something similar and can help me on that or direct me to the right way on where to look for this error? Caused by: java.lang.NullPointerException: null     at xlsreport.report.data.ColumnPreset.setStyle(ColumnPreset.java:139)     at xlsreport.report.export.ExportExcel.buildExportFile(ExportExcel.java:91)     at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:133)     at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:34)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)
asked
0 answers