Table of Contents

Method FindWildcards

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

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

pattern string

The pattern, as typed into Excel's Find (see XlsxWildcards).

options XlsxFindOptions

How to match, or null for the defaults.

Returns

IReadOnlyList<XlsxCellMatch>

The matches.

Exceptions

ArgumentNullException

pattern is null.

ArgumentException

pattern is empty or longer than 255 characters.

RegexMatchTimeoutException

A match attempt exceeded RegexTimeout.

InvalidDocumentException

A sheet's part is malformed.