Can someone point me in the right direction please, I don't have any previous experince in solidworks and need to extract and combine the BOM for an entire project.

These consist of hundreds of drawings in multiple different folders.

An ideal solution would be one that could be pointed at a directory and would itterate through all the sub folders finding all drawings and extracting the BOM into an excel spreadsheet as it appears on the drawing.

Example output:

Is it possible to extract BOM data without having to open the drawing?