Is it possible to make assembly pattern met excel

Well, there is this:

2017 SOLIDWORKS Help - Pattern Tables

Although the pattern information won't be linked to excel, you can copy and paste it from there.

There is also these:

How can I control a component pattern instance in an assembly using design table ?

Linear Pattern Instance Control in Design Tables

Circular paterns in Design Table