Guru Needed!

I want to auto-generate SW parts models by Excel driven( may call logic based driven) method.

1. All dimensions and features of the model to be driven are first stored in Excel sheet(its sheet name 'dimensions'). In this sheet, the dimensions values and the states(suppressed or not) of all features are set by Excel functions or stored custom macros. ( I checked it running well)

2. All mate relationships are stored in the sheet of 'mate' if the component is an assembly( Logic function will arrange its mate relationships in the assembly) It is ok for simply assembly. But for a little more complicate assembly, it needs a 3D layout sketch to help make its mates simple. I have no confidence to use it control the relationships in the assembly with hundreds of subcomponents.

3.Components replacement with variable mate relationships, the question is  derived from question 2. I know, for manual operation in SW, it needs the same mate relationship for smooth component replacment. Now, I want to change its mates with the new component in  between the assembly. in other words, different type new component with different mate relationship. Of course, mates relationship is choosed and grouped by the logic function or macros in Excel.

4. Give your experience/ points of inserting components into assembly. my idea is to use 3D layout sketch to insert component for top level component. Oh, it is messy. I can't figure it out clearly now. (Hold)

By the way, Does the Document Manger API work for listing mate relationships in an assembly?

All GURUs,  Help me out if you come across the topic. You see I put myself in without weekend.