Excel replace function for numbers


What is the proper syntax for replacing numbers in Aspose excel? I tried this syntax but it doesn’t work.

xExcel.Replace(“0”, “-”)

We have a client that wants to replace zeros with hyphens in her spreadsheets.


I will add a new Replace method to serve your need. Then you can use the following code:

xExcel.Replace(0, “-”)


Thanks so much for your help Laurence. Could you let me know when the hotfix is ready?



Hi David,

You can get it in the next week.


Is the replace function for numbers ready yet?


Yes. You can use this function in v3.0.5 now. Please check http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Excel.Replace9.html.