Hi. I worked in Aspose Words and now I need to work on Aspose Cells. Currently I need to do a program that find special word in the worksheets and replace them. As Aspose Word does there is an Equivalent Class or Method IReplacingCallback or maybe something based on Regular Expression to find those word?
Thanks for using Aspose.Cells.
Please also check the Offline - Aspose.Cells for .NET Demos to getfamiliar of Aspose.Cells API(s) quickly.
These demos are available in C# and you can run them in Visual Studio 2005 , 2008 or 2010 or 2012 or 2015 or 2019 .
Please read the readme.txt file before running the demos.
You will also find there a Find & Replace demo as discussed in this article.
Hi, Thank you for both responses. I read about Smart Markers but I have some questions:
I tried this but occurs the same problem of the question 1.
Thank you Amjad for your response.
No problem Amjad. In the zip it’s the program and the file. The formula it’s at O11 cell.
Thanks for your posting and using Aspose.Cells.
It seems, you have forgotten to attach your complete project. Your attachment is just 475 bytes which contains a solution file of size 875 compressed bytes.
Please see the following screenshot for your reference and attach your complete archive to look into this issue.
You are right, my bad. Here its the correct zip file
Output Console by running the project:
Personal Monthly Budget [namePerson]
System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative
and less than the size of the collection.
We have fixed this issue.
Please download and try this fix: Aspose.Cells for .NET (Latest Version) and let us know your feedback.