Method FindWildcards
FindWildcards(string, XlsxFindOptions?)
Finds every match of an Excel wildcard pattern in the workbook's worksheets. See FindWildcards(string, XlsxFindOptions?).
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
A sheet's part is malformed.