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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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:
> > [EMAIL PROTECTED]
> > 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:
> [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
