Is there any way to generate the BOM in excel sheet instead of *.txt format?
You can generate an Excel BOM using Scripts. Go to Tools>Basic Scripts>Basic Scripts. Then select Load File. There is a Bill of Materials to Excel.bas in the Scripts>Logic folder (mine is C:PADS Projects\Samples\Scripts\Logic\). Load this file, then run.
Thanks for the helpful comment!
Instead of producing the BOM as a .txt file, you can use the 'Clipboard View' tab and copy/paste the data directly to Excel.
Select 'File > Exports'
Click 'Setup' placed next to 'Bill of Materials'
In the 'Attributes' tab add the Part Attributes you want to see in the BOM.
In the 'Format' tab set the options you want.
In the 'Clipboard View' click in the 'reference' field header to sort by reference designators (if desired).
Enable 'Include table header'
Click 'Select All'
Open Excel and paste the data.
Good way for having the BOM in excel format.
i Searched script file i could not find it can you post the BOM script file !!!!!!!
1- you could follow as Klaus told before
Select 'File > Reports'
Checkmark the "Bill of Material"
Open Excel and paste the data
2- Or you could use the script file which is in this path (I'm using PADS 9.4)
I think method 1 creates a better BOM compared to method 2.
Retrieving data ...