none
Excel named ranges structure to treeview (treestructure) RRS feed

  • Question

  • I have an Excel sheet (Excel 2007) with many named ranges. I want to visualize the hierarchical structure of all named ranges in a treeview (with VSTO / C#). What would be the best and effective way to parse the named ranges hierarchy structure (ranges can consist again of ranges, so there is a father/child relationship) and transfer into a treeview (maybe with an XML structure beetween the Excel and the treeview representation).
    Friday, June 28, 2013 1:16 PM

All replies

  • Hi Mober,

    Thank you for posting in the MSDN Forum.

    I'm trying to involve some senior engineers into this issue and it will take some time. Your patience will be greatly appreciated.

    Sorry for any inconvenience and have a nice day!

    Best regards,


    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, July 1, 2013 12:52 PM
    Moderator
  • Hi,

    Named ranges are tied either to a Workbook or a Worksheet. Excel object model does not have APIs to define relationships between named ranges. You would have to devise your own logic to define the relationships between the named ranges and build an XML out of it to bind to a tree structure.

    Regards

    Pradip

    Tuesday, July 30, 2013 12:39 PM