How can I combine multiple Excel worksheets into a single workbook using Perl?
I am producing 5 different Excel worksheets (.csv file) using Perl. I want to combine all these as one file (Excel workbook) with 5 different worksheets rather then have 5 seperate files.
here is the script i'm using now ..
Code:
#!/usr/bin/perl -w
use lib "/csv2xl/lib/site_perl";
use strict;
use Spreadsheet::WriteExcel;
open ( TABFILE, 'Testing.csv' ) or die "Testing.csv: