public static void LoadFromSheet <T>(string path, string sheetName, List <string> logMessage) where T : class, new() { List <T> list = new(); var sheet = ExcelWorker.ReadExcel(path, sheetName, logMessage); if (sheet != null) { AssignValue(list, sheet, logMessage); } }
public static ExcelPackage CopyDBtoExcel() { ExcelPackage.LicenseContext = LicenseContext.NonCommercial; IndustrialExcelPackage = new ExcelPackage(); ExcelWorker.CreateExcelPackage(IndustrialExcelPackage); AssignDBTableToSheet <Equipment>(ValidSheetNames.Equipment.ToString()); AssignDBTableToSheet <Valve>(ValidSheetNames.Valve.ToString()); AssignDBTableToSheet <Instrument>(ValidSheetNames.Instrument.ToString()); return(IndustrialExcelPackage); }
public static ExcelPackage CreateEmptyTemplate() { ExcelPackage.LicenseContext = LicenseContext.NonCommercial; IndustrialExcelPackage = new ExcelPackage(); ExcelWorker.CreateExcelPackage(IndustrialExcelPackage); CreateExcelSheet <Equipment>(ValidSheetNames.Equipment.ToString()); CreateExcelSheet <Valve>(ValidSheetNames.Valve.ToString()); CreateExcelSheet <Instrument>(ValidSheetNames.Instrument.ToString()); return(IndustrialExcelPackage); }