private void BtnOK_Click(object sender, EventArgs e) { MappingColumnParameter mPC = new MappingColumnParameter(LoadExcelFile.document); mPC.Close(); this.Close(); }
public void Correct(String txtFileName) { //try //{ var wb = new XLWorkbook(txtFileName); var ws = wb.Worksheet(1); var firstRowUsed = ws.FirstRowUsed(); var categoryRow = firstRowUsed.RowUsed(); categoryRow = categoryRow.RowBelow(); var firstPossibleAddress = ws.Row(categoryRow.RowNumber()).FirstCell().Address; var lastPossibleAddress = ws.LastCellUsed().Address; var Range = ws.Range(firstPossibleAddress, lastPossibleAddress).RangeUsed(); var Table = Range.AsTable(); //var cellRowAddress = ""; //var cellColumnAddress = ""; //string param = ""; List <string> valuesParameter = Table.DataRange.Rows().Select(companyRow => companyRow.Field(ShowColumnCategory.uniqueParameter).GetString()).ToList(); foreach (string item in valuesParameter) { Categories categories = LoadExcelFile.document.Settings.Categories; Category cat; cat = categories.get_Item(Form1.selectedCategory); BuiltInCategory builtInCategory = (BuiltInCategory)cat.Id.IntegerValue; FilteredElementCollector collector = new FilteredElementCollector(LoadExcelFile.document); IList <Element> elementsOfCategory = collector.WhereElementIsNotElementType().OfCategory(builtInCategory).ToElements(); foreach (Element el in elementsOfCategory) { Parameter uniqueParameter = el.LookupParameter(ShowColumnCategory.uniqueParameter); if (item.ToString() != uniqueParameter.AsString()) { } } } MappingColumnParameter mapingColumnParameter = new MappingColumnParameter(LoadExcelFile.document); mapingColumnParameter.ShowDialog(); //} //catch //{ // TaskDialog.Show("Error!", "Unique key is not correct!"); //} }