File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Please help me out Parent-Child hierarchy construction

 
disha dhananjay
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am new to VB, saw your post on providing parent child hierarchy in visually structured way in excel. Hoping that you will help me out in this issue .
There is a table in xl as below:
Calling Called
Folder1 Sub1
Folder1 Sub2
Sub1 Sub3
Sub3 Sub4
Folder2 Sub6
Folder2 Sub7
Sub7 Sub8
Sub7 Sub9

Explaination of the table:
"Folder1" is calling child "Sub1" and "Sub1" is calling "Sub3", and likewise ...

I need an output in an hierarchy saying parent->child->subchild...

Expected Output 1:
Folder1->Sub1->Sub3->Sub4
Folder1->Sub2
Folder2->Sub6
Folder2->Sub7->Sub8
Folder2->Sub7->Sub9

Expected Output 2:
In the 3rd column of excel against each row of Calling & Called columns ,Output should be as below(i.e, Parent|Child|...):
Folder1|Sub1
Folder1|Sub2
Folder1|Sub1|Sub3
Folder1|Sub1|Sub3|Sub4
Folder2|Sub6
Folder2|Sub7
Folder2|Sub7|Sub8
Folder2|Sub7|Sub9

Please help me out in this. Thanks
 
Steve Luke
Bartender
Pie
Posts: 4181
21
IntelliJ IDE Java Python
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Disha,

As this is a Visual Basic question (I think). Since it isn't a Java question, I am moving it from to the 'Other Languages' forum, where it will be more applicable.

As to your question: I do not understand what you are asking - not even a little bit. Perhaps you can provide more detail and description about the actual problem. Showing the code you have and telling us where it fails would also be helpful.
 
Steve Luke
Bartender
Pie
Posts: 4181
21
IntelliJ IDE Java Python
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
disha dhananjay wrote:http://www.coderanch.com/t/625739/ol/Parent-Child-hierarchy-construction#2862176

Based on the above link , I am in need of the output on urgent basis.Could you please accept my invitation from gmail. thanks. Will explain more in detail there...


Please UseTheForumNotEmail (<- link). If you would like some help, provide the details here and let the community help you - which will be better than trying to get a single person to help. Besides, I have very little VB experience, perhaps someone here will be able to help you better.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic