Hi,
We were using Aspose with version 5.0 previously. Now we have upgraded to Aspose 8.5.1.0.
As the FindString(string,cell) method is deprecated, we have replaced it with Find(object,cell,findoption). We are facing “object reference not set to an instance of an object” with the sheet.cells.Find method. Please let us know the specifications of the cellarea that has to be given to the findoptions in this case.
As an example,
Before upgradtion,
sheet.cells.Find(“Description”,nothing)
After Upgradation,
Dim area As CellArea
area.StartColumn = 0
area.EndColumn = sheet.Cells.MaxDataColumn
area.StartRow = 0
area.EndRow = sheet.Cells.MaxDataRow
Dim optionFind As FindOptions = New FindOptions
optionFind.SetRange(area)
sheet.Cells.Find(“description”, Nothing, optionFind)
Please help in resolving this issue.
Thanks,
Varsha