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.

Build a Windows UI to scan folders, validate parts with color indicators, and control search depth. Learn to fetch data from Excel, populate results, and create file hyperlinks.

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.

Build a flexible UI settings panel for an Excel programming app using WPF MVVM, featuring radio buttons, checkboxes, numeric fields, margins, and an expandable section.

Learn to build a basic user control with base settings using panels and group boxes, manage local namespaces, add text boxes, and apply input constraints via an attached property.

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.

Learn to apply a search pattern when retrieving files and directories, implement recursive fetching, build a results model, and filter results by extensions using lambda expressions.

Test and refine the search pattern to filter files and folders in a current directory, verify results, and validate extension-based filtering and failure reporting.

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.

Learn how to add headers in an Excel worksheet before creating hyperlinks, using the Excel API to map start rows and columns from selected display fields.

Learn to fill Excel worksheet data, create hyperlinks, and map results by looping through total results and columns, handling file and directory distinctions and last modified info.

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.