If you know your product structure, you can obtain a spreadsheet report (using the Spreadsheet command) from any level by going to the desired level in the upper left side of the spreadsheet editor without opening in CATIA editor the desired product structure.