This doesnt work. The Excel Formatter snap does not allow you to change the datatype of a column no matter what datatype you send it. The Excel formatter always defaults to General. I used this Oracle PL/SQL package to generate a Excel document and this package kind of has the same issue where it defaults to “Custom” but for our purposes the API likes Custom and Date datatypes equally when a date is concerned, but doesnt like General. Dont know why. Recommend, somehow, allowing the Excel Formatter snap to change column datatypes. I dont need a response to this unless you have a fix where I dont have to use PL/SQL.
I must disagree. Look at the following sample:
