Skip to main content
14-Alexandrite
May 29, 2024
Question

Multi-level CAD structure output to Excel

  • May 29, 2024
  • 3 replies
  • 916 views

Version: Windchill 12.0

 

Use Case: I have an indented CAD structure. I can export this to Excel and the indentions will persist in a column as expected.


Description:

For use in another application however, I would like each indented level to be put into a new column to the right of the previous one. in the Excel export.

3 replies

HelesicPetr
22-Sapphire II
22-Sapphire II
May 30, 2024

Hi @AJ_TROGLIO 

Write an excel vba script to restructure the output from Windchill.

It is easier and you do not have to customize the Windchill

PetrH

Community Moderator
June 24, 2024

Hi @AJ_TROGLIO,

 

I wanted to follow up with you on your post to see if your question has been answered. 
If so, please mark the appropriate reply as the Accepted Solution. 
Of course, if you have more to share on your issue, please let the Community know so that we can continue to help you. 

 

Thanks,
Anurag

avillanueva
23-Emerald I
23-Emerald I
June 25, 2024

Easy to do in excel with fill down formula that has a trim or clean function to remove the indentation.