Hands-On Lab

Microsoft Office Programmability in C# and Visual Basic

Lab version:1.0.0

Last updated:6/27/2011

Contents

Overview

Exercise 1: Creating a Collection of Business Entities and Inserting their Values into an Excel Worksheet

Task 1 � Creating a New Console Application and Reference the Microsoft Office Interop Assemblies

Task 2 � Creating a Collection of Business Entities

Task 3 � Creating an Excel Workbook and Populate it with Data from the Business Entities

Exercise 1: Verification

Exercise 2: Embedding an Excel Worksheet in Microsoft Word

Task 1 � Embedding your Excel Worksheet into a New Microsoft Word Document

Exercise 2: Verification

Exercise 3: Removing the PIA Dependence from the Application

Task 1 � Checking that PIA dependencies are removed by default

Summary