poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lakshmi Prabha <lakshmi...@yahoo.com>
Subject Re: Problem on custom format on existing worksheet
Date Fri, 06 May 2005 20:14:36 GMT
Hi,
sorry, I don't see any issue in your code given. 
Anyhow, if you could give us the exact scenerio in
which the problem is coming, (where this is coded?
formats.add( ind, i.next() ); )
and some sample data that you are trying to populate
in the date field, may be we get a solution.
Regards,
Lakshmi
--- Lakshmi Prabha <lakshmipct@yahoo.com> wrote:
> Try using,
> HSSFDataFormat.getFormat("dd/MM/yyyy");
> 
> mm --> denotes minutes in time format. So, for
> months
> we need to use "MM".
> 
> Hope it works.
> Regards,
> Lakshmi
> --- Sancho Chiang <chiangpak@hotmail.com> wrote:
> > Hi,
> > 
> > I am currently writing an API for writing list of
> > objects into excel worksheet. 
> > POI works great but when it comes to appending
> data
> > to an existing worksheet, 
> > existing custom data format cannot be applied to
> the
> > cells. I found that the 
> > indexes of the existing custom format ain't
> properly
> > mapped.
> > 
> > I drilled into the source code and I got to the
> line
> > which I guess it's the 
> > source of the problem.
> > 
> > at HSSFDataFormat.getFormat(String)line:235
> > -->  formats.add( ind, i.next() );
> > 
> > I am new to POI and not familiar with the source
> > code. I guess what the above 
> > code does is to populate the builtin data format
> > into "formats", where custom 
> > formats are already in there. Since it is using
> > add(), the existing custom 
> > formats are pushed to the right of the list if the
> > given index is smaller than 
> > those existing custom formats. That messes up the
> > mapping between index and 
> > data format. I don't know whether it's the problem
> > of my code or a known bug. I 
> > hope some guys who are nice enough to clarify the
> > problem. Thx.
> > 
> > This is the code i used:
> > 	public static void testDataFormat()throws
> > Exception{
> > 		InputStream input = new
> > FileInputStream("players.xls");
> > 		POIFSFileSystem fs = new POIFSFileSystem(input);
> > 		HSSFWorkbook wb = new HSSFWorkbook(fs);
> > 		HSSFSheet sheet = wb.getSheet("Sheet1");
> > 		HSSFRow row =
> > sheet.createRow(sheet.getLastRowNum()+1);
> > 		HSSFCell cell = row.createCell((short)0);		
> > 		HSSFCellStyle cellStyle= wb.createCellStyle();
> > 		HSSFDataFormat dataFormat =
> wb.createDataFormat();
> > 		short format =
> dataFormat.getFormat("dd/mm/yyyy");
> > 		System.out.println("excelFormat::"+format);
> > 		cellStyle.setDataFormat(format);
> > 		cell.setCellStyle(cellStyle);
> > 		cell.setCellValue(new Date());
> > 			
> > 		FileOutputStream fileOut = new
> > FileOutputStream("players.xls");
> > 		wb.write(fileOut);
> > 		fileOut.close();		
> > 	}
> > 
> > Regards,
> > Sancho Chiang
> > 
> > 
> >
>
---------------------------------------------------------------------
> > 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/
> > 
> > 
> 
> 
> 		
> __________________________________ 
> Yahoo! Mail Mobile 
> Take Yahoo! Mail with you! Check email on your
> mobile phone. 
> http://mobile.yahoo.com/learn/mail 
> 
>
---------------------------------------------------------------------
> 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/
> 
> 


		
__________________________________ 
Yahoo! Mail Mobile 
Take Yahoo! Mail with you! Check email on your mobile phone. 
http://mobile.yahoo.com/learn/mail 

---------------------------------------------------------------------
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/


Mime
View raw message