Method FindText
FindText(string, XlsxFindOptions?)
Finds every occurrence of a text in the workbook's worksheets. See FindText(string, XlsxFindOptions?).
public IReadOnlyList<XlsxCellMatch> FindText(string text, XlsxFindOptions? options = null)
Parameters
textstringThe text to find.
optionsXlsxFindOptionsHow to match, or null for the defaults.
Returns
- IReadOnlyList<XlsxCellMatch>
The matches, sheet by sheet in tab order.
Exceptions
- ArgumentNullException
textis null.- ArgumentException
textis empty.- InvalidDocumentException
A sheet's part is malformed.