Skip to content

Instantly share code, notes, and snippets.

@eternalharvest

eternalharvest/simple excel template.cs

Created August 25, 2018 07:00
Show Gist options
  • Save eternalharvest/63ba25b5def2ad05b5eb9425552c3327 to your computer and use it in GitHub Desktop.
Save eternalharvest/63ba25b5def2ad05b5eb9425552c3327 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
simple excel template.cs
// Compose Data
Dictionary<string, object> data = new Dictionary<string, object>();
data["NAME"] = "Takuya Sawada";
data["GENDER"] = "Male";
data["BIRTH"] = new DateTime(1989, 3, 3).Date;
data["TODAY"] = DateTime.Today.Date;
data["LEVEL"] = 99;
// Render template
XLWorkbook workbook = new XLWorkbook(@"C:\Users\takuya\Desktop\template.xlsx");
IXLWorksheet sheet = workbook.Worksheet("Sheet1");
foreach (IXLNamedRange nr in workbook.NamedRanges)
{
if (data.ContainsKey(nr.Name))
{
workbook.Cell(nr.Name).Value = data[nr.Name];
}
}
// Save
workbook.SaveAs(@"C:\Users\takuya\Desktop\takuya.xlsx");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment