Looking to build a TreeView dynamically from an Array (Array built from excel sheet)
Have not made the excel sheet yet, so I'm open to suggestions on layout so as to make it easiest as possible to get it into a treeview.
Thinking each row could be a item to add with the columns defining the placement in the trees, Like:
Cells(1,1) = "Level 1 Parent Name"
Cells(1,2) = "Level 2 Parent Name"
Cells(1,3) = "Level 3 Parent Name"
Cells(1,4) = "Add this item"
Cells(1,5) = ""
When value = "" then
Create entire branch or any part of it that doesn't already exist.
advance to next row
For processing speed I'd probably want to work with an array, like:
$aExcelData = _ExcelReadSheetToArray($oExcel,2,1,$LastUsedRow,$LastUsedCol)
Can someone help me with the loop? or maybe point to tool that may do this?