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
Solved
Data Exchange write out only nondefault values
Best answer by MarcelRoelofs
Hi
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.
+6heey
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)
+5Hi
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.
Sign up
Already have an account? Login
Please use your business or academic e-mail address to register
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.