http://www.perlmonks.org?node_id=414703


in reply to Converting numbers to Excel Column indices

How is this better than 
use Spreadsheet::WriteExcel::Utility;

my ($cell) = xl_rowcol_to_cell( 0, $col );

[download]
You now have something that's like "AX0" or something. Strip off the zero and you have the column.

Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

Replies are listed 'Best First'.
Re^2: Converting numbers to Excel Column indices
by Willworker (Acolyte) on Dec 29, 2004 at 22:46 UTC
    Probably isn't. Just hadn't seen any (working) way to do this when I googled/google group'd the topic, and couldn't find a way in the OLE documentation that I'd seen, so I wanted to have something up for others. (And this way I get feedback, to boot.)
[reply]

In Section Cool Uses for Perl