Cells for Java find and replace function

Aspose.Cells Product Family
1

I am currently testing the latest cells for java, is there a find and replace function like in the .NET version because i can't seem to find it.

Instead i'm using something like this:

FindOptions option = new FindOptions();
option.setLookinType(FindOptions.MATCH_CONTAINS);

Cell c=null;
while((c=workbook.getWorksheets().getSheet(0).getCells().find("test", null, option))!=null){
System.out.println("test found replacing");
c.setValue(c.getStringValue().replace("test", "replaced"));
}

But I don't know if it is the way to go,

Thanks,

Kristof

2

Hi,


I think you are doing fine to find and replace the cell value. Currently, we don’t have replace feature, so, you have to find the cell value using Aspose.Cells for Java API and then simply replace the text accordingly by your code.

If you still need this feature, let us know on which level you need this functionality, I mean on Worksheet or Workbook level. After your confirmation, we will analyze your feature request and may support it soon.

Thank you.
3

Hi,

Thanks for the quick reply!
Ok then I'll keep using that method I just wanted to know if it was the right way.

Regards,

Kristof