I have a custom bill of material excel sheet.

It has:

1.item nos in the first column,

2.Qty. of the items in the second column ( eg. 2 for an item having similar dimaensions & properties).

3.Description of the item in the third column (eg. 0.25" thk. x 8.5" plate, L 3x3x0.25 angle, C6x8.2 channel or a I-section etc.),

4.Length of the items in the fourth column,

5.Material of the item in next column (say A36 or A312 TP310),

6.Weight of the items in the last column

Can I have such a BOM in solidworks generated 2D drawings. Can I get such a BOM or I have to enter the values manually.

How should I make my model so that I get each & every item separately with all its dimensions & properties.

Thanking you in  anticipation.

Ashish