ADD-INS For Microsoft - Excel using .Net

Step:1 :- CREATE THE C# PROJECT(Class lib Application)
Step:2 :- Set the project properties Register for COM Interop to TRUE


#region Using Directives //Using Interop services
using System;
using System.Runtime.InteropServices;

namespace NewAddInFunctionality
{
[ClassInterface(ClassInterfaceType.AutoDual)]
public class AddINFunctions
{
public AddINFunctions()
{
}
Add Method
public double Add2(double v1, double v2)
{
return v1 + v2;
}
Multiply Method
public double Multiply(double v1, double v2)
{
return v1 * v2;
}
Divide Method
public double Divide(double v1, double v2)
{
return v1 * v2;
}
Mod Method
public double MOD(double v1, double v2)
{
return v1 % v2;
}

[ComRegisterFunctionAttribute]
public static void RegisterFunction(Type funType)
{
Microsoft.Win32.Registry.ClassesRoot.CreateSubKey(
"CLSID\\{" + funType.GUID.ToString().ToUpper() +
"}\\Programmable");
}

[ComUnregisterFunctionAttribute]
public static void UnregisterFunction(Type funType)
{
Microsoft.Win32.Registry.ClassesRoot.DeleteSubKey(
"CLSID\\{" + funType.GUID.ToString().ToUpper() +
"}\\Programmable");
}
}
}

Step :3 Build the Project Get the DLL
Step :4 GO To Excel and Open a WorkBook
Step : ADDINS select methods and type ADD(3 + 7) then result will be 10

Read More

Send Email using Gmail in ASP.Net

protected void btnSendEmail_Click(object sender, EventArgs e)
{
MailMessage mail = new MailMessage();
mail.To.Add("saurabhjnumca@gmail.com");
mail.To.Add("saurabh_singh_jnu06@yahoo.co.in");
mail.From = new MailAddress("sandeepjnumca@gmail.com");
mail.Subject = "HI this is a test mail for learners using .Net";

string Body = "Hi Friends, this mail is a test mail"+
"sending this mail through Gmail in ASP.NET";
mail.Body = Body;

mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Credentials = new System.Net.NetworkCredential ("sandeepjnumca@gmail.com","GmailPassword");
smtp.EnableSsl = true;
smtp.Send(mail);
}

Read More