We have an excel sheet having cells with userdefined names. We are using RangeByName along with the iterator to activate/set the values in these cells. This is working perfectly fine when we are trying to retrieve cells having values(even blanks).
But, when we try to access a empty cell using its defined name, we are facing a null pointer exception.
I have attached a sample code where we have recreated this issue.Can you please let us know the solution for this or if there is any other way to do this ?
Do let us know if you need any additional information