The workbook or worksheet has some "search" or "find" method?
I need to search for a value in a sheet or a book.
Hello,
Thank you for posting in our community.
I have been investigating the "search" or "find" behaviors you are looking for in the Infragistics Excel Library and I determined that currently, there is no built-in way to automatically do a find. However, you can achieve this by looping through the rows elements in the worksheet.rows() class, and then the cell elements in the worksheet.rows().cells() class. A sample loop for this would look like the following:
const rowsCount = worksheet.rows().count; for (let i = 1; i < rowsCount; i++) { const row = worksheet.rows(i); const cellsCount = row.cells().count; for (let j = 0; j < cellsCount; j++) { const cell = row.cells(j).value; } }
There you can check the value of each of the cell elements and whether it contains the content that you are looking for.
Please let me know if you need any further assistance with this matter.