LINQ to Excel Provider 2.5

This version of the provider, evolving from LINQ to Excel Provider 2.0, adds change tracking in order to allow a user to update, insert, and delete Microsoft Excel data from any .Net code. It follows the LINQ to SQL model of change tracking. To track updates in a class the class will need to implement the System.ComponentModel.INotifyPropertyChanged interface. On the property setters, a developer will write code to raise the PropertyChanged event when a new value is set in the property. The example shows how to write a helper method to ease raising this event. To add or delete records one would call either InsertOnSubmit or DeleteOnSubmit on the generic GetSheet method of the provider. When you would like to commit your changes to Excel, simply call SubmitChanges on the provider and all the inserts, updates, and deletes are committed to the Excel spreadsheet.

The C# source file is available here

A VB.Net version of the source is available here

An online code generator to build the LINQ to Excel class is available here

ExcelProvider provider = ExcelProvider.Create(@"c:\deploy\Book1.xls");
foreach (Person per in (from p in provider.GetSheet<Person>() where p.LastName == "Johnson" select p))
{
per.LastName = "Smith";
}
Person p = new Person();
p.Id = 10.0;
p.FirstName = "Alex";
p.LastName = "Zander";
p.BirthDate = new DateTime(1980, 4, 4);
provider.GetSheet<Person>() InsertOnSubmit(p);
provider.SubmitChanges();
Console.WriteLine("Done");


[ExcelSheet(Name="Sheet1")]
public class Person: System.ComponentModel.INotifyPropertyChanged
{
private double id;
private string fName;
private string lName;
private DateTime bDate;


public event System.ComponentModel.PropertyChangedEventHandler PropertyChanged;


protected virtual void SendPropertyChanged(string propertyName)
{
System.ComponentModel.PropertyChangedEventHandler handler = PropertyChanged;
if (handler != null)
{
handler(this, new System.ComponentModel.PropertyChangedEventArgs(propertyName));
}
}

public Person()
{
id = 0;
}
[ExcelColumn(Name="ID",Storage="id")]
public double Id
{
get { return id; }
}

[ExcelColumn(Name = "FirstName", Storage = "fName")]
public string FirstName
{
get { return this.fName; }
set { fName = value;
SendPropertyChanged("FirstName");

}
}

[ExcelColumn(Name = "LastName", Storage = "lName")]
public string LastName
{
get { return this.lName; }
set { lName = value;
SendPropertyChanged("LastName");

}
}

[ExcelColumn(Name = "BirthDate", Storage = "bDate")]
public DateTime BirthDate
{
get { return this.bDate; }
set { bDate= value; }
SendPropertyChanged("BirthDate");

}
}
}