(!****************************************************** Mosel Example Problems ====================== file listinout3.mos ``````````````````` Reading/writing lists from/to spreadsheets or databases via ODBC. - Using 'initializations from' with the excel driver - (c) 2008 Fair Isaac Corporation author: S. Heipcke, Nov. 2007, rev. Dec. 2012 *******************************************************!) model "List handling (Excel)" uses "mmsheet" parameters CSTR = 'mmsheet.excel:listdata.xls' end-parameters declarations R: range LI: list of integer A: integer LS,LS2: list of string end-declarations initializations from CSTR LI as "List1E" A as "AE" LS as "List2E" end-initializations ! Display the lists writeln("LI: ", LI) writeln("A: ", A, ", LS: ", LS) ! Reverse the list LI reverse(LI) ! Append some text to every entry of LS LS2:= sum(l in LS) [l+" "+A] ! Display the modified lists writeln("LI: ", LI) writeln("LS2: ", LS2) initializations to CSTR LI as "List1EOut" LS2 as "List2EOut" ! Output into a row LS2 as "grow;List2EGOut" ! Output into a column end-initializations end-model