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