Solved

dex::ReadFromFile not checking sheet name

  • 6 February 2024
  • 3 replies
  • 36 views

Userlevel 1
Badge +4

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

icon

Best answer by MarcelRoelofs 8 February 2024, 09:16

View original

3 replies

Userlevel 5
Badge +6

Hi Marc, 

I am taking a look at this, let you know when I have more. 

Userlevel 4
Badge +5

Hi @Marc Wingender 

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

Userlevel 1
Badge +4

@MarcelRoelofs , thanks for the reply, this clarifies the behavior. We will seek for another approach to improve our checks. 

 

Reply


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator