exporting flattened part length to excel

The goal is to populate the flattened length of multiple parts from within an assembly into a single excel sheet.

I need help, I am working on a project that we estimate will save a minimum of 1 hour a week, we have similar projects come through frequently. We have some flat bar in this assembly that is being driven to size by this assembly.

I was looking into linked excel sheet to each of these flat bar parts, but we end up with far too many excel sheets and we only want 1 if possible. I cannot find anyone that has successfully done so.

Macro looks to be the best way, (I am not too familiar with macro's, limited knowledge) but I would prefer linked somehow.

Does anyone have any ideas? thank you

SolidworksApi macros