poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Leen Toelen <toe...@gmail.com>
Subject Re: green icon in the cell
Date Wed, 19 Oct 2005 06:31:52 GMT
Hi,

setCellType to the rescue:

void 	setCellType(int cellType)
          set the cells type (numeric, formula or string)

Regards,
Leen Toelen

On 10/19/05, Murali Krishna <murali_padavala@yahoo.com> wrote:
> Hi,
> I am getting a small green icon in the cell when i insert a string which is numeric data
in the excel cell. the exact message is "the number in this cell is formatted as text or preceded
by an apostophe".
>
> is there anyway I can get rid of that. Below is the sample code that I wrote.
>
> Thanks,
> Murali
>
>
> public class IntFormatting {
>  public static void main(String ar[]){
>
>     HSSFWorkbook wb = new HSSFWorkbook();
>      HSSFSheet sheet = wb.createSheet("format sheet");
>      HSSFCellStyle style;
>      HSSFDataFormat format = wb.createDataFormat();
>      HSSFRow row;
>      HSSFCell cell;
>      short rowNum = 0;
>      short colNum = 0;
>
>      row = sheet.createRow(rowNum++);
>      cell = row.createCell(colNum++);
>      String s="1234343";
>
>      cell.setCellValue(s);
>
>      String file = "c:\\intformatting.xls";
>      try{
>       FileOutputStream fileOut = new FileOutputStream(file);
>       wb.write(fileOut);
>       fileOut.close();
>      }
>      catch(IOException ioe){
>       ioe.printStackTrace();
>      }
>      System.out.println("output written to file : " + file);
>  }
> }
>
>
>
> ---------------------------------
>  Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
>

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