Accessing Microsoft Office InterOP Objects using C# 4.0

Step 7:

Press F5 to debug and run the application.

So, successfully we are able to display Authors list in Excel application using C#4.0 features.

Step 8:

Create a word document with Icon Link to selected column of Excel work sheet.

a. Add this line of code at the bottom on DisplayAuthorsinExcelApplication() static method. Below code will copy name of all the authors.

worksheet.get_Range("A1:A8").Copy();

b. Create a static method which will create and open a word document. This document will have an icon. This icon will link to selected portion of active Excel application.

{codecitation class="brush: csharp; gutter: true;" width="650px"}

static void CreateWordDocument()

{

var _wordApplication = new Word.Application();
_wordApplication.Visible = true;
_wordApplication.Documents.Add();
_wordApplication.Selection.PasteSpecial(Link: true, DisplayAsIcon: true);


}

{/codecitation}

Step 9:

Press F5 to run the application. First one Excel sheet will open with the selected values then a word document will open. This document will have an icon that will link to selected part of active excel application.

Figure :01

Figure :02

Figure :03

Figure :04

For Reference the complete code is as below,

Program.cs

{codecitation class="brush: csharp; gutter: true;" width="650px"}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Word = Microsoft.Office.Interop.Word;
using Excel = Microsoft.Office.Interop.Excel;

namespace OfficeInterOpaccess
{

class Program
{

static void Main(string[] args)
{

dynamic d = ListofAuthor();
foreach ( dynamic k in d)
{
Console.WriteLine(k.Name);
}

DisplayAuthorsinExcel(d);
CreateWordDocument();

Console.Read();

}


static dynamic ListofAuthor()
{
List<Authors> _listAuthor = new List<Authors>
{
new Authors(){Name =" Mahesh Chand", NumberOfArticles = 700 },
new Authors () { Name = " Mike Gold", NumberOfArticles = 200},
new Authors () {Name =" Patra " , NumberOfArticles = 50},
new Authors () { Name = "Mamta M ", NumberOfArticles = 38},
new Authors (){ Name = "ShivPrasad K", NumberOfArticles = 80},
new Authors () { Name = "Praveen Masood", NumberOfArticles = 190},
new Authors (){ Name =" Rekha S " , NumberOfArticles = 5}


};
return _listAuthor;
}



static void DisplayAuthorsinExcel(dynamic authorlist)
{

dynamic _excelApplication = new Excel.Application();
_excelApplication.Visible = true;
_excelApplication.Workbooks.Add();
Excel._Worksheet worksheet = _excelApplication.ActiveSheet;
worksheet.Cells[1, "A"] = "Name";
worksheet.Cells[1, "C"] = " Number of Articles";
var row = 1;
foreach (var r in authorlist)
{
row++;
worksheet.Cells[row, "A"] = r.Name;
worksheet.Cells[row, "C"] = r.NumberOfArticles;
}

worksheet.Columns[1].AutoFit();
worksheet.Columns[3].AutoFit();

worksheet.get_Range("A1:A8").Copy();
}



static void CreateWordDocument()
{
var _wordApplication = new Word.Application();
_wordApplication.Visible = true;
_wordApplication.Documents.Add();
_wordApplication.Selection.PasteSpecial(Link: true, DisplayAsIcon: true);
}
}



public class Authors
{
public dynamic Name { get; set; }
public dynamic NumberOfArticles { get; set; }
}
}

{/codecitation}

Conclusion:

In this article, we saw; how to work with office interop objects in C# 4.0. We created and opened an Excel application then displayed list of authors in the active worksheet of active Excel application. Then we opened and created a Word document, which were having an icon to link to selected area of Excel sheet. We used dynamic type for all the purpose. Download attached source code for better understanding.

Thanks for reading. Happy Coding.

About the Author

Dhananjay Kumar Description :I done my engineering from Anand Engineering college Agra in 2007. I am MCTS WCF, MCTS MOSS Development, I am MCTS Web Development . I am native of Jamshedpur. Currently Please feel free to contact me regarding any clarification of my article at Dhananjay.25july@gmail.com Occupation : Software Engineer Company : UST Global. Location : India Follow me at twitter : http://twitter.com/dhananjay25