Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Converting numbers to Excel Column indices

by dragonchild (Archbishop)
on Dec 14, 2004 at 13:57 UTC ( #414703=note: print w/replies, xml ) Need Help??


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 );
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.)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://414703]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (4)
As of 2020-06-02 05:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you really want to know if there is extraterrestrial life?



    Results (13 votes). Check out past polls.

    Notices?