search

nissl-lab / npoi

a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
Apache License 2.0
5.74k stars 1.43k forks source link

Add API for SearchText for xlsx,xls #1323

Closed softboy99 closed 7 months ago

softboy99 commented 7 months ago

NPOI Version Used

2.7.0

File Type

Use Case

Description

Add API for SearchText for xlsx,xls

tonyqus commented 7 months ago

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

softboy99 commented 7 months ago

Input is the string, output is the ICell Range Object

tonyqus commented 7 months ago

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 commented 7 months ago

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