MsExcel
MsExcel Range
Example:
unit<uint32> Range : StorageName = "DRIVER={Microsoft Excel Driver (*.xls)};DBQ=%projDir%/data/Sheet.xls" , StorageType = "ODBC" , SqlString = "SELECT * FROM ImportSection ORDER BY ID" , SyncMode = "All" { attribute<int32> IntegerAtt; attribute<float32> FloatAtt; attribute<bool> BoolAtt; attribute<string> StringAtt; }
Data can be read from a named range of a Sheet in an Ms Excel file. See the MsExcel help for how to name a range. The name of the range is used in the FROM statement in the sqlstring property (ImportSection in the example). For MsExcel sheets, the storagename is directly configured to the domain-unit for the imported range.
The configuration of the DRIVER in the StorageName property and storagetype = “ODBC” is needed for the GeoDMS to recognise the file as an MsExcel ODBC source.
The configured attribute read the columns from the named range.