Spire.XLS for .NET is a professional Excel .NET component that can be used to any type of .NET 2.0, 3.5, 4.0 or 4.5 framework application, both ASP.NET web sites and Windows Forms application.

Wed Apr 25, 2012 6:30 pm

I have problems by this:

Code: Select all
r =  mSpireRanges[mSpireRanges->Count-1]; // valid CellRange
String^ searchStr = "$F{"; //its a sample, this String is dynamically fill
String^ toSearch = searchStr + gcnew String("\*"); // "\*" this should do the placeholder
array<CellRange^,1>^ allFindRanges = r->FindAllString(toSearch,false,false);

How i can find all CellRanges with a String with placeholders?
This doesn't work for me.

Thanks in advance and Have a nice day !


Posts: 10
Joined: Mon Feb 20, 2012 2:39 pm

Thu Apr 26, 2012 7:40 am

Hi Lars,

Thanks for choosing Spire.Xls.

According to your description, we made a demo. Please have a look. We can use the regex to get the string with placeholders.

In case of any ambiguity, please feel free to contact us at any time.

Have a nice day.

Kind Regards
e-iceblue support
(6.37 KiB) Downloaded 308 times
User avatar

Posts: 154
Joined: Thu Oct 20, 2011 2:53 am

Return to Spire.XLS