here in second column value is coming zero , how to set it using x++ so it shows only non zero values
cell = null;
cell = cells.get_Item(currentRow, 11);
cell.set_Value(-1*vendSettlement.SettleAmountMST); its the code for column cells
You cannot show null values altogether for an int or real type field. If value is null as Komi suggested, it will be 0 or 0.0 based on the type. If it is a string, then null means empty string can be shown.
Hello,
SettleAmountMST field is of type real, the default value when empty is 0.
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156