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);
}
