Table of Contents

Method FindRegex

Namespace
DocWright.Formats.Xlsx
Assembly
DocWright.Formats.Xlsx.dll

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

pattern string

The .NET regular expression.

options XlsxFindOptions

How to match, or null for the defaults.

Returns

IReadOnlyList<XlsxCellMatch>

The matches, with their capture groups.

Exceptions

ArgumentNullException

pattern is null.

ArgumentException

pattern is not a valid regular expression.

RegexMatchTimeoutException

A match attempt exceeded RegexTimeout.

InvalidDocumentException

A sheet's part is malformed.