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.

Set up an Excel VSTO project in Visual Studio, design a custom ribbon with a hyperlink maker button, wire controls, and debug the skeleton to verify functionality.

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 how to implement WPF/WinForms interoperability by embedding a WPF user control in a Windows Forms app using an element host, wiring the host, and validating rendering.

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.

Learn to build a basic wpf user control using grid and stackpanel, define columns, add text blocks and hyperlinks, and incorporate an ellipse status indicator.

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.

Design a file settings user control in a WPF MVVM app, using grid layouts, text boxes, margins, and static resource icons to manage icons and file settings.

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.

Create a singleton view model with bindable boolean properties to drive UI controls, enabling or disabling options based on folder inclusion, using data binding and property change notifications.

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.

Bind a base directory string, validate it with directory exists, and allow users to pick and assign the folder via a folder browser dialog.

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.

Learn to monitor Excel sheet selection changes with VSTO and MVVM, capture the target range, ensure non-empty values, and safely convert values for display in a modal window.

Bind multiple view controls to a single property in a WPF MVVM app, using an equality converter to reflect files or folders and bind sublevel values to the UI.

Bind properties to views in MVVM by building a file extension model, an observable collection, and a bound command to add extensions with parameters, reflecting changes to the selected items.

Add a start button in a WPF MVVM UI, configure image and combo buttons, arrange in a grid, and implement command validation to enable actions or create a hyperlink.

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.

Learn to recursively search all subfolders and collect file and directory information using a get results model, with configurable sublevels and search patterns.

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.

Learn to create hyperlinks in Excel cells, set the hyperlink target, and use anchors and addresses to open files or directories from a worksheet.