How to write a null value into a Excel cell

Aspose.Cells Product Family
1

Hi,

I'm using Aspose.Cells 7.3.4.5 and it seems that when writing a string.Empty value is not seen as Empty by Excel (well this is seen as empty in sheet columns filters but not in pivot tables), so is there a way to really write a null value ?

May be this way :

object value = null;

cell.PutValue(value);

Thanks

2

Hi,


Could you create a sample console application, zip it and post it here to show the issue regarding pivot tables, we will check your issue soon. Also, attach your sample Excel file(s) here.

Thank you.
3

Forgot this one, we thought that when writing string.empty in a cell it will be threated as an empty value in excel which were wrong, we fixed it by writing null.

Thanks

4

Hi,


Good to know that you have sorted out your issue now.

Feel free to contact us any time if you need further help or have some other issue/query, we will be happy to assist you soon.

Thank you.