Export Multisheet excel file

0
Hi experts, I need help in exporting multi sheet excel file. So basically, I have two entity A and B. and i want to get the data of entity A in sheet 1 and data of entity B in sheet 2. please help me in details as I am completely new with this functionality. Error: An error occurred while executing an action of MyFirstModule.Home_Web.actionButton6: u is not a function Error: An error occurred while executing an action of MyFirstModule.Home_Web.actionButton6: u is not a function    at http://localhost:8080/mxclientsystem/mxui/mxui.js?638900108612693040:61:180520    at ye (http://localhost:8080/mxclientsystem/mxui/mxui.js?638900108612693040:19:6830)    at i (http://localhost:8080/mxclientsystem/mxui/mxui.js?638900108612693040:19:6731)    at k (http://localhost:8080/mxclientsystem/mxui/mxui.js?638900108612693040:59:5099)
asked
2 answers
0

Hi Harsh,

To export data from Entity A and Entity B into two separate Excel sheets in Mendix, start by installing the Excel Exporter module from the Marketplace. Once installed, run your app locally and access the Excel Exporter admin page (usually via a temporary page or http://localhost:8080).

 

Create a new Excel Export Document, name it (e.g., “Export A and B”), then add two sheets:

 

  • Sheet 1: Name it “Entity A”, select Entity A as the object type, and choose the attributes to export.
  • Sheet 2: Repeat the same for Entity B.

 

 

After configuring both sheets, create a microflow that retrieves the required data and calls the GenerateExcelDoc Java action provided by the module. Connect this microflow to a button in your UI. When triggered, it will generate an Excel file with both sheets and download it.

 

Let me know if you want help creating the microflow or setting up the template.

 

Let me know if you face any issues,

 

hope it helps!

answered
0

Hi Harsh,

Please refer the below article

https://medium.com/mendix/how-to-import-multiple-excel-sheets-from-a-single-workbook-using-mendix-e203f687b5f7

answered