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.

Reply via email to