The current possibility with Automation Services in Spotfire 10.3 with the action Export Data to File and choosing the Export data as is set to Microsoft Excel Workbooks, does not provide the possibility to define a tab name. Other related features would be adding worksheet to existing workbook, with name conflict action to take (replace, new name...).
The result could be a single file with tabs instead of N separate files.
Thank you for your consideration.
Kind regards.
Thanks for a great idea Xavier.