The desired effect can be obtained by writing ('X'-65) .. its a valid
java code fragment, you know :). So this is a perfectly valid way.. some
times.But it wont always work since column references can be two letters. In which case I would point you to see the code in org.apache.poi.hssf.util.CellReference#convertColStringToNum(String ref) Regards - Avik On Mon, 2003-11-10 at 18:30, Nagaraj_K wrote: > Yea Suppose if I pass 'A' I should get 0 as A is the 1st column. > Can you please explain how to obtain this desired effiect... > > Nags > > > > -----Original Message----- > From: Avik Sengupta [mailto:[EMAIL PROTECTED] > Sent: Monday, November 10, 2003 6:10 PM > To: POI Users List > Subject: Re: Columns > > > something to the effect of 'X'-65 > > > On Mon, 2003-11-10 at 18:13, Nagaraj_K wrote: > > How can I access the column number if I pass the column name.. say A, B, C > > etc.... Is there any POI Class which can be used for this ?? > > > > > > Nags > > > > ************************************************************************** > > > This email (including any attachments) is intended for the sole use of the > > intended recipient/s and may contain material that is CONFIDENTIAL AND > > PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying > or > > distribution or forwarding of any or all of the contents in this message > is > > STRICTLY PROHIBITED. If you are not the intended recipient, please contact > > the sender by email and delete all copies; your cooperation in this regard > > is appreciated. > > ************************************************************************** > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > ************************************************************************** > This email (including any attachments) is intended for the sole use of the > intended recipient/s and may contain material that is CONFIDENTIAL AND > PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or > distribution or forwarding of any or all of the contents in this message is > STRICTLY PROHIBITED. If you are not the intended recipient, please contact > the sender by email and delete all copies; your cooperation in this regard > is appreciated. > ************************************************************************** --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
