Automatic BOM genrator

We are working on a project in which we have to prepare the Bill of material.
with help of excel BOm should be generated and pdf file of the BOM should be save to local drive