public static BulkUploadToSql Load(Stream dataSource) { // create a new object to return BulkUploadToSql o = new BulkUploadToSql(); // replace the code below // with your custom logic for (int cnt = 0; cnt < 20; cnt++) { MyRecord rec; if (cnt % 2 == 1) { rec = new MyRecord("Test", "Test Job", $"ID{cnt}", $"Component{cnt}"); } else { rec = new MyRecord("Test", "Test Job", $"ID{cnt}", $"Component{cnt}", $"ComponentId{cnt}"); } o.internalStore.Add(rec); } return(o); }
static void Main(string[] args) { using (Stream s = new FileStream(@".\\Key Valuations Export (1).xlsx", FileMode.Open)) { ExcelPackage e = new ExcelPackage(s); BulkUploadToSql myData = BulkUploadToSql.Load(e); myData.Flush(10); //myData.Flush(); } }
public static BulkUploadToSql Load(ExcelPackage e) { BulkUploadToSql o = new BulkUploadToSql(); o.excelWorksheet = e.Workbook.Worksheets["Asset Register"]; if (o != null) { return(o); } else { throw new NullReferenceException("SpreadSheet Not Exist"); } }