Data360 Analyze

Dear all.

I have this LAE graph that produces an excel file based on a template i have defined.
Having transferred it to Analyze there is just one thing that doesnt work, which is the Excel output.
The node itself doesnt give me an error, but when i open the file the node has produced it will say that the file is broken.
And when i choose to repair the file i will get a file that is totally distorted.
Could it be the xlsm format?
Is there any solution for this?

I am attaching a small example (LAE graph and the excel template)

Attached files

Excel template error.brg
Template.xlsm

The use of merged cells within the template.xlsm file appears to not be handled well when creating the output file. If the cells are de-merged and left-justified, the layout appears to be better but not the same as the template. When the output file is opened, the repair option is selected and the Enable Editing button clicked, the repair results indicate the error is with the first sheet:

Repaired Part: /xl/worksheets/sheet1.xml part with XML error. Load error. Line 2, column 0.

The  data appears to be present in the file in the expected cells. 

However, when the Enable Content button is clicked Excel generates a compile error in the VB code of a hidden module:

Attached files

Template_NoMerge.xlsm

Thank you Adrian.

However, the template is used across the company and will not be changed.
So i guess i will have to continue using LAE until this issue is solved.

It is a shame, because i have gotten everything else to work in the graph.

Thomas

The issue has been forwarded to our engineering team for Analyze.

Reference LAE-22125.