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
View original
+6
Hi Marc,
I am taking a look at this, let you know when I have more.
Hi
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
Already have an account? Login
Please use your business or academic e-mail address to register
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Didn't find what you were looking for? Try searching on our documentation pages:
