private static void WriteWorkbook(string fName)
{
Console.WriteLine("Creating workbook named [{0}]", fName);
XlWorkbook book = new XlWorkbook();
XlWorksheets sheets = book.Worksheets;
XlSchema schema = GetDeploymentSchema();
XlWorksheet sheet = sheets.AddWorksheet("DET_Deployments", XlColor.White, schema);
GetDeploymentRows(sheet);
schema = GetMeasurementSchema();
sheet = sheets.AddWorksheet("DET_Measurements", XlColor.White, schema);
GetMeasurementRows(sheet);
schema = GetSiteSchema();
sheet = sheets.AddWorksheet("LIST_Sites", XlColor.Orange, schema);
GetSiteRows(sheet);
schema = GetSensorSchema();
sheet = sheets.AddWorksheet("LIST_Sensors", XlColor.Orange, schema);
GetSensorRows(sheet);
XlCustomProperties properties = book.Properties;
properties.AddCustomProperty("oncorId", Guid.NewGuid().ToString());
properties.AddCustomProperty("oncorUser", "Dr. Frank N. Furter, ESQ");
book.Save(fName);
Console.WriteLine("Closing workbook named [{0}]", fName);
}
private XlWorkbook CreateWorkBook(IEnumerable <DataTab> tables)
{
XlWorkbook book = new XlWorkbook();
foreach (DataTab tab in tables)
{
AddRows(book, tab);
}
XlCustomProperties properties = book.Properties;
properties.AddCustomProperty("oncorId", Id.ToString());
properties.AddCustomProperty("oncorUser", Owner);
return(book);
}