Apache Poi set Date Format on a column

Discussion in 'Java' started by ponzetta@gmail.com, Oct 3, 2005.

  1. Guest

    Hi, I use Apache Poi to read/write from/to Excel.

    I'm try to set a column of a sheet to show all values with correct
    format "m/d/yy"

    I'm used:

    HSSFCellStyle cellStyle = wb.createCellStyle();
    cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy"));
    HSSFCell cellaData = row.createCell(new Integer(0).shortValue());
    cellaData.setCellStyle(cellStyle);
    cellaData.setCellValue(data);

    This works fine, but format all cells of sheet and with much rows excel
    return a warning.
    I'm serching a method to format column entire.

    Thank's Lorenzo
     
    , Oct 3, 2005
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Si

    Apache POI Question

    Si, Dec 16, 2004, in forum: Java
    Replies:
    1
    Views:
    586
    TechBookReport
    Dec 17, 2004
  2. anand

    APIs similar to Apache POI

    anand, Jun 5, 2006, in forum: Java
    Replies:
    0
    Views:
    414
    anand
    Jun 5, 2006
  3. Replies:
    0
    Views:
    455
  4. Replies:
    9
    Views:
    6,895
  5. Fici
    Replies:
    0
    Views:
    556
Loading...

Share This Page