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”
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!