Murali,
cell.setCellValue(123434343);
shoudl work. It seems that you are using
a string when you seem to want to set a
numeric value (?)
~ amol
> -----Original Message-----
> From: Murali Krishna [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 19, 2005 1:16 PM
> To: POI Users List
> Subject: Re: green icon in the cell
>
>
> Hi Leen Toelen,
>
> Thanks for the response. I have tried that before and after
> seeing your mail, with all the possible combinations of
> String, numeric, formula, error and blank. Still its not
> resolving my problem. Below is my code. please do let me
> know, whether i am making any mistake.
>
> 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.setCellType(HSSFCell.CELL_TYPE_STRING);
> 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);
> }
> }
>
> Leen Toelen <[EMAIL PROTECTED]> wrote:
> 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 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: [EMAIL PROTECTED]
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
>
> ---------------------------------
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
>
---------------------------------------------------------------------
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/
