Exporting to Excel to fill in specific fields in template document.

0
Hi All   My customer has an Excel document which they need to generate per case.  I have tried using the Excel Exporter Marketplace Module using the excel document as an Uploaded Template but this doesn't seem to give me exactly what I'm looking for.     I am looking to ideally enter a View Page and press a button on the specific record, this will then run a microflow which generates the file within the Entity (generalisation System.FileDocument) and downloads it with the appropriate information in each applicable cell.   See below the document which I am looking at generating (the 0s will be the Attribute values from by Entity)   My microflow for generating and downloading the file This successfully downloads the document with the correct File Name but it seems to only export the template document with none of the attributes.   Excel Export Template; Worksheet; Column data;   Is there another way to export excel data to specific Cells within a document or am I not using the Excel Exporter as I should be?   Thanks Grant
asked
2 answers
0

Hi Grant,

 

This module https://marketplace.mendix.com/link/component/117034  allows you to use an Exel template and populate the fields using the attributes of an entity. I think this will be useful.

 

If you need more flexibility, use: https://marketplace.mendix.com/link/component/116370.

 

Go Make It 

 

 

answered
0

I was able to sort this myself by creating a new hidden sheet in Excel to export my data to.  The columns which need to be populated by my Case Information now just point to the Exported columns in the hidden sheet. 

 

There was also an issue with my Join Types in the Export Worksheet hence why I wasn't able to see my data in the exported template.  I have now resolved by changing the Associations within the Excel Export Worksheet settings to LEFT JOIN.

answered