We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How to write a null value into a Excel cell

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

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.

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

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.