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.