/// <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);
}
