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 sheet's cells: ? any one character, * any run, ~ before either for the character itself.

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

The sheet's part is malformed.