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
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
heey
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)
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.
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.
Didn't find what you were looking for? Try searching on our documentation pages: