Method FindRegex
FindRegex(string, XlsxFindOptions?)
Finds every match of a regular expression in the workbook's worksheets. See FindRegex(string, XlsxFindOptions?).
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
A sheet's part is malformed.