protected override void loadDataFromXls()
{
var run = true;
var row = 2;
var dataCol = new List<BusinessPartnerRaw>();
while (run)
{
////Neues Objekt erzeugen
var data = new BusinessPartnerRaw();
data.BP_Partner_Id = checkCell(row, 1);
data.BP_BusType = checkCell(row, 2);
data.BP_NoPost = checkCell(row, 3);
data.BP_NoPhone = checkCell(row, 4);
data.BP_NoEmail = checkCell(row, 5);
data.BP_SRT = checkCell(row, 6);
data.BP_HO = checkCell(row, 7);
data.BP_Parent = checkCell(row, 8);
data.BP_Mailing_Name = checkCell(row, 9);
if (!data.NoChanges()) dataCol.Add(data);
row++;
//Go-On?
var v = _sheet.Cells[row, 1].Text.ToString();
if (string.IsNullOrEmpty(v))
{
run = false;
}
}
data = dataCol;
}
protected override void loadDataFromXls()
{
var run = true;
var row = 2;
var dataCol = new List<BusinessPartnerRaw>();
while (run)
{
////Neues Objekt erzeugen
var data = new BusinessPartnerRaw();
data.BP_Partner_Id = checkCell(row, 1);
data.BP_Mailing_Name = checkCell(row, 2);
data.BP_Name = checkCell(row, 3);
data.BP_Role = checkCell(row, 4);
data.BP_Industry_sec = checkCell(row, 5);
data.BP_Houseno = checkCell(row, 6);
data.BP_Street = checkCell(row, 7);
data.BP_Street4 = checkCell(row, 8);
data.BP_District = checkCell(row, 9);
data.BP_City = checkCell(row, 10);
data.BP_Pcode = checkCell(row, 11);
data.BP_Regio = checkCell(row, 12);
data.BP_Phone = checkCell(row, 13);
data.BP_Fax = checkCell(row, 14);
data.BP_EMail = checkCell(row, 15);
data.BP_EMail2 = checkCell(row, 16);
data.BP_Web = checkCell(row, 17);
data.BP_BusType = checkCell(row, 18);
data.BP_NoPost = checkCell(row, 19);
data.BP_NoPhone = checkCell(row, 20);
data.BP_NoEmail = checkCell(row, 21);
data.BP_SRT = checkCell(row, 22);
data.BP_HO = checkCell(row, 23);
data.BP_Parent = checkCell(row, 24);
if (!data.NoChanges()) dataCol.Add(data);
row++;
//Go-On?
var v = _sheet.Cells[row, 1].Text.ToString();
if (string.IsNullOrEmpty(v))
{
run = false;
}
}
data = dataCol;
}