my $textFormat = $workbook->add_format( num_format => 'Text' ); $detail->set_column('A:D', undef, $textFormat);