Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Message-ID: <E58DC1ED41D5D411AAEE00B0D078F16208EF7A14@arnie.collegeview.com>
From: Amol Deshmukh <adeshmukh@hobsons-us.com>
To: 'POI Users List' <poi-user@jakarta.apache.org>
Subject: RE: green icon in the cell
Date: Wed, 19 Oct 2005 16:56:56 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"

Murali,

Setting the cell type will not help.
Also, when you setCellValue(..) the cell type is
set internally by hssf.

You need some logic in your code that converts the
field to the appropriate type before inserting it
into excel. (You can infer the correct type based 
on whether the string parses to a number etc.)

HTH,
~ amol


> -----Original Message-----
> From: Murali Krishna [mailto:murali_padavala@yahoo.com]
> Sent: Wednesday, October 19, 2005 4:46 PM
> To: POI Users List
> Subject: RE: green icon in the cell
> 
> 
> Hi Amol,
>  
> I am getting the numeric as string from the database. when I 
> am getting the string dynamically, I dont know whether it 
> contains only numbers or characters. so I can declare that as int.
>  
> I tried setting the cell type to all possible combinations 
> like (String, numeric, Formula, Error). but still getting the 
> same issue like before. 
> 
>  
> Thanks,
> Murali
> 
> 
> Amol Deshmukh <adeshmukh@hobsons-us.com> wrote:
> 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:murali_padavala@yahoo.com]
> > 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 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: 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! 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/
> 
> 
> 		
> ---------------------------------
>  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/