in reply to Excel::Writer::XLSX how to get the required format?

Here is a related post WriteExcel : The text 801495E40 turns into 8.01495E+45 using Spreadsheet::WriteExcel.

  • Comment on Re: Excel::Writer::XLSX how to get the required format?

Replies are listed 'Best First'.
Re^2: Excel::Writer::XLSX how to get the required format?
by Skeeve (Parson) on Jan 30, 2014 at 09:19 UTC

    Thanks! write_string was the correct hint.

    s$$([},&%#}/&/]+}%&{})*;#$&&s&&$^X.($'^"%]=\&(|?*{%
    +.+=%;.#_}\&"^"-+%*).}%:##%}={~=~:.")&e&&s""`$''`"e
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom