/// <summary> /// Generate Tree View /// </summary> private void PopulateTreeView() { var xlApp = new Excel.Application(); var xlWorkbook = OpennessHelper.GetExcelFile(networkListPath, xlApp); foreach (Excel.Worksheet xlWorksheet in xlWorkbook.Worksheets) { string sheetName = xlWorksheet.Name; var matrix = OpennessHelper.ExcelToMatrix(xlWorksheet); if (OpennessHelper.IsNetworkList(matrix)) { Worksheets.Add(sheetName); } } xlWorkbook.Close(0); xlApp.Quit(); var projectTreeView = new TreeView(); foreach (var ws in Worksheets) { TreeViewItem tvi = new TreeViewItem { Tag = ws, Header = new CheckBox() { Content = new TextBlock() { Text = ws }, Tag = ws } }; projectTreeView.Items.Add(tvi); } if (projectTreeView.Items.Count == 0) { TreeViewItem tvi = new TreeViewItem { Header = "Excel does not contain a valid Worksheet" }; projectTreeView.Items.Add(tvi); BtnEnabled = false; } ProjectTree.Refresh(projectTreeView); }