SPF-I-24 "Export any table to Excel with preserved number formatting, layout and style." was implemented in Spotfire Analyst 14.0 LTS but also needs to be implemented for Automation Services Job Builder "Export Data to File" task. As of version 14.4, the Automation Services is still exporting an Excel file from Spotfire visualizations with no preserved formatting.
"Starting with Spotfire 14.0 LTS, report developers and users can export to Microsoft Excel their table visualizations, including tables, cross tables, summary tables, and graphical tables, while preserving their layout, styling, and formatting. This functionality ensure that reports can be easily shared as tabular data, just as they were designed in Spotfire, without the need for additional manual effort."