WriteExcel module set_row and set_column to group by both

From: romanmr (romanmr1_at_hotmail.com)
Date: 01/20/05 

Date: 20 Jan 2005 13:40:36 -0800

Hi,
Is it possible to use set_row and set_column functions to group the
range by both rows and columns? I am getting either one or the other.
#!/usr/local/bin/perl

use strict;
use Spread***::WriteExcel;

my $workbook = Spread***::WriteExcel->new("test.xls");
my $wsh = $workbook->add_work***("test");
my($i);

for ($i=0; $i<10; $i++)
{
if($i<5)
{ $wsh->set_column($i, $i, undef, undef, 1, 1); }
else{ $wsh->set_column($i, $i, undef, undef, 1, 2);};
};
#
# when I copy rest of the code above previous block
# I get rows grouped but not columns
#
for ($i=0; $i<10; $i++)
{
if ($i<5)
{
$wsh->set_row($i, undef, undef, 1, 2);
}else{ $wsh->set_row($i, undef, undef, 1, 1);};
};
   
$workbook->close();
exit(0);