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); }
public static Guid GetFileId(FilestoreFile excelDet) { if (excelDet != null) { try { XlCustomProperties props = XlWorkbook.LoadProperties(excelDet); foreach (XlCustomProperty property in props) { if (property.Name == "oncorId") { string guidValue = property.Value; if (!string.IsNullOrEmpty(guidValue)) { return(Guid.Parse(guidValue)); } } } } catch { } } return(Guid.Empty); }