Method FindWildcards
FindWildcards(string, XlsxFindOptions?)
Finds every match of an Excel wildcard pattern in the sheet's cells: ? any one character, * any run, ~ before either for the character itself.
public IReadOnlyList<XlsxCellMatch> FindWildcards(string pattern, XlsxFindOptions? options = null)
Parameters
patternstringThe pattern, as typed into Excel's Find (see XlsxWildcards).
optionsXlsxFindOptionsHow to match, or null for the defaults.
Returns
- IReadOnlyList<XlsxCellMatch>
The matches.
Exceptions
- ArgumentNullException
patternis null.- ArgumentException
patternis empty or longer than 255 characters.- RegexMatchTimeoutException
A match attempt exceeded RegexTimeout.
- InvalidDocumentException
The sheet's part is malformed.