Custom formatting in Excel-file

jimmyhartington · April 3, 2025, 12:42pm

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.

jimmyhartington · April 3, 2025, 1:13pm

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

Admin · April 3, 2025, 2:48pm

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

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

jimmyhartington · April 4, 2025, 4:30am

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.

Admin · April 4, 2025, 8:22am

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.