in reply to Spreadsheet::WriteExcel: How to change order of worksheets?
Do you know the names of the workbooks in advance so you can sort on that? You can store your worksheets in a hash so you can reference them properly later to addataand so on.
my %worksheets; foreach my $w (sort @ws_names_from somewhere){ $worksheets{$w} = $workbook->add_worksheet( $w ); }
--
Clayton
Clayton
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Spreadsheet::WriteExcel: How to change order of worksheets?
by zeno (Friar) on Jan 04, 2005 at 18:28 UTC | |
by RMGir (Prior) on Jan 04, 2005 at 21:15 UTC |
In Section
Seekers of Perl Wisdom