private void InitData() { List <AttributesUtils.EnumItem> listFieldType = AttributesUtils.GetEnumList <Common.BaseEnum.Enumeration.FieldTypes>(); ExcelFieldType.DataSource = listFieldType; ExcelFieldType.DataTextField = "Value"; ExcelFieldType.DataValueField = "Key"; ExcelFieldType.DataBind(); SQLFieldType.DataSource = listFieldType; SQLFieldType.DataTextField = "Value"; SQLFieldType.DataValueField = "Key"; SQLFieldType.DataBind(); }
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; } } } }