|Think about Loose Coupling|
Re: Using Perl and WriteExcel to split data from one column to many othersby kcott (Chancellor)
|on Oct 03, 2012 at 00:08 UTC||Need Help??|
Welcome to the monastery.
This module has a method called write_row() whose documentation has:
"... This is useful for converting the results of a database query into an Excel worksheet. ..."
You should be able to modify your code to something like (untested):
I also noted Excel::Writer::XLSX has a method with the same name which appears to work the same (from a coding perspective).
Even if you're using a different module, you may still find the technique applicable. If not, let us know what you are using.