For example, have a look here - http://www.technologystudent.com/cams/cam11.htm
In these animations, we want to get the position data of the Follower axis.
I believe you can simulate this rotation in SolidWorks, but not sure if you can output data the moving components.
You can output the position data of a point into EXCEL. It requires SW Motion added in so that you can run a Motion Analysis and output a Trace Path plot.