AnsweredAssumed Answered

How to read(import) Excel 2-dimensional array by using Xpress.

Question asked by scchew@student.unimelb.edu.au on Aug 5, 2015
Latest reply on Aug 27, 2015 by Susanne.Heip

Hi there,

 

I have trouble reading a 2-dimensional array as an input in Excel.

I have tried to search from sources provided by FICO (getting started folioexcel.mos and Xpress_moselodbc doc) but with no success; examples are only given in 1-dimensional array.

 

As an example, following is a 2-dimensional input:

 

                 1      2      3       4

-----------------------------------------------

Amber  |   11     12     13     14

Billy     |   21     22     23     24

Cathy   |  31     32     33     34

Danny  |   41     42     43     44

 

How would I then read it as an input matrix Z: array(range, range) of integer?

 

Thanks in advance.

Outcomes