Input File Excel - sheet code names

[ECNordby64]

The new enhancements to the Input tool, File, Excel file type being able to input a named range is fantastic!

One trick I use often when creating a template Excel file for user input is I give the form sheet a "Code Name" - sadly in Excel this cannot be set when creating the template using code or from Alteryx - it needs to be set manually in the <alt><F11> IDE, select the sheet in browser then set the code name in the properties window. Advantage: the user can change the visible label/name of the sheet to their liking but the code name does not change - therefore, an automated pipeline with a fixed sheet name for import (like a workflow picking up files dropped into a drop folder to ETL new results into a database), could reference the sheet code name and not be prone to workflow failure if the user changes the name of the sheet.

[CristonS]

hi @ECNordby64 

Thank you for submitting your feedback to the Alteryx Idea product board! We appreciate all the feedback we get and are working to review and respond to all ideas that have met the criteria to be brought to our product team. If you haven’t yet, please be sure to review our updated Submission Guidelines.