Solved

Data Exchange write out only nondefault values

  • 9 August 2022
  • 2 replies
  • 71 views

Badge

Hi,

 

Is there any attribute which can ensure that only nondefault values are written to Excel?

Like axll:WriteTable function has writeZeros argument and if it is set to 1 then zero cells will remain empty.

 

Thanks,

Lilla

icon

Best answer by MarcelRoelofs 13 August 2022, 23:10

View original

2 replies

Userlevel 5
Badge +6

heey @bedelillla ! 

yes, there is! if you are using axll::WriteTable or axll::WriteTableQuick you can use the argument IncludeEmptyRows, IncludeEmptyColumns or IncludeEmptyRowsColumns to ensure that only nondefault values are used, and the other way around as well. 

axll::WriteTableQuick(
    IdentifierReference     :  , 
    TopLeftCell             :  , 
    RowDimension            :  , 
    WriteZeros              :  0, 
    IncludeEmptyRows        :  0, 
    IncludeEmptyColumns     :  0, 
    IncludeEmptyRowsColumns :  0
)

Userlevel 4
Badge +5

Hi @bedelillla 

DEX 1.3.2.46 will now leave all Excel and CSV cells empty for default values, by default. You can overwrite this behavior by setting the write-defaults attribute to 1 for either individual ColumnMappings or for entire RowMappings. 

Prior this DEX 1.3.2.46, default values for regular ColumnMappings did show the defaults, while cells for name-binds-to ColumnMappings were left empty (unless you specified write-defaults). This has now been harmonized.

 

Reply


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

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