Custom formatting in Excel-file

Is it possible to setup custom formatting of column in Excel output.
For example like this:

I have a usecase, where a user would like to change some times in Excel after a transform and then create a sum in Excel.
And Excel will only do the sum if I change to the custom format.

UPDATE: By using a template file I can get Excel to have the cells set to the right formatting.
But I still need to copy the cell-data and paste back as text before Excels own auto-sum works.
I will add a video showing this in a moment.

Here is a video showing what I need to do in Excel to get it to accept autosum.

Currently you can only output to Excel in the formats listed.

Can’t you do the sum in Easy Data Transform?

My colleague takes the Excel file and maybe adds more rows or adjusts some of the times.
He then needs a new sum in Excel.

Understood. I will make a note. How do-able this is depends on how well it is supported by the library we use to talk to Excel.

1 Like