Topic outline

• About

  Collapse all Expand all
  • Mark as done

    The content of this course will be in the form of a guided project on how to use the Primary Interop Assemblies to be able to interact programmatically with Microsoft Excel and Microsoft Word. The project will demonstrate how to create an application using Visual Studio and C#  that will programmatically open an Excel file read content from it and based on some values in specific cells and generate customized Word files. The project will take care of creating the interface and the usage of the PIA.

  • Mark as done

    Software used: Microsoft Visual Studio

    Pre-requisite knowledge: Basic programming skills would be sufficient, but having object-oriented programming knowledge is recommended.

  • 

    URL

    Click here to read more about PIA at Microsoft's website URL

    Mark as done
  • 

    Forum

    Announcements Forum

• Phase 1: Creating the User Interface
  • Mark as done

    In Phase 1, the user interface is created. The main focus is on building an application with a user interface that can simplify the tasks to be done by clicking a few buttons. Previous knowledge about building GUI applications is desirable, but not a must.

  • 

    Video Time

    Phase 1 Video Time

    Mark as done

    The video of phase 1 is about 35 minutes long. Keep in mind that study time might require more time as pausing an repeating parts of it are desirable to grasp the whole information. It is also advised to work along on a computer using Visual Studio.

• Phase 2: Reading data from Microsoft Excel using PIA
  • Mark as done

    In Phase 2, we add the event handlers that will allow the user to select an Excel file that the application will open programmatically, read its content, and store them for later.

  • 

    Video Time

    Phase 2 Video Time

    Mark as done

    The video of phase 2 is about 85 minutes long. Keep in mind that study time might require more time as pausing an repeating parts of it are desirable to grasp the whole information. It is also advised to work along on a computer using Visual Studio.

• Phase 3: Generating customized Microsoft Word files using PIA
  • Mark as done

    In Phase 3, we add event handlers that will allow the user to generate customized Microsoft Word file based on the data that was retrieved from the Excel file in the previous phase.

  • 

    Video Time

    Phase 3 Video Time

    Mark as done

    The video of phase 3 is about 48 minutes long. Keep in mind that study time might require more time as pausing an repeating parts of it are desirable to grasp the whole information. It is also advised to work along on a computer using Visual Studio.