Be sure to review our Idea Submission Guidelines for more information!
Would be amazing if we can use a wildcard to input data from multiple sheets within an Excel workbook.
This would be particularly useful when dealing with older Excel spreadsheets such as .XLS and .binary spreadsheets such as .XLSB.
There's already a way to do this but it does require two tool: Input and Dynamic Input. It's not too complicated though.
Thank you for sharing this with me.
It doesn't solve my issue while using legacy documents such as .XLS and .XLSB...
Ah. Yep.. I see what you mean.
Thank you for your feedback and idea!
I've conducted a quick review of this idea to insure it has all the necessary components present for when the criteria is met for the idea to be submitted to product, and it looks good. Be sure to check out the other product idea boards as well as like any other ideas that would benefit you!
Another vote for this idea.
What I seek is a way to accept changing sheet names.
Say you download an Excel file each week with the same name, but the sheet name changes with that day's date, such as "Data 23-01-01" then "Data 23-01-08" and so on.
If I could have the Input tool accept sheet names with a wild card, like "Data*" then I would be very happy,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.