I want to write a table into Excel file with fomula "=AVERAGE(G18:G64)", how to transfer table column nunber into excel column letter?
for example, from table column 7, how to know 7 means G in excel?
..this is why we can't have nice things...
Here is a VI that converts an Excel Column String notation "A", "BA" to the excel zero based column numeric. This is very handy when you want to allow a layman to create an excel cell insert map using the Letter column normenclature displayed in Excel: "AC".
I don't know why this does not exist in any of the MS Office routines, it can give you headaches to have to convert letters to numbers, then adjust for zero based.