| |||||||||||||||||||||||||||||
Dense vs. sparse data format Description The example 'indexeg' shows how to read data tables with different formats from a spreadsheet:
A spreadsheet may be accessed from Mosel through an ODBC connection (using the odbc driver, indexeg.mos, or with SQL statements, indexeg2.mos), with the software-specific driver excel (indexeg3.mos), or with the portable mmsheet module that can be used to read and write xls, xlsx (indexeg5.mos) and csv (indexeg6.mos) files. Further explanation of this example: Xpress Whitepaper 'Using ODBC and other database interfaces with Mosel', Section Examples - Dense vs. sparse data format.
Source Files By clicking on a file name, a preview is opened at the bottom of this page.
Data Files
indexeg.csv ,,,, "Range3by2","First","Second",, ,1.2,2.2,, ,2.1,2.2,, ,3.1,4.4,, ,,,, ,,,, "Range2by3","First","Second","Third", ,1.1,1.2,1.3, ,2.1,2.2,2.3, ,,,, ,,,, "Range2by3i","Firsti","Secondi","Value", ,1,1,1.1, ,1,2,1.2, ,1,3,1.3, ,2,1,2.1, ,2,2,2.2, ,2,3,2.3, ,,,, "RectRange","Firsti","Second_1","Second_2","Second_3" ,1,1.1,1.2,1.3 ,2,2.1,2.2,2.3 | |||||||||||||||||||||||||||||
© Copyright 2024 Fair Isaac Corporation. |