![]() | |||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||
Reading 3-dimensional arrays Description This example shows how to read a 3-dimensional array from an excel file (threedimarr.mos) and from a generic spreadsheet (threedimarr5.mos). Model versions (2) and (4) show the same example for databases, and model version (6) works with data in CSV format.
Source Files By clicking on a file name, a preview is opened at the bottom of this page.
Data Files
threedimarr3.mos (!******************************************************* Mosel Example Problems ====================== file threedimarr3.mos ````````````````````` Reading 3-dimensional arrays. - Using 'initializations from' with Excel - (c) 2010 Fair Isaac Corporation author: S. Heipcke, July 2010, rev. Apr. 2014 *******************************************************!) model "ThreeDimArr (Excel)" uses "mmsheet", "mmodbc" declarations I: range J: set of string K = 1..5 ! The last index set must be defined in the model A,B: dynamic array(I,J,K) of real end-declarations initializations from 'mmsheet.excel:partndx;threedim.xls' A as 'Tab_23' end-initializations writeln("A: ") forall(i in I, j in J, k in K | exists(A(i,j,k))) writeln("A(", i, ",", j, ",", k, "): ", A(i,j,k)) (! initializations from 'mmodbc.odbc:debug;partndx;threedim.xls' B as 'Tab23odbc' end-initializations writeln("B: ") forall(i in I, j in J, k in K | exists(B(i,j,k))) writeln("B(", i, ",", j, ",", k, "): ", B(i,j,k)) !) end-model
| |||||||||||||||||||||||||||||||
© Copyright 2023 Fair Isaac Corporation. |