Excel replace function for numbers


#1

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.


#2

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

xExcel.Replace(0, “-”)


#3

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

thx,
David


#4

Hi David,

You can get it in the next week.


#5

Is the replace function for numbers ready yet?


#6

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.