Skip to content


Specifying a Sheet name when the destination is an excel file.

Brian asked 4 years ago
I have built a map that whose output is an excel file. This map is part of a multi-map process to import invoices into GP. This map creates a file containing records that cannot be imported because they are missing data.  By default the sheet name is “Sheet1”.  How can I specify the sheet name? For example, I want the sheet name be “Sheet”. 
Ethan Sorenson Staff answered 4 years ago
SmartConnect does not have a feature built-in to specify the sheet name, but you can edit the file with a post map task to edit the sheet name. It would be similar to this article, only instead of:
xlWorkSheet.Cells(1, 1) = “CustomerNumber”    
put this:
xlWorkSheet.Name= “Sheet”    
Brian Heiple replied 4 years ago

Thank You, your solution worked perfectly!

If you would like to submit an answer or comment, please sign in to the eOne portal.