Skip to content
+1-888-319-3663

COMMUNITY FORUM

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

Brian asked 3 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”. 
Answers
Ethan Sorenson Staff answered 3 years ago
Brian,
 
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 3 years ago

Ethan,
Thank You, your solution worked perfectly!


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