private Dictionary <string, IList <ExcelField> > CasosBordeFecha(ExcelField field) { Dictionary <string, IList <ExcelField> > list = new Dictionary <string, IList <ExcelField> >(); list.Add(field.Name, new List <ExcelField>() { new ExcelField { Name = field.Name, Type = field.Type, Value = DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss"), IsTester = true, }, new ExcelField { Name = field.Name, Type = field.Type, Value = DateTime.MinValue.ToString("yyyy-MM-ddTHH:mm:ss"), IsTester = true, }, new ExcelField { Name = field.Name, Type = field.Type, Value = DateTime.MaxValue.ToString("yyyy-MM-ddTHH:mm:ss"), IsTester = true, }, new ExcelField { Name = field.Name, Type = field.Type, Value = "${empty}", IsTester = true, }, new ExcelField { Name = field.Name, Type = field.Type, Value = "${null}", IsTester = true, }, }); return(list); }
private void ProcessFiels(string fileExcel, IList <string> fielsXml) { using (var excel = new ExcelQueryFactory(fileExcel)) { var header = (from c in excel.WorksheetNoHeader(0) select c).FirstOrDefault(); var data = (from c in excel.Worksheet(0) select c).ToList(); foreach (var item in data) { if (fielsXml.Any(x => x == item[0])) { List <ExcelField> list = new List <ExcelField>(); for (int i = StartColumnData; i < item.Count; i++) { if (!string.IsNullOrWhiteSpace(header[i])) { var field = new ExcelField { Name = item[0], Value = item[i] }; //Valida el tipo ExcelFieldType tipo = ExcelFieldType.None; Enum.TryParse(item[1]?.Value?.ToString()?.Replace(":", ""), true, out tipo); field.Type = tipo; list.Add(field); } } Fields.Add(item[0], list); CountFiles = list.Count; } } } }
private Dictionary <string, IList <ExcelField> > CasosBordeNumerico(ExcelField field) { Dictionary <string, IList <ExcelField> > list = new Dictionary <string, IList <ExcelField> >(); list.Add(field.Name, new List <ExcelField>() { new ExcelField { Name = field.Name, Type = field.Type, Value = field.MinValue, IsTester = true, }, new ExcelField { Name = field.Name, Type = field.Type, Value = "A", IsTester = true, }, new ExcelField { Name = field.Name, Type = field.Type, Value = "-1", IsTester = true, }, new ExcelField { Name = field.Name, Type = field.Type, Value = "+1", IsTester = true, }, new ExcelField { Name = field.Name, Type = field.Type, Value = "1.1", IsTester = true, }, new ExcelField { Name = field.Name, Type = field.Type, Value = "1,1", IsTester = true, }, new ExcelField { Name = field.Name, Type = field.Type, Value = "1 1", IsTester = true, }, new ExcelField { Name = field.Name, Type = field.Type, Value = "01", IsTester = true, }, new ExcelField { Name = field.Name, Type = field.Type, Value = "${empty}", IsTester = true, }, new ExcelField { Name = field.Name, Type = field.Type, Value = "${null}", IsTester = true, }, }); return(list); }