http://qs321.pair.com?node_id=1199340


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.

  • Comment on Re: Split int into segments of max int 26