sub create_excel { my $name = shift; my $worksheet = $workBook->add_worksheet( "$name" ); #my $format = $workBook->add_format ( border => 2, valign => 'vcenter', align => 'center', bold => 1, ); #$format->set_bg_color('47'); #my $format1 = $workBook->add_format ( border => 2, align => 'center', bold => 1 ); #$format1->set_bg_color('47'); #my $format2 = $workBook->add_format ( border => 2, valign => 'vcenter', align => 'center', bold => 1, ); #$format2->set_bg_color('42'); #$worksheet->set_column ( "C:C",40 ); #$worksheet->merge_range ( "C6:C8","TEST",$format ); #$worksheet->merge_range ( "D6:H6","RESULT",$format ); #$worksheet->merge_range ( "I6:N6","PAGES",$format ); return $worksheet; }