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

Free Support Forum - aspose.com

Find and replace CellType.IsNull of Range using ASPOSE

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

Hi GUM,

Thanks for your posting and considering Aspose.Cells.

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

( )