Hello,
It seems that when you upload a file using the dex::ReadFromFile (dex 23.1.1.2) and using an excel mapping structure like:
<AimmsExcelMapping>
<ExcelSheetMapping name="Demand">
<RowMapping>
uploading a wrong sheet name does not results in a failure which I would have expected to be.
Do I need to add something to the mapping? Or is this not how it supposed to work?
Glad to hear any feedback.
Marc
Best answer by MarcelRoelofs
DEX will iterate over all sheets in the workbook and will read the data if there is a mapping with either a name or name-binds-to attribute that matches the sheet.
Similarly, this is also true for JSON/XML mappings which do not complain when a mapped node is not present in the actual JSON/XML document
+6Hi Marc,
I am taking a look at this, let you know when I have more.
+5DEX will iterate over all sheets in the workbook and will read the data if there is a mapping with either a name or name-binds-to attribute that matches the sheet.
Similarly, this is also true for JSON/XML mappings which do not complain when a mapped node is not present in the actual JSON/XML document
Already have an account? Login
Please use your business or academic e-mail address to register
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
