Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Apr 25, 2012 6:30 pm

Hello,
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 !

Lars.

lameb
 
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
Suvi
e-iceblue support
Attachments
FindstringwithPlaceholder.zip
(6.37 KiB) Downloaded 529 times
User avatar

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

Return to Spire.XLS