Export Assembly To Excel with level position on cells

[nxexplorer]

Hi,...I need help.
For BoM in Excel purposes, I have already tried to use the nice journal "Export Assembly To Excel With Pictures"

http://nxjournaling.com/content/export-assembly-excel-pictures-0

(by Ian Eldred) and It was running good.

But in my customer, need an assembly-like picture as shown in the attachment, the levels of each part which is described as the position of part name on the excel column. For example for The First Level of Assy, The part name will be placed in the cell of column B, For the Second Level in the cell of column C, the Third level in the cell of column D, and so on.

If someone has an idea to modify the journal file above, please inform me.

Attachment:

https://files.engineering.com/getfi...97a-968d-b6229dc0d3af&file=assembly-excel.JPG

Thank you,
Maryadi

 

[SkipVought]

Hi,

But in my customer, need an assembly-like picture…

There are the columns defined by the referenced program...

'
    Dim colLevel As Integer = 1
    Dim colImage As Integer = 2
    Dim colID As Integer = 3
    Dim colDescription As Integer = 4
    Dim colQuantity As Integer = 5
    Dim colParentChild As Integer = 6
    Dim colParent As Integer = 7
    Dim colBranchTop As Integer = 8
    Dim colBranchCreated As Integer = 9
'...

Search formulas for these consecutive lines of code and change the numeric values that relate the columns.


Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[Toost]

Do you need a journal for this ?
have you tried to right click the assembly navigator and -export to spreadsheet ?

It will not do the indentation in different columns but using spaces in the first column.

Regards,
Tomas

Never try to teach a pig to sing. I wastes your time and it annoys the pig.

 

[nxexplorer]

@SkipVought
Hi Skip, I much appreciate the idea from you.
Thank you very much, I will try this.

@Tomas,
Hi Tomas, I also much appreciate this simple idea, Thank you. My next Idea, I will create a vba in excel to process the xlsx result.

Thank you,
Maryadi

 

[Toost]

Side note on the export I mentioned above.
It will export all visible columns in the NX navigator, you can add/ remove / reorder as desired.

Regards,
Tomas

Never try to teach a pig to sing. I wastes your time and it annoys the pig.

 

[nxexplorer]

I have some columns that before I already made as new attribute columns.
Yes, I have added them as a new column, ready to export.
Thank you, Tomas, for reminding me.

Regards,
Maryadi