Windchill Export List to XLSX

Export List to XLSX

How to create empty files (.prt, .asm, .drw…) in a windows working directory from your workspace.

1.  Open workspace and select FILE | Export List to File | Export List to XLSX

2.  Open the .XLSX file that was created and copy the File Name column.

3.  Add a new sheet and paste the File Name column into the “B” column.  (At this time remove any rows that are not required.)  In the “A” column insert the dos command “type nul >”  for each row.

4.  Copy and paste these values into notepad.

5.  Save the notepad file as a .bat file (create_empty_files.bat) in your windows working directory.

6. Navigate to the windows working directory and execute the create_empty_files.bat

7. Empty windows files (.prt, .asm, .drw…) have now been created from your work space file list.