Thank I found the answer, it's easily possible through JExcelApi
(http://jexcelapi.sourceforge.net/).
the code is as below.
Cell tableStart=sheet.findCell(textToBeFound);
startRow=tableStart.getRow();
startCol=tableStart.getColumn();
Cell tableEnd= sheet.findCell(textToBeFound,startRow, startCol,
64000,
100, false);
endRow=tableEnd.getRow();
endCol=tableEnd.getColumn();
--
View this message in context:
http://www.nabble.com/How-to-perform-Find-and-Findnext-on-an-excel-sheet-using-POI-tp25721755p25722080.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
