search cell in excel file

[mi...@free.fr]

hello !

is it possible to find a particular cell with String option?
thank!


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org

Re: search cell in excel file

[Ricardo Lopes <A4...@alunos.ipca.pt>]

I fyou are looking for something like:

 sheet.getCell("G8");

I think there is not such method. But you can emulate that parsing the 
String to get the cell/row numbers and using the HSSFSheet.getRow() to 
get the row object and after that use the HSSFRow.getCell() in the row 
object to get the cell.

Note that you have to convert the String character to a number in order 
to get the cell, A=0, B=1, and the cell number are also zero-base. example:
G8 = row : 7, col : 6


mickael.plistat@free.fr wrote:

>hello !
>
>is it possible to find a particular cell with String option?
>thank!
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
>
>  
>

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org