Hi,
I need to search an excel sheet for specific text and then on finding it I
need to note the cell address (example a1:b2 etc) of the cell that has the
text. The I need to find the next occurrence of the same text within that
sheet and then again note the cell address. In VBA this would be
Cells.Find(What:="Table1", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False, SearchFormat:=False).Activate
&
Cells.FindNext(After:=ActiveCell).Activate
Is this possible through POI?
Kindly note that iterating through the entire sheet is not an option for me
as the data in an sheet may be very large.
Also If this is not possible using POI is there a way to interact with VBA
interface using java somehow?
Thanks for reading
--
View this message in context:
http://www.nabble.com/How-to-perform-Find-and-Findnext-on-and-excel-sheet-using-POI-tp25721755p25721755.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]
