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
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.
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)
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: