in reply to Re^2: Spreadsheet::WriteExcel cell formatting.
in thread Spreadsheet::WriteExcel cell formatting.

I want it to be formatted as a string

Then your only option is to muck around with Excel itself (either a different version, or some macro to get rid of the warning).

From what you describe, you want the cell to be formatted as text, however Excel is detecting that there is a number in the cell formatted as text and is attaching a warning to the cell indicating this. There is nothing Perl can do about that.

fishmonger's previous suggestion to correctly format the cell is the only way Perl can affect the warning triangle you are seeing in Excel.

  • Comment on Re^3: Spreadsheet::WriteExcel cell formatting.

Replies are listed 'Best First'.
Re^4: Spreadsheet::WriteExcel cell formatting.
by anonymonk (Acolyte) on Sep 23, 2015 at 18:34 UTC

    well thats a bummer, i was hoping to be able to do all of this from a perl script. Thanks for the help.

[reply]

In Section Seekers of Perl Wisdom