I have a datasource with some columns which include some null value. What I want to implement is that
after SmartMarker processing, the result now is including null value, I want to replace the null value with specific value in the Excel result or Html result. Is there is an automatic way to implement this ? Before sending this topic I try to process the datasource directly by manually replacing the null value, but I found this can effect the SmartMarker processing eg: &=A(group) 、subtotal and I may get a wrong result or an exception. So I found, to implement this I must process the result that has been processed by the aspose rather than the datasource prepared for the SmartMarker.
AsposeTest 2.zip (124.5 KB)
Above is a sample code, the result now is the output file:
image.png (80.8 KB)
what I want is the A6 null value can be replaced with eg: helloworld
image.png (55.5 KB)
Hope for your help, thanks!