Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
Re: Get Excel column name for given decimal numberby dasgar (Priest) |
on Mar 26, 2020 at 21:19 UTC ( [id://11114689]=note: print w/replies, xml ) | Need Help?? |
You might be interested in the int2LATIN function from the Number::Latin module. Alternatively, since you are using Win32::OLE to control Excel directly, there are methods for specifying a cell by using integers to specify a row and column. I don't remember the details and there are some situations where that method isn't available. That's why I consider Number::Latin to be indispensable when using Win32::OLE to control Excel. Using your example of column number 703 (aka column AAA):
In Section
Seekers of Perl Wisdom
|
|