2009-08-19 Business loves Excel, Engineers loves XML

2009-08-19 business-loves-excel-engineers-loves-xml

# Title: Business loves Excel, Engineers loves XML
# Author: Mikael Lundin
# Link: http://blog.mikaellundin.name/2009/08/19/business-loves-excel-engineers-loves-xml.html

Example.cs

var repo = new ExcelRepository(this.filePath, ExcelVersion.PreExcel2007);

repo.AddMapping(x => x.Country, "COUNTRY");
repo.AddMapping(x => x.ZipCode, "ZIPCODE");
repo.AddMapping(x => x.City, "CITY");

var q = from worksheet in repo.Worksheet(ZipCodeWorksheet.Name)
        where worksheet.ZipCode == indata
        select worksheet;

ZipCodeWorksheet.cs

public class ZipCodeWorksheet
{
    public const string Name = "Report";

    public string Country { get; set; }
    public string ZipCode { get; set; }
    public string City { get; set; }
}