Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) 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 373 times
User avatar

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

Return to Spire.XLS