Learn Excel Programming in easy way (VSTO, C#, WPF [MVVM])

Demonstrates building an Excel add-in that scans directories, lists files and folders into the active worksheet, and creates hyperlinks to open items with input validation and subfolder controls.

Learn to add WPF references to a VSTO project by manually selecting assemblies or using a user control template that bundles the required Windows Presentation Foundation references.

Learn how to enable interoperability between Windows Forms and WPF, embedding and hosting controls across architectures, and using containment techniques to display one framework’s control within another.

Learn to implement MVVM by separating view from logic, create a dedicated model, and integrate resource dictionaries via NuGet references to enable scalable WPF development.

Create a field mapping control by adding a text block and a wide combo box, arranged horizontally and bound to a collection of field details.

Learn how to set up a singleton view model and implement triggers and data triggers to drive an ellipse's color from a bound property, plus simple MVVM communication using commands.

Learn to monitor Excel sheet selection changes with VSTO and MVVM, subscribing to selection change events, retrieving cell data, and updating UI visibility with converters.

Add field info by creating an email field, binding selected items to a display list, and adding hyperlinks, while converting types to descriptions through a field mapping workflow.

Validate the start button using CanExecuteChanged, enabling it only when the directory, extension mode, at least one file type, and required fields are properly selected to create a hyperlink.

Create and validate a hyperlink in a VSTO Excel app, ensure directory validity and property readiness, and fetch current folder contents—subdirectories and files—using a structured search mode.

Refine code to build a directory info based model, process files and subdirectories, and generate a result model. Integrate a search pattern for the current level.

Limit subfolder levels with a user setting: enable the sublevel limit checkbox and set an integer; start from the base directory and traverse recursively until current level meets the limit.

Demonstrates creating and indexing hyperlinks in Excel via VSTO C# in a MVVM workflow, processing thousands of items, querying field info data for descriptions and matching them.