Method FindRegex
FindRegex(string, XlsxFindOptions?)
Finds every match of a regular expression in the sheet's cells.
public IReadOnlyList<XlsxCellMatch> FindRegex(string pattern, XlsxFindOptions? options = null)
Parameters
patternstringThe .NET regular expression.
optionsXlsxFindOptionsHow to match, or null for the defaults.
Returns
- IReadOnlyList<XlsxCellMatch>
The matches, with their capture groups.
Exceptions
- ArgumentNullException
patternis null.- ArgumentException
patternis not a valid regular expression.- RegexMatchTimeoutException
A match attempt exceeded RegexTimeout.
- InvalidDocumentException
The sheet's part is malformed.