in reply to Alternative to Win32::OLE when using Excel?
As Limbic~Region states, you've got a lot of different questions packed up in there.
As far as whether you would use Spreadsheet::WriteExcel or Win32::OLE, I had to choose a couple of years ago, and wrote about my experience here.
In Section
Seekers of Perl Wisdom