http://qs321.pair.com?node_id=849965


in reply to UTF-8 issues with Perl in general and with Spreadsheet::WriteExcel

can you try to use method
add_format(%properties)