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 <[EMAIL PROTECTED]> 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:[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 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/ --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
