in reply to Split int into segments of max int 26
Take a look at Number::Latin - and in particular, the int2LATIN function. I've used this module for this exact purpose, but in my case I was using Win32::OLE to directly control Excel to do the Excel file manipulation. I had wanted to keep the column stored as an integer to make it easier for iterating through columns, but needed the ASCII labels for the cell identification for the Excel.
|
---|
In Section
Seekers of Perl Wisdom