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 535 times
-
Suvi.Wu
-
- Posts: 154
- Joined: Thu Oct 20, 2011 2:53 am