in reply to
convert excel cell into "Text" format with Excel:: Write::xlsx modul
In the Excel::Writer::XLSX documentation, under write, it mentions that you can use the add_write_handler() method to make write do something differently. So if you have too many write() methods in your project, you might just add a write handler to treat everything as a string, so you'd only need to add a bit of code at the beginning.
When your only tool is a hammer, all problems look like your thumb.