Add API for SearchText for xlsx,xls

[softboy99]

NPOI Version Used

2.7.0

File Type

• XLSX
• XLS

Use Case

Description

Add API for SearchText for xlsx,xls

[tonyqus]

Please clarify the input and output of this API. And PR contribution are welcomed.

[softboy99]

Input is the string, output is the ICell Range Object

[tonyqus]

Iterating the rows and cells with NPOI is very easy. I don't think it worths creating a SearchText method and returns the cells since the performance may not be so good if there are huge numbers of data.

[softboy99]

Hi @tonyqus ，
you can try, the performance is very slow