RE: HSSF has not 'HSSFRowllStyle' to set row style?How to set row sytle?thanks

["Donahue, Michael" <mi...@pearson.com>]

I'm not sure if this is what you are looking for or not.  If this isn't what
you are looking for perhaps you could post a commented version of you code
that show where you're having you problem...

HSSFCellStyle style = workbook.createCellStyle();

style.set ... ( ... );
style.set ... ( ... );
style.setDataFormat(HSSFDataFormat.getFormat("dd-mm-yyyy"));

cell.setCellStyle(style);

-----Original Message-----
From: Birendar Waldiya [mailto:bwaldiya@cisco.com] 
Sent: Wednesday, May 17, 2006 7:29 AM
To: 'POI Users List'
Subject: RE: HSSF has not 'HSSFRowllStyle' to set row style?How to set row
sytle?thanks

Hi Gurus , 

Can any one give me some pointer , that how POI decides a particular field
is a date field or 
A number ??/

Because I am facing a problem of following 
 While reading a excel file
I have a column in which I give date - initialy it reads as date no issues
now I try to change the date format to some say from  say dd-mon-yyyy to
other format dd/mm/yyyy & save it , now this never reads this date as date
but number 
Unless I delete the column and re- enter the date 

Needed pointers  urgently .
Thanks
Regrads 
Birendar S Waldiya  

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

**************************************************************************** 
This email may contain confidential material. 
If you were not an intended recipient, 
Please notify the sender and delete all copies. 
We may monitor email to and from our network. 
****************************************************************************

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

RE: HSSF has not 'HSSFRowllStyle' to set row style?How to set row sytle?thanks

[Birendar Waldiya <bw...@cisco.com>]

Hi Michael, 
First of all that a lot for replying , as I rarely get any reply . 

The Issue is not creating xls , I am using POI api to read a excel sheet
that that data with String and Date 

There is no problem with string , but the problem is with date column 

Lets say I have a column  "Sales Order Date"  and there are 10 rows with
some dates in say DD-MON-YYY

Column -->  COL1   COL2  COL3  SalesOrderDate   COL$   
Data   ---> ABC 	 JKL   200    23-May-2005     ITALY