Find and replace CellType.IsNull of Range using ASPOSE

Aspose.Cells Product Family
1

Hi Team,

Again your ASPOSE user.

In my excel sheet, I set some blank cell to clearcontent. Now I want one by one clearcontent cell to replace it values.

Could you please tell me logic to find the CellType.IsNull cell only and replace it by any value, instead of going and checking each and every cell of Range.

There is some Find function, but not getting how to use it to get CellType.ISNULL cell only.

Thanks in advance.

Regards,

GUM

2

Hi GUM,

Thanks for your posting and considering Aspose.Cells.

For a workaround, please see the following post in your other thread.

( )