use strict; use warnings; use Excel::Writer::XLSX; my $workbook = Excel::Writer::XLSX->new( "Cell_Borders.xlsx" ); my $worksheet = $workbook->add_worksheet(); my $textbox1 ="Hello World!"; my $format_box = $workbook->add_format(); $format_box->set_top('5'); $format_box->set_bottom('5'); $worksheet->merge_range( 'A8:B8', "$textbox1", $format_box );