Hi kfauth,
You can access the short name or the column number via the universal identifier (UID). See the following sample:
(Suppose "cc" is the long name of the third column, C)int nColUID = range2uid(col("cc"));
range cuid = uid2range(nColUID)$;
string cname$=uid2Name(nColUID)$;
cuid.name$=; //short name
cuid.LNAME$=; //long name
cuid.INDEX=; //column index
cname$=;
exist(cname$)=; //test of the dataset
> C
> cc
> cuid.INDEX=3
> Book1_C
> exist(cname$)=1 //1: existing dataset
Keep in mind that the long name doesn't have to be unique in the worksheet.
Hope this answers to your question.
--Hideo Fujii
OriginLab