protected override void ReadDoc() { base.ReadDoc(); CreateShopList(); bool endrange = true; int index = 3; var expression = new Regex("([0-9]-[0-9]{3,18})", RegexOptions.None); while (endrange) { Cells = Sheet.Range[GetColumnIndex(0, index), Type.Missing]; if (Cells.Value2 != null) { Match m = expression.Match(Cells.Value2); if (m.Success) { var rec = GetOrderRecord(index); if (rec != null) { DataRecords.Add(rec); } } } else { endrange = false; } index++; } }
/// <exception cref="FormatException">Не правильный формат файла. Лист AssortForOrder не найден.</exception> protected override void ReadDoc() { Excelsheets = Workbook.Worksheets; Sheet = (Worksheet)Excelsheets.Item[1]; if (Sheet.Name != "ReqAssort") { throw new FormatException(@"Не правильный формат файла. Лист ReqAssort не найден."); } Cells = Sheet.Range["A1", Type.Missing]; string str = Convert.ToString(Cells.Value2); if (str != "Код") { throw new FormatException(@"Не правильный формат файла. Поле Код не найдено."); } bool endrange = true; int index = 2; var expression = new Regex("([0-9]-[0-9]{3,18})", RegexOptions.None); while (endrange) { string eindex = string.Format("A{0}", index); Cells = Sheet.Range[eindex, Type.Missing]; if (Cells.Value2 != null) { Match m = expression.Match(Cells.Value2); if (m.Success) { DataRecords.Add(new DataRecord() { Code = Convert.ToString(Cells.Value2) }); } } else { endrange = false; } index++; } }
protected override void ReadDoc() { NestleFormatCheck(); bool endrange = true; int index = 2; while (endrange) { Cells = Sheet.Range[GetColumnIndex(0, index), Type.Missing]; if (Cells.Value2 != null) { DataRecords.Add(GetNestleOrderRecord(index)); } else { endrange = false; } index++; } }