@mmacfarlane​ Do you have a little example of the template and data. I think FME should be honouring the template

Hi Mark,

I've thrown together a quick workspace that replicates the issued (though 0 width for automatic isn't causing the error running translation, weird!). The writer is still not honouring the template's width though.

Hmm. Thought I had attached both the template and workspace. Here's the workspace

@mmacfarlane​ Thanks for the workspace & data. I've reproduce the issue. This has been fixed for FME 2021.2 which is scheduled for release in early November. betas are available here

Thanks!

Hi Michael,

Could you share the configuration that makes the Excel Writer preserve the cell width of the template?

I was trying to do the same but it didn’t work. I configured it to use the destination sheet as the template, and not to overwrite the file.

In “User Attribute” tab, I chose “Automatic” for attribute definition. But if I set the “Cell Width” to all 0s, it will auto fit the width, not preserverse it.

Below is how the file looks like before and after execution (using “Automatic” definition). I also attached the screenshot configurations.

BEFORE:

AFTER:

Hi @dollyns 

It looks like that workspace mentioned was missing from this thread but we have reattached it so you should now be able to see how @mmacfarlane set up the Excel writer. 

Which version of FME are you using? I believe all versions after 2021.2 will honour all formatting from the template file.