Input and Dynamic Input tool - Output SheetName as a field

[DavidP]

When loading multiple sheets from and Excel with either the Input Data tool or the Dynamic Input Tool, I usually want a field to identify which Sheet the data came from. Currently I have to import the Full Path and then remove everything except the SheetName.

It would be great if there was an option to output she SheetName as a field.

[kelly_gilbert]

Yes, please! I wrote my own dynamic input macro with a Sheet Name Only option, because I got tired of parsing it from the path 😄 It would be so much nicer to have it in the standard tools.

Until we get this enhancement, it's possible to output the sheet name by adding a Pass a Field to the Output action in the Dynamic Input tool. Not ideal and only works with Dynamic Input, but it helps in some situations!

[Samantha_Jayne]

I have wished this in the past too @david, when you have to cut it from the end of the filename, you are like man, this would be so easy to add to the drop down... 😁

[DavidP]

That's a handy tip @kelly_gilbert 

[HomesickSurfer]

Hi @DavidP 

Great idea.  I'm thankful for FileGetExt() and keep this snippet handy to parse sheetname

REGEX_Replace(TrimLeft(FileGetExt([FileName]),".xlsx"),'[[:punct:]]|[\$\+<=>\^`\|~]', "")

[MattBenj]

The SharePoint Files Input tool allows you to add the sheet name from the Attach Metadata section. Seems like they should be able to do something similar with the standard input tools.

[clmc9601]

Completely agreed!

[Pang_Hee_Choy]

can we have add-on column to tell whether sheet is hidden? or other similar ways.
sometime i just need to proceed with visible sheet. so if there have a way to identify them is good.

[marcusblackhill]

I completely agree. It would save time parsing it every time we needed that information.

[gautiergodard]

This is a good one!