Hi all,
I am starting a quest to create a custom selection interface for an end user, this interface should:
-
List all Excel files in a specific folder (like a dropdown interface of Data-Shapes).
-
After selecting an Excel file a child form should pop up containing the Excel worksheets of the selected file (or by pressing a button which say something along the lines of “Select Worksheet”).
The end user should now be able to select which Excel worksheet they want to use. Probably with another dropdown or a radio button input. (I now have it as another Data-Shapes interface, but I would like to have it all contained within 1 interface).
-
After the end user has selected their preferred worksheet they can close (or automatically) the child form and run the interface (like in Data-Shapes).
To be honest do I currently not know how to do this but I thought I’d just make a topic that I’ll fill with new information/ insights along the way.
Also, maybe you guys have some other ideas how to make my proposed idea for Excel/Worksheet selection more intuitive.
Some relevant topics:
Child form always in front of parent in Win Forms:
PS: A dedicated childform would probably not even be needed here.