This is a handy example if you need to read an excel document and/or send an email from outlook in some c# code.
Remember to add the following references (Project > Add Reference > COM)
Microsoft Excel 12.0 Object Library
Microsoft Office 12.0 Object Library
Microsoft Outlook 12.0 Object Library
if you have older versions of office , they should work too.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Excel = Microsoft.Office.Interop.Excel;
using Outlook = Microsoft.Office.Interop.Outlook;
using Microsoft.Office.Core;
namespace StatusNotifier
{
class StatusNotifier
{
static void Main(string[] args)
{
string Path = @"D:\MyExcelFile.xls";
// initialize the Excel Application class
Excel.ApplicationClass app = new Excel.ApplicationClass();
// create the workbook object by opening the excel file.
Excel.Workbook workBook = app.Workbooks.Open(Path,
0,
true,
5,
"",
"",
true,
Excel.XlPlatform.xlWindows,
"\t",
false,
false,
0,
true,
1,
0);
// get the active worksheet using sheet name or active sheet
Excel.Worksheet workSheet = (Excel.Worksheet)workBook.Worksheets[1];
int index = 0;
// This row,column index should be changed as per your need.
// i.e. which cell in the excel you are interesting to read.
object rowIndex = 2;
object colA = 1;
object colB = 2 ;
StringBuilder message = new StringBuilder();
message.AppendLine("My Message");
message.AppendLine("--------------");
message.AppendLine("");
//----------------------------
//READ EXCEL WORKBOOK
//------------------------------
try
{
while (((Excel.Range)workSheet.Cells[rowIndex, colDateRaised]).Value2 != null)
{
rowIndex = 2 + index;
DateTime dateRaised = DateTime.FromOADate(double.Parse(((Excel.Range)workSheet.Cells[rowIndex, colA]).Value2.ToString()));
string description = ((Excel.Range)workSheet.Cells[rowIndex, colB]).Value2.ToString();
message.AppendLine(rowIndex + " DateRaised :" + dateRaised.ToShortDateString() + "Description: " + description) ;
index++;
}
}
catch (Exception ex)
{
app.Quit();
Console.WriteLine(ex.Message);
}
message.AppendLine("For more inforamtion please see:");
message.AppendLine(Path);
Console.WriteLine("Message:\n " + message);
//----------------------------
//CREATE OUTLOOK MESSAGE
//------------------------------
try
{
// Create the Outlook application by using inline initialization.
Outlook.Application oApp = new Outlook.Application();
//Create the new message by using the simplest approach.
Outlook.MailItem oMsg = (Outlook.MailItem)oApp.CreateItem(Outlook.OlItemType.olMailItem);
//Add a recipient.
// TODO: Change the following recipient where appropriate.
Outlook.Recipient oRecip = (Outlook.Recipient)oMsg.Recipients.Add("someone@somewhere.com");
oRecip.Resolve();
//Set the basic properties.
oMsg.Subject = "Status Update";
oMsg.Body = message.ToString();
//Add an attachment.
// TODO: change file path where appropriate
String sSource = "C:\\setupxlg.txt";
String sDisplayName = "MyFirstAttachment";
int iPosition = (int)oMsg.Body.Length + 1;
int iAttachType = (int)Outlook.OlAttachmentType.olByValue;
Outlook.Attachment oAttach = oMsg.Attachments.Add(sSource, iAttachType, iPosition, sDisplayName);
// If you want to, display the message.
// oMsg.Display(true); //modal
//Send the message.
oMsg.Save();
oMsg.Send();
//Explicitly release objects.
oRecip = null;
oAttach = null;
oMsg = null;
oApp = null;
}
// Simple error handler.
catch (Exception e)
{
Console.WriteLine("{0} Exception caught: ", e);
}
}
}
}
This code is based upon examples from the following links:
Excel:
http://www.codeproject.com/KB/cs/Excel_Application_in_C_.aspxOutlook:
http://support.microsoft.com/kb/310263
