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