i came cross a hard work and i need your kindly support.
(1) i define the task numbers use the variable "TaskNum"
(2) i need another two variables ,one is one-dimensional array( a[TaskNum] ) and another is two-dimensional array( aa[TaskNum][TaskNum] ).The size of both the two varibales is relatived with the variable "TaskNum";
(3)when we want to automatically import data from excel and set the size of one-dimensional array in opl script , we usually write this:a from SheetRead (sheet,"Sheet1!A1:A"+TaskNum) ;
here comes the problem ,when i want to translate data from excel to .dat. the ordinate is similar to the one-dimensional array but the abscissa is the character like "a","aa","ac".how can i correspond the charater with the variable "TaskNum".
Thanks for you anttention and best regards!