$worksheet->set_row( 8, 0 ); $worksheet->set_column( 'A:B', 30 ); $worksheet->set_border('A:B',30); # Set borders on this range $worksheet->set_top('A:B',30); #Set border only to top my $format_box = $workbook->add_format( border => 1, underline => 0, color => 'black', align => 'left', valign => 'top', ); #### my $format_box = $workbook->add_format( #border => 1, underline => 0, color => 'black', align => 'left', valign => 'top', ); $format_box = set_border(1); # Turn on borders $format_box = set_top(1); # Set value to true