Copy Formatted Rendered Excel to Existing Excel Output Sheet in other sheet

[jayeshrc8545]

Hello Team,

I need to copy existing excel having formatted data retrieved via Rendering tool & needs to copy into another excel having unformatted data generated via output tool. I used run command tool to copy formatted excel into another excel & then use output tool to copy input data into other sheet. 

However I am getting error in excel while opening the file (Ver_2023-10-04.xlsx) says its corrupted & the existing data is missing under Amort Lines & shows blank sheet. 

Let me know if there is other way to format data & then merge with excel having unformatted sheet.

Any assistance will be appreciated.

Regards,

Jayesh

[jayeshrc8545]

Just to add more information, since the crosstab has dynamic headers which will increase based on dynamic addition of Month Amort values.

So the template copy via run command tool won't so I have used basic table where format has been applied & then saved it into excel file via Render tool. We are getting records for unformatted data in workflow as per attached snapshot in the Amort Line sheet but after workflow completion I am getting no records in that sheet. 

[jayeshrc8545]

Hello Team,

Any updates on this topic.

Regards,

Jayesh

[caltang]

I think it'll be much more helpful for you to export your workflow entirely. The corruption of the file could be in part of how you execute the CMD tool within the workflow. Perhaps you might want to consider a Chain App instead?