Excel Column Convert Letters to Numbers
Standard spreadsheet applications use letters to reference columns and numbers to reference rows. I am creating an interface to map columns to data and needed to convert the columns to integers. Column AB for example is really position 29. When you upload a CSV file and spin through it for example, you need the numerical position.
here is a simple function to convert the columns to integers.
And to output all the 2 letter combinations in order, for example to populate a dropdown menu with the choices, you could use a simple nested loop like this.
If you are still using Microsoft Excel, consider switching to OpenOffice. It is a FREE opensource alternative to the Micorsoft Office suite. Don't worry, you can still view, edit and create the native Microsoft formats so sharing files with your friends and co-workers is a seamless process. I have used OpenOffice exclusively for years.
You’re currently reading “ Excel Column Convert Letters to Numbers ,” an entry on BRADINO
- Published:
- 8.9.08 / 3pm
- Category:
- PHP























Have your say