Whenever Automation services exports a table to excel it loses all formatting. at a minimum it should maintain it the same way as the web client does when you right click and export with formatting. Customers are less likely to read and understand reports when the columns are undersized and date, currency and number formats are incorrect.